Convert MS SQL Server Table to a C# Class

Question

I have a project that is using Entity Framework Code First but with an Existing Database. So far I have been creating the class for each existing table accordingly and it's all worked out great. What would be brilliant is if there was some way to quickly generate a table to a class to save time on manually coding each class, any ideas? I want to stay with Code First so please don't suggest alternatives, thanks.

So you want to use code first but generate your code? Seems like a chicken/egg problem. — D Stanley
– D Stanley, Commented Mar 9, 2013 at 23:07
I want to use Entity Framework but code only. Everywhere I look online defines this as "Entity Framework Code First with an Existing Database". — user1166905
– user1166905, Commented Mar 9, 2013 at 23:16

Prescott · Accepted Answer · 2013-03-09 23:02:00Z

1

You can use EF database first - that will generate .cs classes you can use as a base. Just copy the CS code and then delete the EF database first stuff.

answered Mar 9, 2013 at 23:02

Prescott

7,4225 gold badges52 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1166905 Over a year ago

As in create a seperate project to generate a one off set of classes, that does seem quite a simple and easy solution. Can you generate the class one table at a time with Database First or do you have to do all?

Prescott Over a year ago

Sure you can do one table at a time or select them all to get it done with. The GUI with EF is extremely easy to use. You don't have to make it in another project - but that will keep your configs clean.

Collectives™ on Stack Overflow

Convert MS SQL Server Table to a C# Class

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related