Auto-generate a data access layer in C# and T-SQL from a SQL database

DataTierGenerator is a .NET desktop app that generates a C# class, a C# data class and several SQL stored procs for every table in the database you specify. This takes a lot of the hassle out of creating a data layer for a multi-tier application – all you have to do is tweak the logic classes and T-SQL if required.

The generated code uses SharpCore Data Access and Utilities components, but can easily be changed to use your own classes, and I can see it being adaptable to work with Microsoft Enterprise Library Application Blocks. There is a DataTierGenerator that uses the MS Enterprise Library, but I have not tested it as yet.

Current version of the app is 4.3 with a Visual Studio 2005 source project, and it runs just fine with MS SQL Server 2005.

No Comments Yet

No comments yet.

Comments RSS TrackBack Identifier URI

Leave a comment