Asp.net MVC: the underlying provider failed to open.

Question

Help me where I am wrong

 

Here with I attach my mvc code.

 

#view

@model Mvcpractice1.Models.Employee
@{
ViewBag.Title = "Employee Details";
}
<h2>Employee Details</h2>
<table>
<tr>
<td>
<b>Employee Id:</b>
</td>
<td>
@Model.EmployeeId
</td>
</tr>
<tr>
<td><b>Employee Phoneno:</b></td>
<td>@Model.Phoneno</td>
</tr>
<tr>
<td><b>Employee Name:</b></td>
<td>@Model.Name</td>
</tr>
</table>

#controller

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Mvcpractice1.Models;
namespace Mvcpractice1.Controllers
{
public class EmployeeController : Controller
{
//
// GET: /Employee/
public ActionResult Index( int id)
{
EmployeeContext emp=new EmployeeContext();
Employee emp1= emp.Employees.Single(x=>x.EmployeeId == id);
return View(emp1);
}
}
}

#DbContetxt

namespace Mvcpractice1.Models
{
public class EmployeeContext:DbContext
{
public DbSet<Employee> Employees { get; set; }
}
}

#webConfig

<connectionStrings>
<add name="EmployeeContext" connectionString="Data Source=CHV8LTDBNC01\LENTRACSDB2008;Integrated Security=True ;Database=AdventureWorks2008" providerName="System.Data.SqlClient" />
</connectionStrings>

But this is yeilding

 

An exception of type 'System.Data.Entity.Core.EntityException' occurred in EntityFramework.SqlServer.dll but was not handled in user code

Additional information: The underlying provider failed on Open.

Answer 1

change this from your code(#DbContetxt);

namespace Mvcpractice1.Models
{
public class EmployeeContext:DbContext
{
public EmployeeContext:base("EmployeeContext")
{

}
public DbSet<Employee> Employees { get; set; }
}
}

Answer 2

Hi Sangeetha,

 

Kindly check whether your database credentials are correct? The issue will happen due to inproper connection. 

Answer 3

hi,

 

Seems like a connection issue. You can use the Data link properties to find if the connection is fine. Do the following:

• Create a blank notepad and rename it to "X.UDL"
• Double click to open it
• Under connections tab choose the server name/enter the name use the correct credentials and DB
• Click OK to save it.

Now open the file in Notepad and compare the connection string properties.