Connection string C# Entity Framework SQL Server Express

Question

I am using C# WPF EF6.0 and SQL Server Express for final program.

I have created a setup file with Advanced installer that creates database via script and SQL Server Express in

C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA

and I have changed my string connection from

<add name="MyDBEntities" 
     connectionString="metadata=res://*/MyDBModel.csdl|res://*/MyDBModel.ssdl|res://*/MyDBModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=(LocalDB)\v11.0;attachdbfilename=|DataDirectory|\MyDB.mdf;integrated security=True;connect timeout=30;MultipleActiveResultSets=True;App=EntityFramework&quot;" 
     providerName="System.Data.EntityClient" />

To this

<add name="MyDBEntities" 
     connectionString="metadata=res://*/MyDBModel.csdl|
                       res://*/MyDBModel.ssdl|
                       res://*/MyDBModel.msl;
                       provider=System.Data.SqlClient;
                       provider connection string=&quot;
                             Data source=.\SQLExpress;
                             integrated security=True;
                             MultipleActiveResultSets=True;
                             Initial Catalog=MyDB;
                             App=EntityFramework&quot;" 
     providerName="System.Data.EntityClient" />

I have installed .net Framework 4.5 and SQL Server 2012 sp1 v11.0.300 that I have used in Visual Studio 2013

When I install my program, everything works, but when I run my program it stopped working at first launch. I think the connection string has a problem. If I click debug in Visual Studio, I see this error

An unhandled exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll.Additional information: No connection string named 'MyDBEntities' could be found in the application config file.

if i click debug in visual show this error.=>An unhandled exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll.Additional information: No connection string named 'MyDBEntities' could be found in the application config file. — yasser93
– yasser93, Commented Sep 5, 2016 at 13:39

Green Falcon · Accepted Answer · 2016-09-05 14:06:25Z

1

The reason is that you have not attached the database files to the local database engine. try to use the appropriate SQL Server methods which are available. Your application (after installation) can not find the database in the local DB engine.

edited Sep 5, 2016 at 14:06

answered Sep 5, 2016 at 14:04

Green Falcon

8363 gold badges18 silver badges51 bronze badges

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

12 Comments

Green Falcon Over a year ago

Actually you are using installation process so it seems that you want your application to be portable so you should not use absolute path. and about the mentioned attribute I guess you should take a look at connectionstrings.com/sql-server-2012

Green Falcon Over a year ago

Have you included the database files to installer folders?

Green Falcon Over a year ago

It is logical that is not working, go to your sql server detach the database, copy files in a separate folder with enough privilege then include the db data and log files in your installation folders.

Green Falcon Over a year ago

Have they ever attached database in their installation?

Green Falcon Over a year ago

Look at these: stackoverflow.com/questions/20772846/… and codeproject.com/Articles/16231/…

|

Green Falcon · Accepted Answer · 2017-01-01 01:38:14Z

1

Finally I couldn't create a setup file with Advanced Installer. But I created it by Install Shield. My problem was insert or delete or edit from database. I installed my program in other drive and my problem solved. The reason was a joke that program files in C is readonly.

edited Jan 1, 2017 at 1:38

Green Falcon

8363 gold badges18 silver badges51 bronze badges

answered Sep 5, 2016 at 23:52

yasser93

631 silver badge11 bronze badges

Collectives™ on Stack Overflow

Connection string C# Entity Framework SQL Server Express

2 Answers 2

12 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

12 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related