C#中Entity Framework常见报错汇总

以下小编整理的Entity Framework常见错误的汇总，大家如果还有不明白可以在下面留言区讨论。

1 实体属性配置为IsRequired()对更新的影响

抛出异常类型DbEntityValidationException

表结构：

实体：

public class User
  {
    public int Id { get; set; }
    /// <summary>
    /// 账号
    /// </summary>
    public string Account { get; set; }
    /// <summary>
    /// 邮箱
    /// </summary>
    public string Email { get; set; }
    /// <summary>
    /// 昵称
    /// </summary>
    public string Nickname { get; set; }
    /// <summary>
    /// 头像
    /// </summary>
    public string AvatarId { get; set; }
    /// <summary>
    /// 记录插入时间
    /// </summary>
    public DateTime InsertTime { get; set; }
    /// <summary>
    /// 记录修改时间
    /// </summary>
    public DateTime UpdateTime { get; set; }
  }

　　　　　　　modelBuilder.Entity<User>().Property(u => u.Account)
        .IsRequired()
        .IsUnicode(false)
        .HasMaxLength(50);
      modelBuilder.Entity<User>().Property(u => u.Email)
        .IsRequired()
        .IsUnicode(false)
        .HasMaxLength(100);
      modelBuilder.Entity<User>().Property(u => u.Nickname)
        .IsUnicode(false)
        .HasMaxLength(50);
      modelBuilder.Entity<User>().Property(u => u.AvatarId)
        .IsOptional()
        .HasMaxLength(100);

[DbConfigurationType(typeof(MySqlEFConfiguration))]
  public class CustomDbContext : DbContext
  {
    public CustomDbContext()
      : base("name=Master")
    {
      
      this.Configuration.LazyLoadingEnabled = false; 
      //DropCreateDatabaseIfModelChanges
      //new DropCreateDatabaseAlways<CustomDbContext>()
      Database.SetInitializer<CustomDbContext>(null);
    }

    public DbSet<User> Users { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
      base.OnModelCreating(modelBuilder);
      EntityConfiguration.Set(modelBuilder);
    }
}

using (CustomDbContext db = new CustomDbContext())
{
          User user = new User 
          {
            Id = 1,
            Email = "test@1622.com",
          };
          DbEntityEntry<User> entry = db.Entry<User>(user);
          entry.State = EntityState.Unchanged;
          entry.Property(t => t.Email).IsModified = true;

          int num = db.SaveChanges();
}