Programming Forums > Application Development > C#

lawsonjoe · Dec 14th, 2007, 3:13 AM

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!

xavier · Dec 14th, 2007, 11:46 AM

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.

sharonmiller · Dec 14th, 2007, 11:26 PM

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!

ReggaetonKing · Dec 15th, 2007, 7:14 AM

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

xavier · Dec 15th, 2007, 2:32 PM

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

ReggaetonKing · Dec 15th, 2007, 11:26 PM

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

Dec 14th, 2007, 3:13 AM	#1
lawsonjoe Newbie Join Date: Dec 2007 Posts: 1 Rep Power: 0	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!

Dec 14th, 2007, 11:46 AM	#2
xavier Professional Programmer Join Date: Oct 2004 Location: .ro Posts: 383 Rep Power: 4	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. __________________ Don't take life too seriously, it's not permanent !

Dec 14th, 2007, 11:26 PM	#3
sharonmiller Newbie Join Date: Dec 2007 Posts: 1 Rep Power: 0	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!

Dec 15th, 2007, 7:14 AM	#4
ReggaetonKing Sexy Programmer Join Date: Nov 2005 Location: New Jersey Posts: 891 Rep Power: 3	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 __________________ I would love to change the world, but they won't give me the source code!

Dec 15th, 2007, 2:32 PM	#5
xavier Professional Programmer Join Date: Oct 2004 Location: .ro Posts: 383 Rep Power: 4	Re: C# Code Generator Just use an ORM an you won't have to worry about SPs for insert / update / delete ... __________________ Don't take life too seriously, it's not permanent !

Dec 15th, 2007, 11:26 PM	#6
ReggaetonKing Sexy Programmer Join Date: Nov 2005 Location: New Jersey Posts: 891 Rep Power: 3	Re: C# Code Generator I wish I knew about this sooner! Before starting our projects at work! We would have probably been done already. __________________ I would love to change the world, but they won't give me the source code!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Viewing VB's Automated code	john Wesley	Visual Basic .NET	3	Jun 8th, 2006 5:37 AM
FTP and return code fetching	Serinth	C	2	May 28th, 2006 11:05 PM
executing code in the data segment	para	C	1	Jan 4th, 2006 12:52 PM
String to Morse Code - Copying from string to string	Xenon	C	29	Nov 10th, 2005 2:30 PM
Help with code please	LiverLad	Java	0	Feb 9th, 2005 10:36 AM

Programming Forums > Application Development > C#

C# Code Generator