Problem accessing database for Entity Framework

Question

I've created a windows forms application that would use a client server model for accessing database. I created a connection for Entity Framework Model and it works fine with the following connection string:

connectionString="metadata=res://*/CartonOrderModel.csdl|
                           res://*/CartonOrderModel.ssdl|
                           res://*/CartonOrderModel.msl;
                  provider=System.Data.SqlClient;
                  provider connection string=&quot;
                  Data Source=.\SQLEXPRESS;
                  AttachDbFilename=E:\Databases\RollMeasurements.mdf;
                  Integrated Security=True;
                  Connect Timeout=30;
                  User Instance=True;
                  MultipleActiveResultSets=True&quot;"
providerName="System.Data.EntityClient"

I wonder if this connection string would still work when i deploy it on client environment which has a central db server and more than one instance of my app would be accessing it from client machines.

I tried changing the connection string to this:

connectionString="metadata=res://*/CartonOrderModel.csdl|
                           res://*/CartonOrderModel.ssdl|
                           res://*/CartonOrderModel.msl;
                  provider=System.Data.SqlClient;
                  provider connection string=&quot;
                  Data Source=.\SQLEXPRESS;
                  Initial Catalog=RollMeasurements;
                  User ID=sa;
                  Password=sapassword;
                  Connect Timeout=30;
                  User Instance=True;
                  MultipleActiveResultSets=True&quot;"
providerName="System.Data.EntityClient"

But now when I run my app it gives me this exception:

Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed.

Please help me with this. Thanks!

Slauma · Accepted Answer · 2011-08-14 13:54:34Z

2

I think you have to remove User Instance=True (or set it to False explicitely). User Instances are local copies of a SQL Express database and not suited for work in a multiuser environment with a central DB.

answered Aug 14, 2011 at 13:54

Slauma

177k60 gold badges407 silver badges424 bronze badges

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

Comments

BonScott · Accepted Answer · 2011-08-14 13:45:05Z

0

I think if you want to access to a central server, you need to change the Data Source=.\SQLEXPRESS; line to a central sql server instance.

english is not my mother language so maybe dont understand correctly the question.

Cheers

answered Aug 14, 2011 at 13:45

BonScott

1

Collectives™ on Stack Overflow

Problem accessing database for Entity Framework

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