Data Access Guidance Package on CodePlex - Code Generating a Data Access Layer
by David Hayden ( Florida ASP.NET C# SQL Server Developer )
The other day I wrote a post on enabling the Data Access Guidance Package in your Web Client Software Factory Solution:
Enable Data Access Guidance Package in Web Client Software Factory Solution - Code Generation
At the end of the post I questioned “What is happening with the Data Access Guidance Package?”
Soon after my post, up pops a message in the Web Service Software Factory Forums announcing a new CodePlex Project just for the Data Access Guidance Package. Awesome. Here is the project.
I am personally excited that this guidance package lives on, because I think it is a good example of how to create a well refactored data access layer using design patterns and principles. It is also a pretty dang productive code generator by generating business entities, repository classes, stored procedures, etc.
This isn't to say that it is perfect, but it is certainly a great starting point if not a complete solution for your projects.
Quite some time ago I actually took the guidance generated and put it in my own database explorer and code generator that I mentioned before. Here is an old picture from the old post:
Although not shown, you can right click on various nodes in the treeview above to generate all kinds of classes, stored procedures, etc.
Anyway, if you have an interest in all things data access like I do, I think you will find the project pretty cool.
Source: David Hayden ( Florida ASP.NET C# SQL Server Developer )