General Development In DotNet

"I actually started out writing an article on how to pass 1, 2, and 3 dimensional "arrays" as parameters in stored procedures. Suddenly it dawned on me that a lot of people still have no clue what a "numbers" or "Tally" table is, never mind how it actually works."

"The Firebug command line provides these special functions for your convenience:"

"This is a question that I get very frequently, and I always tried to dodged the bullet, but I get it so much that I feel that I have to provide an answer. Obviously, I am (not so) slightly biased toward NHibernate, so while you read it, please keep it in mind. EF 4.0 has done a lot to handle the issues that were raised with the previous version of EF. Thinks like transparent lazy loading, POCO classes, code only, etc. EF 4.0 is a much nicer than EF 1.0. The problem is that it is still a very young product, and the changes that were added only touched the surface. I already talked about some of my problems with the POCO model in EF, so I won't repeat that, or my reservations with the Code Only model. But basically, the major problem that I have with those two is that there seems to be a wall between what experience of the community and what Microsoft is doing. Both of those features shows much of the same issues that we have run into with NHibernate and Fluent NHibernate. Issues that were addressed and resolved, but show up in the EF implementations."

"I couldn't find an example of doing AOP Method Interception using Ninject and Castle's DynamicProxy2 or LinFu DynamicProxy, so I consulted Ninject's Unit Tests and created my own sample. In the sample shown below, I will be using Castle's DynamicProxy2, but quite honestly I think you can use Linfu DynamicProxy by just swapping out the DynamicProxy2Module for the LinfuModule in the code below as well as referencing the Ninject.Integration.LinFu Assembly as opposed to the Ninject.Integration.DynamicProxy2 Assembly. By the way, there are some really good CodeProject article's on Linfu that I mentioned on PnPGuidance: LinFu Articles on CodeProject Well-Worth Reading."

"Unity 1.2 is about to be released anytime now, and one of the exciting new features is that the core interception technology from the Policy Injection Application Block has been moved to Unity. This allows one to do AOP with Unity without the need for Enterprise Library and the Policy Injection Application Block."

" Castle DynamicProxy is a library for generating lightweight .NET proxies on the fly at runtime. Proxy objects allow calls to members of an object to be intercepted without modifying the code of the class. Both classes and interfaces can be proxied, however only virtual members can be intercepted. "

"JavaScript Outlining * Outlines JavaScript codeblock regions for the code placed between { }. Both places on a new line. * Outlines custom regions defined by: o //#region - //#endregion o //#> - //#< CSS Outlining * Outlines JavaScript codeblock regions for the code placed between { }. Both places on a new line. * Outlines custom regions defined by: o /#region/ - /#endregion/ o /#>/ - /#

" Raphaël is a small JavaScript library that should simplify your work with vector graphics on the web. If you want to create your own specific chart or image crop and rotate widget, for example, you can achieve it simply and easily with this library. "

" The Closure Compiler is a tool for making JavaScript download and run faster. It is a true compiler for JavaScript. Instead of compiling from a source language to machine code, it compiles from JavaScript to better JavaScript. It parses your JavaScript, analyzes it, removes dead code and rewrites and minimizes what's left. It also checks syntax, variable references, and types, and warns about common JavaScript pitfalls. "

"Closure Inspector is an extension to Firebug, the Firefox debugger extension. Closure Inspector adds three powerful features to Firebug: source mapping, improved stack trace display, and unit test integration. This document describes how to install and use Closure Inspector."

"My workplace has been having issues with VS2010 picking up old assemblies since we have been using VS2010 on a complex services solution. The issue usually pops up when executing test runs with the built in support for MSTest. This occasionally happened in VS2008 but is much more prevalent in 2010. The scenario seems to be that somewhere between the IDE and MSTest is picking up assemblies from prior TestResults directories if the assembly can't be found in bin\Debug or bin\Release directories. This means that the normal clean operation under the build menu is not sufficient to get rid of this problem. Enter the sledgehammer. I wrote a little utility that will recursively go through each bin, obj and TestResults folder under the solution path and delete everything it can (including read-only files). Any exceptions encountered will be output to the console. The code itself is really simple."

"The Issue, in which Dylan gets bit in the ass by a legacy database I'm building some message-oriented-middleware (MOM?) for a 3rd party vendor product. The database has evolved over many years and has all of the quirks that you might expect of such a system: primary keys that are implied but not made explicit with constraints, relationships that are implied but not explicit, columns that are not nullable in the business logic but are nullable in the tables, etc. I'm not knocking the vendor: I am keenly aware that keeping a multipurpose database absolutely clean of cruft is a tough challenge indeed. But it does make for some really tough integration points. My major challenge over the past week has been auditing. The vendor system makes very heavy use of sprocs and embeds the creation of the audit trail in those sprocs rather than using what, to my mind, is the more obvious approach of triggers."

"NHibernate's listeners architecture bring with it a lot of power to the game, but understanding how to use it some of the listeners properly may require some additional knowledge. In this post, I want to talk specifically about the pre update hooks that NHibernate provides."

"Welcome to the Apache NMS project, the .NET Messaging API. This allows you to build .NET applications in C#, VB, or any other .NET language, using a single API to connect to multiple different providers."

"NuGet (recently renamed from NuPack) is a free open source developer focused package manager intent on simplifying the process of incorporating third party libraries into a .NET application during development. "

" This post is a summary of and collection of links to information about the quality of workspace provided to software developers. Perhaps it can be useful to other software developers in a position to influence managers or may someday be in a position to make decisions about workspace design themselves."

"If a SQL query has parameters, SQL Server creates an execution plan tailored to them to improve performance, via a process called 'parameter sniffing'. This plan is stored and reused since it is usually the best execution plan. Just occasionally, it isn't, and you can then hit performance problems, as Greg Larsen explains."

"Resource Governor is a new feature and one of the most anticipated management features in SQL Server 2008. It bolsters SQL Server performance by allowing DBAs to establish resource limits and priorities on processor and memory-related workloads and resource pools. By defining resource limits on resource consumption, it is possible to prioritize multiple workloads in order to ensure consistent performance and maximize the experience of the end users and the efficiency of the applications without degradation."

"Class-Level Model Validation with EF Code First and ASP.NET MVC 3 10 December 2010 11:05 AM"

"When I finished reading this post I let out a heavy sigh. It is not going to work. Basically, the EF is going the same way that NHibernate was in NHibernate 1.0 (circa 2005!)."