Click here to Skip to main content
15,071,899 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
Hi There,

I have and edmx file and I want to generate all tables, store procedure, and view which is present in edmx file into sql server database.

Can anyone help me to solve this problem

What I have tried:

I have tried "Generate Database From Model" tool but it will generate only tables and it does not generate store procedures and views in sql server which is present in edmx, why?


https://aspblogs.blob.core.windows.net/media/gunnarpeipman/Media/ef40generatedatabasescriptfrommodel_07CB6C37.png
Posted
Updated 2-Jul-21 0:03am
v2

1 solution

Quote:
I have tried "Generate Database From Model" tool but it will generate only tables and it does not generate store procedures and views in sql server which is present in edmx, why?

Ask the people who created the tool - there are several different ways to do this as Google will easily show you.
We have no idea which tool you used, so we couldn't tell you "do this" if we wanted to!
   
v2
Comments
Member 11025896 2-Jul-21 6:05am
   
I have attached the Image link how I have used "Generate Database Script From Model".
https://aspblogs.blob.core.windows.net/media/gunnarpeipman/Media/ef40generatedatabasescriptfrommodel_07CB6C37.png

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