Add new table to an existing database using database first approach EF

Question

Now I'm using EF 6 database first in my solution , I have entities that pre-defined in the database. I now need to update the database and add tables !

I can't find the true way to follow

Hossein Narimani Rad · Accepted Answer · 2015-06-05 10:03:04Z

11

Open the edmx file and on a black space right click and use Update Model From Database...

enter image description here

edited Jun 5, 2015 at 10:03

answered Jun 5, 2015 at 9:55

Hossein Narimani Rad

32.7k19 gold badges92 silver badges121 bronze badges

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

2 Comments

Med Mans Over a year ago

using this solution , i must create the database table at the end-user with SQL Syntax i think ! have you other way to get migrations ?

Hossein Narimani Rad Over a year ago

@MedMANS As you said you are trying database first, I thought the table already exist. In this case I think you may want to try making the table here in the model (edmx file) and try using Generate Database from Model.

Bhargav · Accepted Answer · 2015-06-05 10:01:07Z

1

This is an alternative and the result is also much cleaner imo, you can also delete the .edmx file completely and remove the database connection string from you projects .config file. Then repeat the process of adding a new edmx file.

answered Jun 5, 2015 at 10:01

Bhargav

8,3176 gold badges43 silver badges63 bronze badges

1 Comment

Med Mans Over a year ago

i woul get migrations at the end user also !

Collectives™ on Stack Overflow

Add new table to an existing database using database first approach EF

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related