Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

How to generate database, tables, store procedure and views from .edmx

Home
Forums
.NET

How to generate database, tables, store procedure and views from .edmx

afzal ansari

5yAsked Jul 2, 2021, 7:41 AM549.NET

Hi All,

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.

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 which is present in edmx, why?

Can anyone help me to solve this problem?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

afzal ansari5y ago
Thanks for your reply.
But this solution did not work for me.
Because I have not a database(tables, SP, Functions, and View) this is loss or deleted.
But I have an MVC project that has edmx file which contains 100 of (tables, SP, Functions, and View).
I want to generate all (tables, SP, Functions, and View) from my existing edmx file.
Please help me know I can achieve it.

Thanks in advance.
Sachin Singh5y ago
follow my article on this
https://www.sharpencode.com/article/EntityFramework/database-first-approach/what-about-store-procedure-and-functions