"Although I feel perfectly comfortable in a set-based world writing SQL, it has traditionally been one of my least favorite areas of coding. Besides being relatively repetitive and tedious, at least when it comes to basic CRUD operations, sprocs are much more difficult to handle when it comes to source control, versioning, debugging, and unit testing."

and

"Regardless of the approach taken, I definitely no longer believe that sprocs should play any significant role in any application."

I couldn't agree more!  Read the full article: http://www.caffeinatedcoder.com/just-say-no-to-manual-crud/

 

Barry

The introduction of Automatic Properties in C# 3 (VS 2008) means that the snippet for creating properties (prop) now generates a singleline of: public type Property { get; set;}
However, if you are working in .Net 2 and still want to use the old snippet, just follow the link below. (adds a propc snippet that generates the .Net 2 properties ;)

http://wpfcontrols.blogspot.com/2008/01/vs-2008-property-code-snippet.html

This is cool:

http://code.google.com/appengine/docs/whatisgoogleappengine.html