How to create database from the C# code in MVC 4 project

Question

I am working on MVC 4 web app using Entitiy framework 5. I have an users membership database and an administration which divides data of the website into factories and for each factory i need a different database. Here is where my problem comes :

I need to create a new database into the master with predefined tables and stored procedures with sql script from the C# code. But for this i cannot use entity framework as i saw. I have found some ways with ado sql command calls, but it requires to mix up EF with raw ado.net .

My question is:

Is there a way to execute sql script for creating a whole database from the C# code using EF5 somehow ?

For now the only way that i have found is this : Code to create & connect to a SQL Server database: Whats wrong with it?

Any suggestions would be heplful. Thanks

stackoverflow.com/questions/4833650/… maybe helps you

MustafaP
– MustafaP

2014-02-03 15:21:06 +00:00
Commented Feb 3, 2014 at 15:21 — MustafaP
– MustafaP, Commented Feb 3, 2014 at 15:21

Gjohn · Accepted Answer · 2014-02-03 15:17:28Z

1

Look at EntityFramework with code first deployments.

See this http://msdn.microsoft.com/en-us/data/jj193542.aspx

answered Feb 3, 2014 at 15:17

Gjohn

1,2811 gold badge8 silver badges12 bronze badges

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

Comments

user3959430 · Accepted Answer · 2014-08-20 08:51:09Z

1

Create the database and then use this tutorial : http://msdn.microsoft.com/en-us/data/jj200620.aspx. This should help

answered Aug 20, 2014 at 8:51

user3959430

431 silver badge5 bronze badges

Collectives™ on Stack Overflow

How to create database from the C# code in MVC 4 project

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related