Brownie's Blog

This post will serve as a summary of my posts related to my not very scientific analysis of data access layers.  These posts won't be tutorials but more pointers to things I liked/didn't like about each method as well as the main bits of interesting code. 

For more detail grab the code from: http://code.google.com/p/browniesbikes/.  Along with the code is also my NUnit tests.

DataReaders and Stored Procs:

• Listing Data
• Retrieving a single item - implemented post coming soon
• Inserting Data - implemented post coming soon
• Updating Data - implemented post coming soon

TableAdapters:

• Listing Data
• Retrieving a single item - implemented post coming soon
• Inserting Data - implemented post coming soon
• Updating Data - implemented post coming soon

NHibernate:

• Implemented - posts coming soon

LinqToSQL

• Implemented - posts coming soon

SubSonic

• partially implemented

Data Access Application Block (Enterprise Library)

• meaning to implement it someday.