Solved

C#.NET Data Access Layer Code Generator?

Posted on 2014-04-10
2
6,910 Views
Last Modified: 2014-04-16
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
Comment
Question by:trzesniakj
2 Comments
 
LVL 18

Accepted Solution

by:
dj_alik earned 500 total points
ID: 39994617
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
 

Author Comment

by:trzesniakj
ID: 40004708
Thanks Sage!  Suggestions 1 and 3 were the most relevant to my situation.  I wound up using #1 in my PoC.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now