Addendum to my question from yesterday: C# class from sql database

Question

This is my link: link text

Thought about it and this was my additional question:

Now If i am going against stored procedures, is there an easy way without using T4, LLCodeGen, Codesmith, subsonic, etc..to obtain the input/output params and types if i wanted to generate my own data access layer

This is ASP.Net 2.0

Answer 1

Look into something called the Object-Relational Mappings, or ORM. There are lots of good tools that will automate most of the data layer code for you: NHibernate, Castle Active Record, SubSonic etc.

Answer 2

Adding to Joel Coehoorn's ORM list, you could also consider SubSonic. I've found it to be insanely easy to use, and it supports direct access to your procs, views and tables as you deem necessary.

You'd be much better off using an existing tool rather than rolling your own code gen. (Not that you couldn't roll your own, but why reinvent the wheel -- especially with so many good options out there?)