Data Tier Generator
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
Select the location to save the generated files and click OK
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.
Under “CS” folder, entity for Category table will be created
Under the sub folder “Repositories”, you can see the DAL layer file
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: DAL generator, Data tier generator · Posted in: C#, Code Snippet, SQL, Tools
Leave a Reply