Solved

C#.NET Data Access Layer Code Generator?

Posted on 2014-04-10
2
7,060 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Run time Error 4 47
Windows Media Player 2 26
Cant save 3D 4 19
Firing an ASP.NET event on selection of a JQuery datepicker 4 15
After several hours of googling I could not gather any information on this topic. There are several ways of controlling the USB port connected to any storage device. The best example of that is by changing the registry value of "HKEY_LOCAL_MACHINE\S…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
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…

785 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