Solved

C#.NET Data Access Layer Code Generator?

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
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.

839 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