Joël Hébert | Opulent ASP Development Inc. - Tools http://www.opulentasp.com/ Enterprise ASP.NET en-us Opulent ASP Development Inc. Tue, 06 May 2008 13:21:46 GMT newtelligence dasBlog 2.0.7226.0 joel.hebert@opulentasp.com joel.hebert@opulentasp.com http://www.opulentasp.com/Trackback.aspx?guid=de631abd-96bf-4b56-9997-899816b07b91 http://www.opulentasp.com/pingback.aspx http://www.opulentasp.com/PermaLink,guid,de631abd-96bf-4b56-9997-899816b07b91.aspx Joel Hebert http://www.opulentasp.com/CommentView,guid,de631abd-96bf-4b56-9997-899816b07b91.aspx http://www.opulentasp.com/SyndicationService.asmx/GetEntryCommentsRss?guid=de631abd-96bf-4b56-9997-899816b07b91
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
http://www.codeproject.com/KB/database/dbhelper.aspx

 

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.

Here are the tools that I utilized during my N-Layering presentation http://www.opulentasp.com/PermaLink,guid,de631abd-96bf-4b56-9997-899816b07b91.aspx http://www.opulentasp.com/2008/05/06/HereAreTheToolsThatIUtilizedDuringMyNLayeringPresentation.aspx Tue, 06 May 2008 13:21:46 GMT <div><font size=2><span class=350144312-06052008>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</span></font> </div> <div><font size=2><span class=350144312-06052008></span></font>&nbsp; </div> <div><font size=2><span class=350144312-06052008>&nbsp;First and foremost here is the stored procedure wrapper that creates a nice strongly-typed class to wrap your stored procedures...great time saver!</span></font> </div> <div><font size=2><font face=Arial><font color=#000000><span style="FONT-SIZE: 11pt; COLOR: #1f497d"></span></font></font></font>&nbsp; </div> <div><font size=2><font face=Arial><font color=#000000><span style="FONT-SIZE: 11pt; COLOR: #1f497d"><strong>Stored procedure wrapper</strong> </span></font></font></font> </div> <div><font size=2><font face=Arial><font color=#000000><span style="FONT-SIZE: 11pt; COLOR: #1f497d"></span></font></font><span style="FONT-SIZE: 11pt; COLOR: #1f497d"><a title=blocked::http://www.codeproject.com/KB/database/dbhelper.aspx href="http://www.codeproject.com/KB/database/dbhelper.aspx" target=_blank><span lang=FR-CA title=blocked::http://www.codeproject.com/KB/database/dbhelper.aspx><font face=Arial color=#000000>http://www.codeproject.com/KB/database/dbhelper.aspx</font></span></a></span> </div> <div> <p> <span style="FONT-SIZE: 11pt; COLOR: #1f497d"><font face=Arial size=2></font></span>&nbsp; </p> <p> <span style="FONT-SIZE: 11pt; COLOR: #1f497d"><span class=350144312-06052008><font face=Arial color=#000000 size=2>Secondly&nbsp; , here is the code generator I demo-ed.</font></span></span><span style="FONT-SIZE: 11pt; COLOR: #1f497d"><span class=350144312-06052008><font color=#ff0000 size=1> </p> >>><span style="FONT-SIZE: 11pt; COLOR: #1f497d"><span class=350144312-06052008><span style="FONT-SIZE: 10.5pt; COLOR: #0033cc"> <p> <table cellspacing=0 cellpadding=0 width="100%"> <tbody> <tr> <td align=left> <font size=2><strong><span class=CCI_Header_Title id=ctl00_rs1_WikiContent_ctl01_HeaderTitle>Data Access Layer | Entity Layer | SQL Stored Procedure Generator Using Visual Studio 2005 &amp; C#</span> </strong></font></td> <td> <font size=2><span class=CCI_Header_Spacer id=ctl00_rs1_WikiContent_ctl01_Label2>&nbsp;&nbsp;&nbsp;&nbsp;</span> </font></td> <td class=CCI_Header_Actions align=right> <font size=2>&nbsp;</font></td> </tr> </tbody> </table> </p> <div class=CCI_Text id=ctl00_rs1_WikiContent_ctl01_EditorPanel ondblclick='document.location.href="http://msdn.microsoft.com/en-us/library/Community-Signup.aspx?ru=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2ffx6bk1f4(VS.80).aspx%3fwbi%3d23";' style="CURSOR: default"> <div class=" CCE_Editor_Disabled" onkeypress="javascript:return WebForm_FireDefaultButton(event, 'ctl00_rs1_WikiContent_ctl01_Editor_Save')" id=ctl00_rs1_WikiContent_ctl01_Editor_RadEditor title="Double-click to edit this block"> <p> <font color=#000000 size=2>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.</font> </p> <p> <font color=#000000 size=2>About C# Source Code Generator :<br> This Tool Generates Data Access Layer including respective stored procedures, associated Business layer <br> and Entity layer class which is shared between both Data Access layer and Business Layer.<br> It takes MSSQL connection string as input.</font> </p> <p> <font color=#000000 size=2>Benefits of using code generator:<br> 1) Rapid Application Development. Saves lots of time.<br> 2) It Uses Microsoft Application block which are optimised to transact with any database server with very less code.<br> 3) All code is generated according to Microsoft coding standards.<br> 4) No need to write stored procedures it generates for you.<br> 5) Code is maintainable and standard </font> </p> <p> <font color=#000000 size=2>Prerequisite to Generate classes<br> .NET Framework 2.0,Microsoft Application blocks</font> </p> <p> <font color=#000000 size=2>Prerequisite to Use classes<br> Visual Studio 2005 ,Microsoft Application blocks<br> </font> </p> <p> <font color=#000000 size=2>Enter Connection string in Connection string text Box <br> 2) Enter location path where you want to generated file to be saved <br> 3) Enter the desired root Namespace for all of your classes for ex. you can provide your company name or a project name etc. <br> 4) Click "Connect to database " Button <br> 5) Select the tables from the list and click "Generate Code " Button it will generate and save all the files to the provided location</font> </p> </span></span></span>> </div> > > <p> </p> <p> <a href="http://www.opulentasp.com/content/binary/CsharpCodeGenerator.zip">CsharpCodeGenerator.zip (18.58 KB)</a> </p> <p> &nbsp; </p> <p> 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. </p> <img width="0" height="0" src="http://www.opulentasp.com/aggbug.ashx?id=de631abd-96bf-4b56-9997-899816b07b91" /> http://www.opulentasp.com/CommentView,guid,de631abd-96bf-4b56-9997-899816b07b91.aspx Tools