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