在Web.config文件中查找连接字符串,确保它是正确的。例如:
打开DbContext类并确认是否正确配置:
public class MyDbContext : DbContext
{
public MyDbContext() : base("DefaultConnection")
{
// ...
}
public DbSet MyEntities { get; set; }
}
尝试从数据库中读取数据以确认连接是否正常:
public ActionResult Index()
{
using (var db = new MyDbContext())
{
var myEntity = db.MyEntites.FirstOrDefault();
return View(myEntity);
}
}
确保在执行保存之前调用SaveChanges()方法:
public ActionResult Edit(MyEntity entity)
{
using (var db = new MyDbContext())
{
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
}