Converting Entity Framework connection string to SQL Server Express

Question

My project has an Entity Framework connection string but I want to connect to a SQL Server Express database, so I think I have to change the connection string to SQL Server Express - but how ?

I want to change below connection string. Is it also enough connect database just changing connection string for same SQL Server mdf file ?

<add name="MyEntities"
     connectionString="metadata=res://*/Model.MyEntities.csdl|res://*/Model.MyEntities.ssdl|res://*/Model.TravldbEntities.msl;
     provider=System.Data.SqlClient;
     provider connection string=&quot;Data Source=sandiego;
                                Initial Catalog=mydatabse;Persist Security Info=True;
                                User ID=user;Password='password';MultipleActiveResultSets=True&quot;"
     providerName="System.Data.EntityClient" />

Aaron Bertrand · Accepted Answer · 2011-08-17 20:19:52Z

1

What have you tried? I'm not familiar with EF, but why not just try something similar to how a normal C# app would connect:

<add name="MyEntities"
 connectionString="provider=System.Data.SqlClient;
    Data Source=sandiego; -- maybe needs to be sandiego\SQLEXPRESS?
    User ID=user;
    Password=password;">

I would only specify the MARS attribute if you know for sure you need it.

answered Aug 17, 2011 at 20:19

Aaron Bertrand

282k37 gold badges469 silver badges468 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 10:34:23Z

0

Instead of this:

 Data Source=sandiego

Use this:

 Data Source=SomeMachineNameOrIP\SQLExpress

Here's another similar answer.

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Aug 17, 2011 at 20:15

p.campbell

101k70 gold badges263 silver badges326 bronze badges

2 Comments

AnyOne Over a year ago

If it is local mdf file ? Do i have to give full path ?

Aaron Bertrand Over a year ago

If you have a database already attached to a SQL Express instance, no it is not a path to an MDF file, it's a reference to an instance of SQL Server Express.

Collectives™ on Stack Overflow

Converting Entity Framework connection string to SQL Server Express

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related