Service-based Database connection string

Question

I'm using service-based database, so db file is stored with the program. It makes it easier for the end-user, when they can easily move the app with the db to another computer.

Here is my connection string for it:

add name="DBEnitity"
connectionString="metadata=res:///Model.csdl|res:///Model.ssdl|res://*/Model.msl;provider=System.Data.SqlClient;provider connection string="data source=SQLEXPRESS2008;attachdbfilename=|DataDirectory|\db.mdf;integrated security=True;user instance=True;multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />

But it won't connect if I test it on machine with a SQL Server Express 2012 installed. Why is that? Thanks!

does source=SQLEXPRESS2008 matter?

DJ Burb
– DJ Burb

2013-03-19 21:16:34 +00:00
Commented Mar 19, 2013 at 21:16 — DJ Burb
– DJ Burb, Commented Mar 19, 2013 at 21:16

Evgeny Gorb · Accepted Answer · 2013-03-19 21:28:00Z

0

You should use data source=. to connect to a default instance of sql server, or data source=.\SQLSERVERNAME for sql server named instance

answered Mar 19, 2013 at 21:28

Evgeny Gorb

1,5412 gold badges13 silver badges26 bronze badges

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

Comments

groenhen · Accepted Answer · 2018-01-27 21:48:48Z

0

You should use:

data source=.

where . means local SQL server.

edited Jan 27, 2018 at 21:48

groenhen

3,02725 gold badges51 silver badges69 bronze badges

answered Jan 27, 2018 at 17:32

user9271802

Collectives™ on Stack Overflow

Service-based Database connection string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related