How to deploy a WinForm + database + EF6

Question

I just finished building a C# Windows Form (WinForm) application using Entity Framework 6 database first model, and after publishing it using Microsoft Visual Studio Installer projects , I have realized that the database has not been added to the application.   How can I attach the database along with the .EXE file? I have selected the needed prerequisites (.NET Framework and SQL Server Express).   I am using Entity Framework 6 (EF6) and my database has a username and password (SQL Server authentication).   I have already included the .mdf file in the project and in the output directory.   I have tried the solution here: https://stackoverflow.com/questions/32956142/how-to-deploy-application-with-sql-server-database-on-clients and here: https://stackoverflow.com/questions/25836156/how-to-deploy-sql-server-express-ef-application I have also tried to use SQL(localDB) instead of SQL Server Express, but it throws the same exception.   check the attached images below:

Ashutosh Gupta · Answer

go to properties of  your mdf file added unser dataconeection and copy the connection string and add into app.config file

Laxmidhar Sahoo · Answer

When create the entity it confifure the database . After that if you want connect to another database with same schema then just change the app.config    connectionStrings >    add   name = "cerviondemoEntities"   connectionString ="meta data =res://*/DatabaseModel.cervionEDM.csdl|res://*/DatabaseModel.cervionEDM.ssdl|res://*/DatabaseModel.cervionEDM.msl;provider=System.Data.SqlClient;provider connection string="data  source = DEVBOX ;initial  catalog = cerviondemo ;user  id = sa ; MultipleActiveResultSets = True ; App =EntityFramework ""   providerName = "System.Data.EntityClient"   />    connectionStrings >