Auto Generate Gets and Sets from a Database

Question

I am coming from VB6 and I am starting to convert an existing VB6 code to VB.Net. What tools can I use to automate this task?

Answer 1

I would probably look into using an OR/M like nHibernate, LINQ to SQL, Entity Framework, Subsonic etc. It'll give you a lot lot more, but it's probably better than to autogenerate CRUD operations.

Answer 2

If you're looking for a complete code generator for your data access layer and entities LLBLGen is a good tool. If you only looking for a tool that simply generates entity classes Wilson OR Mapper is my favorite.

Also CodeSmith and .net Tiers Templates are very powerful.

Answer 3

Thanks, for you responses. Basically I want to create the factory classes that I use with my application. There are over 100 tables so you can understand my situation. I will take a look at the suggestions that you guys have made.

Thanks!