?
Solved

C#.NET Data Access Layer Code Generator?

Posted on 2014-04-10
2
Medium Priority
?
7,484 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
dj_alik earned 2000 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
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…

764 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