Connection to the database failed. Check that connection string is correct and DbContext constructor

Question

An error occurred accessing the database. This usually means that the connection to the database failed. Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application's config file. I swear I tried everything! Going through this tutorial and struggling to get connection to the database. My table in SQL Server 2012 is called, "tblEmployee" and the database is called "Sample" This is the Employee.cs class ``` [Table("tblEmployee")] public class Employee { public int EmployeeID { get; set; } public string Name { get; set; } public string City { get; set; } public string Gender { get; set; } } ``` This is the employee context model class ``` public class EmployeeContext : DbContext { public DbSet<Employee> Employees { get; set; } } ``` This is the EmployeeControler ``` public class EmployeeController : Controller { public ActionResult Details() { EmployeeContext employeeContext = new EmployeeContext();…

Accepted Answer

Soooo after quite a bit of struggle with this whole thing, this is what worked for me:

-1) Uninstalled SQL Server

-2) Reinstalled SQL Server and set a new Instance(INST01)

^^I don't think any of the above actually did anything.

-3) Reconnected to the new server with Visual Studio by going to the SQL Server Object Explorer and locating the new instance.

-4) Went back to SQL Server Management Studio and recreated my simple database.

-5) Under SQL Server Object Explorer I copied the connection string from the database properties.

-6) I changed the Web properties for the Project from Local IIS to IIS Express.

-7) Uninstalled EntityFramework 6

-8) Deleted any reference to Entity Framework in web.config file(this way the code for EF 5 would be inserted upon installation)

-9) Installed EntityFramework 5.0.0 from the Package Manager Console.

-10) Ran the application and it worked.

I'm not 100% sure what the issue was but I think it has something to do with Local IIS and IIS Express. I think changing the EF framework version was necessary to make sure the syntax for calling the table was consistent.

Keep in mind that before all of this, I could establish a connection to the database by simply going into the SQL Server Object Explorer. I could even pull up the table in Visual Studio and see the Data.

Hope this helps someone :)

Connection to the database failed. Check that connection string is correct and DbContext constructor

Solution

Problem

Related problems