MVC 使用entity framework 访问数据库发布IIS

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

1. SQL SERVER 数据库内容

2. MVC工程

3. EF 参考

工程架构：

对应实体类：

public class MvcUser
{
public int Id { get; set; }
public string Name { get; set; }
public string PassWord { get; set; }
public int UserType { get; set; }
}

public class UserConfigurature:EntityTypeConfiguration<MvcUser>
{
public UserConfigurature()
{
ToTable("UserInformation");
HasKey(x => x.Id);
}
}

public class EFDbContext:DbContext
{
public DbSet<MvcUser> Users { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Configurations.Add(new UserConfigurature());
base.OnModelCreating(modelBuilder);
}
}

测试代码：（增删改都测试过）延迟加载

/// <summary>
/// 插入测试
/// </summary>
[TestMethod]
public void InsertTest()
{
context.Users.Add(new MvcUser()
{
Name = "EF测试",
PassWord = "wwwwww",
UserType =
});
context.SaveChanges();
} [TestMethod]
public void ModifyTest()
{
MvcUser user = context.Users.Find();
user.Name = "修改后";
context.SaveChanges();
} [TestMethod]
public void DeleteTest()
{
context.Users.Remove(context.Users.FirstOrDefault(x=>x.Id == ));
context.SaveChanges();
}