entity framework db first

Question

I have built my MVC 5 project based on entity framework Database First approach by following video tutorials. But what I have obtained is the model. There is nothing in the app_data folder. I want to obtain the .mdf file as well so that I can deploy the database to the azure.

Note: I'm using the server explorer database in VS2013.

ITevfik · Accepted Answer · 2014-11-11 10:37:36Z

1

I dont think you will be getting any .mdf files on app_data folder. To deploy your database to Azure:

Right click your database on SQL server, then Tasks->Generate Scripts. On scripting options, select sql azure server

enter image description here

Login to your azure account and create a SQL server and run generated script from the portal by clicking the link below:

enter image description here

while creating your EF connection, use the connection string for your Azure Database like:

At the end you should be ready to use your ORM.

answered Nov 11, 2014 at 10:37

ITevfik

1841 silver badge5 bronze badges

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

3 Comments

mohammad Over a year ago

How do I generate scripts again please?notice im using the server explorer on VS2013.My database is there.if I right click on it I don't have tasks-->generate scripts

ITevfik Over a year ago

Ok, on your server explorer right click to your Data Connection and select "Browse in sql server object explorer". On the new window, select your database to export the model, riht click and select "Extract data-tier application". Rest is simple. extract the generated file and your sql script is inside model.sql

mohammad Over a year ago

select your database to export the model??can't see mydatabase

Collectives™ on Stack Overflow

entity framework db first

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related