Simple ADO.NET C # Stored Procedure Generator
I am using Visual Studio 2005, Sql Server 2005, C #, ADO.NET. We have a very large database and new stored procedures are regularly added. I'm tired of writing C # wrapper code for these stored procedures, it seems like there should be some simple utility or Add In that will allow me to just point to the stored procedure and generate some generic C # code.
I am not looking for some big ORM interface for data access. The company I am doing this for is not interested in moving to something like this right now. Just want something to take the work away from writing C # wrappers around stored procedures. Again, we prefer that we don't have to include in other third party libraries, etc.
Any ideas?
source to share
I've evaluated many ORM modelers and code generators over the years, but none of them gave me the code I wanted. Over the past few years, in my spare time, I have created my own stored procedure and C # code generator.
The generator is very intuitive to use and generates CRUD stored procedures, data components, business components, and business objects. The generated code uses SqlDataReaders for its data retrieval and no reflection.
It will even generate an n-Unit test project.
Caching support is available through business objects as well as IoC for data components.
Performance tests comparing it to ADO.NET Entity Framework and Linq to SQL can be found on the site.
FrameworkGen can be found here http://www.elencysolutions.co.uk
source to share
I used "Code Smith". Worked like a charm.
A free trial is available, and if you automate the process, it pays for itself pretty quickly.
Take a look here: http://www.codesmithtools.com/?s=g1&gclid=COWj27vu_ZwCFVATzAod2GIxaw
source to share
Discard MyGeneration - a free tool for creating .NET-code with many templates to download and use for free. Must have what you are looking for. It is a free open source project that competes with a programmer.
source to share
Have a look at the C # SP Code Generator .
You can also check this old CodeProject article .
source to share
You can also use T4 templates. It is part of VS 2008, but you can download it in 2005 using the GAT toolkit .
Some useful links:
http://www.olegsych.com/2008/01/how-to-use-t4-to-generate-crud-stored-procedures/
http://www.buildmotion.com/buildmotion-blog/09-06-15/T4_Templates_for_Stored_Procedures.aspx
source to share
You may want to keep an eye on AtomWeaver ( http://www.atomweaver.com ), a flexible code generator that also implements the new ABSE (Atom, http://www.abse.info ) development model paradigm.
Well, it's still under development, but the launch is expected at the end of the year ...
source to share