EF CODE FIRST连接MYSQL 时碰到的问题

1.MODEL，类型无法支持版本控制

     /// <summary>
        ///     获取或设置 版本控制标识，用于处理并发
        /// </summary>
        //[ConcurrencyCheck]
        //[Timestamp]
        //public byte[] Timestamp { get; set; }
     

2.在DbContext，定义的类对应表名会自动在表名后缀在S
解决：

 //解决EF动态建库数据库表名变为复数问题
            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();

3.The type ‘Tracking’ is mapped as a complex type. The Set method, DbSet objects, and DbEntityEntry objects can only be used with entity types, not com…
导致原因:MODEL 类，实体类的名字与数据表名不一致，区分大小写
解决：可在类上重定义表名

[Table(“member”)]
public class Member : Entity

4.EntityType ‘Member’ has no key defined. Define the key for this EntityType.
Members: EntityType: EntitySet ‘Members’ is based on type ‘Member’ that has no keys defined.
原因：没有主KEY
解决： [Key]
public string UserName { get; set; }