Click here to Skip to main content
Click here to Skip to main content

C# DAL Method Code Generator

, 19 May 2008
Rate this:
Please Sign up or sign in to vote.
Generates C# data access layer method code for SQL Server stored procedures
Click to enlarge

Introduction

DAL Method Generator is a simple utility to generate data access layer methods in C# for SQL Server stored procedures. Have you ever written too many data access layer methods in C# to connect to SQL server stored procedures? This utility could save your effort using few clicks.

Using the Utility

C# DAL Method Generator is written using C# and you will require .NET Framework 2.0 to execute.

To use the utility, just invoke the EXE, which should open the Connect to SQL Server dialog below. It uses Windows authentication to connect to the SQL Server. Future work includes connecting to various other data stores like Oracle, etc. with other authentication as well.

Sample Image - maximum width is 600 pixels

Once connected to the server, you can drill down to see the databases and stored procedures for which you have permission.

Sample Image - maximum width is 600 pixels

To select all the stored procedures in a database, right click-on the node "Stored Procedures" and click "Add all Stored Procs to List". To add selected stored procedures, right click on them and choose, "Add to List". Selected stored procedures will appear on the right pane. Provide the method name for the C# method, by default the system uses the stored procedure name only. Also choose the return type for the method. By default, all methods generated return void.

Click to enlarge

To generate C# DAL methods, click on File -> Generate Code or the Generate Code Tool bar item. The code will be generated as below:

Click to enlarge

Points of Interest

I would like to extend it further to generate C# business entity, DAL method, basic CRUD stored procedures for the business entity based on table definitions and also to support other data stores.

History

  • 19th May, 2008: Initial post

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Saravanan.B

Singapore Singapore
No Biography provided

Comments and Discussions

 
GeneralMy vote of 5 PinmvpMd. Marufuzzaman21-Dec-11 3:14 
Very nice tool...thanks for sharing
GeneralGreate tool PinmemberMember 247899423-Apr-11 2:07 
GeneralWill this work for Oracle (ODP.Net) PinmemberHet210911-Jun-08 9:55 
GeneralRe: Will this work for Oracle (ODP.Net) PinmemberSaravanan.B12-Jun-08 4:56 
QuestionWhy not using DataTables? Pinmemberbytejaeger28-May-08 11:05 
GeneralGreat tool Pinmemberkalyankrishna120-May-08 0:00 
GeneralGreat tool. [modified] Pinmembermilan19-May-08 22:36 
GeneralRe: Great tool. Pinmemberdangrass3-Jun-08 9:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140718.1 | Last Updated 19 May 2008
Article Copyright 2008 by Saravanan.B
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid