C# Code Generator
 

Hi,

I am about to start writing an application using .NET Framework and SQL Server as the database manager. Even though I am an experienced developer, I would like to spend as less time as possible developing SQL stored procedures and the data access layer. I think that I should use a code generator that can assist me. As I have not yet used any C# code generator, I would rely on your experience and suggestions. Your recommendation will be highly appreciated.
Thanks in advance!

Re: C# Code Generator
 

Well, the latest from M$ when it comes to ORMs is Linq2Sql (only supports mssql).

Others would be Subsonic, which is rather young but interesting framework.
And then you have NHibernate and ActiveRecord which is based on NHibernate. ( the downside is that NH doesn't have a good code generator).

Oh, and if you're using an ORM, then you really shouldn't go with stored procedures. They generally don't mix.

Re: C# Code Generator
 

I would suggest to visit Tech-IS’s web site (http://www.techinceptions.com). Their C# code generator product (OxyGen Code) is available for download at the following URL: http://www.techinceptions.com/codegenerator.html. A friend of mine referred it to me a few days ago and after generating some sample code against our SQL Server databases, I decided to present it to my co-workers. Hope this will help you too.

Best of luck!

Re: C# Code Generator
 

For creating your stored procedures, I definitely recommend this tool. Saves us hours at work!
http://www.codeproject.com/KB/databa...spx?print=true

Re: C# Code Generator
 

Just use an ORM an you won't have to worry about SPs for insert / update / delete ... :D

Re: C# Code Generator
 

I wish I knew about this sooner! Before starting our projects at work! We would have probably been done already.