If your model look something like:
using System;
using System.Data.Entity;
using System.ComponentModel.DataAnnotations;
using System.Data.Entity.Infrastructure;
namespace MvcApplication3.Models
{
public class MyTable
{
[Key]
public int MyNum { get; set; }
public string Name { get; set; }
}
public class MyTableDBContext : DbContext
{
public DbSet MyTable { get; set; }
}
}
Then, your connection string in Web.config must look like:
<add name="MyTableDBContext" connectionString="Data Source=MyPC; Initial Catalog=MyDb; Integrated Security=False; Persist Security Info=True; User ID=myUser; Password=myPass" providerName="System.Data.SqlClient" />
Note that MyTableDBContext is in connection string and defined as DbContext in the model, and Integrated Security is false (true means to Windows Authentication)