Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7819
  • Last Modified:

C#.NET Data Access Layer Code Generator?

Hi all,

Working in a MSFT env.  Would like your recommendations for a decent C#.NET code generator that will do the following:

Given tables in a schema, generate the stored procs for CRUD operations
Generate the C#.NET class libraries that will use the stored procs to access the data
Is non-ORM-based.  i.e. Does not use an ORM like MSFT Entity Framework.  I've recently seen a lot of code gens that use it.  That's OK.  Not judging an ORM or EF here.  But our org doesn't use EF and any ORM will be a support issue.
Allow the generated code to be extended.  I don't mean modifying the gen'd code.  I've used a generator previously that worked with partial classes.  Allowed me to extend functionality without affecting the generated code.
Free or low-cost
.NET v3.0, v3.5, or v4.0
VisualStudio 2010/2012

Just looking to produce a data access layer DLL based on about 12-15 tables.  Would even settle for a gen-once app where it creates the classes the first time and we extend manually.

I've worked with CodeSmith before and working with v7 now.  It tends to produce a lot more than we need.  

Any others anyone might care to recommend?

Thanks,

John
0
trzesniakj
Asked:
trzesniakj
1 Solution
 
dj_alikCommented:
Option 1:
A simple data access layer code generator using ADO.NET's DataSet and DataTable
http://dalcog.codeplex.com/

Option 2:
C# DAL Method Code Generator
http://www.codeproject.com/Articles/26191/C-DAL-Method-Code-Generator

Option 3:
Auto generate C# DAL, BLL classes and Sql Store Procedures.
http://dbs.codeplex.com/
0
 
trzesniakjAuthor Commented:
Thanks Sage!  Suggestions 1 and 3 were the most relevant to my situation.  I wound up using #1 in my PoC.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now