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.
Once connected to the server, you can drill down to see the databases and stored procedures for which you have permission.
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.
To generate C# DAL methods, click on File -> Generate Code or the Generate Code Tool bar item. The code will be generated as below:
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
