How to update ADO.net Entity Data model

Question

0.00/5 (No votes)

See more:

I have Entity Data model using auto generate from database.

Now, I want to Add another table in Entity Data Model .

I Right Clicked the .edmx file added Update model from Database and selected my table .

everything fine.i see my new Table in Layout Diagram but when i add new Controller with Scaffolding Options i don't find my new table model only i find only old table model . did i miss anything?

Assist me.

and i have referred this
http://msdn.microsoft.com/en-us/library/vstudio/cc716697%28v=vs.100%29.aspx[^]

Posted 24-Nov-14 9:16am

King Fisher

Updated 24-Nov-14 18:17pm

v2

Add a Solution

2 solutions

Solution 1

Supposing that your Entity Data Model is in a 2nd project/assembly, you have to build that project first than you can use it in you ASP.NET MVC project.

Posted 24-Nov-14 19:13pm

Raul Iloc

Comments

King Fisher 25-Nov-14 1:29am

I have builded my Solutions when i update table in Entity data Model.

Raul Iloc 25-Nov-14 1:45am

So it is working now or not?

King Fisher 25-Nov-14 1:55am

no sir,doesn't show any new models in the Scaffolding Options.its show only old models which i have selected while Creating the Entity data Models.
do i have to Delete the Data Model and Regenerate again?

Raul Iloc 25-Nov-14 2:01am

You should clean you solution, then rebuild all and try again.
If will not working, after these new steps, you should close then restart the Visual Studio.

King Fisher 25-Nov-14 2:04am

Is Build Solution and Rebuild Solution are different?

Raul Iloc 25-Nov-14 2:06am

Build- will build only the changed projects, rebuild -will build all projects from the solution.

King Fisher 25-Nov-14 2:13am

sorry, but i have only one Project in my Solution .just a clarification

King Fisher 25-Nov-14 11:22am

thanks.solution 2 worked ;) my 5+

Raul Iloc 26-Nov-14 1:28am

1.Thank you for your vote!
2.I recommend you to move the Data Entity Model part into a separate project. In generally is not OK to mix together data access code with user interface; think also about if supposing that you want to extend your solution and provide also some service (windows service or WCF) or other UI (for desktop by using WPF) and also these new module should access the same database!
3.If you will do like I suggested in my 2nd point, you will avoid also this kind of manual update EF issue.

King Fisher 26-Nov-14 1:34am

yes,i do sir. thanks for your guidance :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Suraj Sahoo | Coding Passion · Accepted Answer · 2014-11-24T19:47:00

Solution 2

Hello Sir,

Step1- You need to build the solution once after Updating and Validating the .edmx file.
Step2- Then you need to expand the .edmx file and look for the T4 template file, i.e. .tt extension file.
Step3- Right click on that and Run Custom Tool. This would update the .tt file with the newly added entity making a .cs file for that.

Hope this helps Sir.
Thanks.

Posted 24-Nov-14 19:47pm

Suraj Sahoo | Coding Passion

Updated 24-Nov-14 19:48pm

v2

Comments

King Fisher 25-Nov-14 11:21am

Its worked buddy .thank you my 5+

[no name] 25-Nov-14 11:31am

Thanks Sir. Happy my solution helped. :)