Create SQL Database using Entity Framework Code First ?

Question

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 ?

Ravi Patel · 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 />

Ravi Patel · Answer

ok you can use anyone of the following. datasource= . or datasource= localhost or datasource= ip address or datasource= sql server full name

Ravi Patel · Answer

DataSource = .; here using dot for your sqlserver name or give complete name of sqlserver

Ravi Patel · Answer

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 />

Rohit Mane · Answer

https://msdn.microsoft.com/en-in/data/jj193542.aspx Here All Process of creating Database structure using Entity framework 6 explained in detail.

Ammar Shaukat · Answer

Good.

Safa Arooj · Answer

No idea.

Ammar Shaukat · Answer

Alright. I wrote localhost there . that is also working fine. very thanks for your help .

Ammar Shaukat · Answer

and what to write in DataSource = ;

Ammar Shaukat · Answer

yes.

Ravi Patel · Answer

Hi  still you are facing any issue?

Ravi Patel · Answer

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 Shaukat · Answer

what is the difference between database name and Context Class name. ?

Ammar Shaukat · Answer

okay .

Ammar Shaukat · Answer

this is my app.config file. Version=6.0.0.0 Culture=neutral PublicKeyToken=b77a5c561934e089 requirePermission=false />

Ravi Patel · Answer

so add it in your App.config file

Ammar Shaukat · Answer

I don't have any connection string in my App.config file.

Asfend Yar · Answer

No idea Boss ....