Tuesday, May 06, 2008
« Effective N-Layering in ASP.NET | Main | What I am doing to become a better softw... »
Some of the members of the Ottawa .Net community were asking me to post the tools that I utilized during my N-layering presentation therefore I would like to bring them forth to my bloggers since they are superb
 
 First and foremost here is the stored procedure wrapper that creates a nice strongly-typed class to wrap your stored procedures...great time saver!
 
Stored procedure wrapper

 

Secondly  , here is the code generator I demo-ed.

Data Access Layer | Entity Layer | SQL Stored Procedure Generator Using Visual Studio 2005 & C#       

This Tool Generates Data Access Layer including respective stored procedures, associated Business layer and Entity layer class which is shared between both Data Access layer and Business Layer. It takes MSSQL connection string as input.

About C# Source Code Generator :
This Tool Generates Data Access Layer including respective stored procedures, associated Business layer
and Entity layer class which is shared between both Data Access layer and Business Layer.
It takes MSSQL connection string as input.

Benefits of using code generator:
1) Rapid Application Development. Saves lots of time.
2) It Uses Microsoft Application block which are optimised to transact with any database server with very less code.
3) All code is generated according to Microsoft coding standards.
4) No need to write stored procedures it generates for you.
5) Code is maintainable and standard

Prerequisite to Generate classes
.NET Framework 2.0,Microsoft Application blocks

Prerequisite to Use classes
Visual Studio 2005 ,Microsoft Application blocks

Enter Connection string in Connection string text Box
2) Enter location path where you want to generated file to be saved
3) Enter the desired root Namespace for all of your classes for ex. you can provide your company name or a project name etc.
4) Click "Connect to database " Button
5) Select the tables from the list and click "Generate Code " Button it will generate and save all the files to the provided location

CsharpCodeGenerator.zip (18.58 KB)

 

Thirdly, the orm tool that I showed is built into vs2008. Look only for instructions on linq to classes and you are good to go.

Tuesday, May 06, 2008 1:21:46 PM (GMT Standard Time, UTC+00:00)  #    Disclaimer  |  Comments [0]  |  Trackback Related posts:

Comments are closed.