Saturday, March 28, 2009

Finally my own Data Access Generator tool...

I’ve been struggling over the past few years in search of something that can reduce code development especially the unexciting Data Access Layer code, which is basically a wrapper to conform to a 3-tiered or n-tiered architecture.

I tried a few OR mappers and even gave the Table adapters from the .Net 2.0 Framework a fair shot. But I missed the bare code that I was so accustomed to seeing either due to the fear of performance issues or from hitting the wall down the road. I haven’t explored LINQ to justify my code generation tool and this is no LINQ killer I assure you.

But I did find that a simple code generation tool can achieve a great deal, especially restoring my confidence when it was rolled into production. For one thing the code was always debbugable. So I wrote my own little code generation tool that was based on text templates that you can hack at any time. It does the job and I used it for a couple of enterprise solutions successfully and would like to share the tool.

It’s based on stored procedures fro data access. It automatically generates select, update, insert and delete stored procedures and writes wrapper classes to access these stored procedures. Additionally you can write your custom stored procedures using a naming convention and it will generate the wrapper classes.

You can get a copy from here Click here!

In case anyone is interested in the source code you can email me.

No comments: