Mitch Rupp's .NET Blog

We've all had to write the same repetitive code over and over again such as the following in order to connect to a db.

• Write SQL code and create at least 4 stored procedures per table in the database (Insert, Update, Delete and Select SQL statement)
  
• Write SQL code and create custom stored procedures that will reflect the complexity of their database diagram (Example: write a SQL statement that can update several tables in one call, write SQL statement that can bring back data from several tables using inner join statement…)
  
• Write ADO.Net code (using VB .NET, C# .NET or whatever language supported by the .NET platform) that is responsible for calling those stored procedures. Developers have to take special care with the parameters type to be declared as long as the parameters direction (input, output…)
  
• Write abstract classes that map exactly to their database tables for easy data retrieving
  
• Write Windows or/and Web forms that can manage (Add, Update, Delete) their database tables content

Well supposedly the tool Olymars does this all for us.  Very, very interesting.

So far after an intial appraisal it looks very cool.

[Sean 'Early' Campbell & Scott 'Adopter' Swigart's Radio Weblog]

I really need to set aside some time and play with this.. I have been putting it off for too long..