Click here to Skip to main content
15,888,351 members
Please Sign up or sign in to vote.
2.60/5 (2 votes)
See more:
Hi, I have a sql database with about 100 tables. I am thinking to use code generator to create class library for these tables, basically CRUD operations. What is the best code generator out there? It should be free to use atleast for personal use. If I can like it, I can pursue employers to buy it. Free is better :) Thanks in advance for the help.
Posted

1 solution

Maybe I'm missing something here, but wouldn't something like Entity Framework be the best option? You can get it to generate your models and talk to them (basic CRUD) without having to actually write the code yourself.

Here is a basic tutorial on the steps you would take: http://auk-port.blogspot.com/2011/05/how-to-create-database-first-in-aspnet.html[^]

Basically, you point EF to your database, select the tables you want, and say Go and it creates all of your models. You can then perform CRUD operations on them using EF and the best part is that it is from Microsoft and not a third party library so it is free if you are using Microsoft tools already (I believe it even works with the Express editions, which are free).
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900