Create SQL Database using Entity Framework Code First ?

Ammar Shaukat

10y1.7k.NET

I'm working on entity framework code first. I make a table and context class . and run my project . Data is creating in Local C drive. I want to create this database by default into my SQL Server installed to my PC. does anyone know the way to do that ?

18 Replies

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

Ravi Patel10y ago
Accepted answer
Hi,

modify your connection string like this

here your context class name" connectionString="Data Source=.; Initial Catalog=databasename; user id=sa;password=*****; MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />
Rohit Mane10y ago
https://msdn.microsoft.com/en-in/data/jj193542.aspx

Here All Process of creating Database structure using Entity framework 6 explained in detail.
Ammar Shaukat10y ago
Good.
Safa Arooj10y ago
No idea.
Ravi Patel10y ago
ok

you can use anyone of the following.

datasource= . or
datasource= localhost or
datasource= ip address or
datasource= sql server full name
Ammar Shaukat10y ago
Alright. I wrote "localhost" there . that is also working fine. very thanks for your help .
Ravi Patel10y ago
DataSource = .; here using dot for your sqlserver name or give complete name of sqlserver
Ammar Shaukat10y ago
and what to write in DataSource = ,;
Ammar Shaukat10y ago
yes.
Ravi Patel10y ago
Hi ,

still you are facing any issue?
Ravi Patel10y ago
suppose i have given
Dbcontext" connectionString="Data Source=.; Initial Catalog=Employee; user id=sa;password=*****; MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />

here Dbcontext is your context class name
so it will create Employee database in sql server.
Ammar Shaukat10y ago
what is the difference between "database name" and "Context Class" name. ?
Ravi Patel10y ago
Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

here your context class name" connectionString="Data Source=.; Initial Catalog=databasename; user id=sa;password=*****; MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />
Ammar Shaukat10y ago
okay .
Ammar Shaukat10y ago
this is my app.config file.

Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
Ravi Patel10y ago
so add it in your App.config file
Ammar Shaukat10y ago
I don't have any connection string in my App.config file.
Asfend Yar10y ago
No idea Boss ....