Data Tier Generator

Data Tier Generator
9 votes, 4.56 avg. rating (91% score)

Introduction

I am really fan of any automation that will reduce development time. Sometimes simple things might take time though not complex. One good tool I came across is Data Tier Generator in CodePlex.

Data Tier Generator

Code can be downloaded from these links



Direct download – Data Tier Generator

CodePlex download – Data Tier Generator

 

You need to give your Database credentials.

For SQL end, it will generate all CRUD stored procedures for each database table

For C# end, it will generate entities, DAO layer to call all the stored procedures.

You need to click on “Generate” to create all files

image

 

Select the location to save the generated files and click OK

image

 

There will be two folders that gets created, “CS” and “SQL”. Under “SQL” folder you will see the stored procedures. In my example, I have only one table “EM_Category” in my database.

image

 


Under “CS” folder, entity for Category table will be created

image

 

Under the sub folder “Repositories”, you can see the DAL layer file

 

image

 

image

Conclusion

I am not big fan of Entity framework but rather interested in vanilla asp.net application sometimes. Personally appreciate the author “Adrian Anttila” for his good work.

His profile can be viewed on http://www.codeplex.com/site/users/view/aanttila

February 21, 2014 · Adi · No Comments
Tags: ,  · Posted in: C#, Code Snippet, SQL, Tools

Leave a Reply

What is 14 + 12 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)