Entity framework 6.0 简明教程 ef6
http://www.entityframeworktutorial.net/code-first/entity-framework-code-first.aspx
Ef好的教程
Entity Framework的乐观并发
http://www.cnblogs.com/Gyoung/archive/2013/01/18/2866649.html
附件:EntityFramework系列:MySql的RowVersion
EF里一对一、一对多、多对多关系的配置和级联删除
EntityFramework系列:Repository模式与单元测试
1. Nuget安装好EF6.0.
2. 定义IDbContext , 定义context并实现
/// /// 提供对象列表的一切操作接口 /// public interface IDbContext : IDisposable { Database Database { get; } /// /// Get DbSet /// /// Entity type /// DbSet IDbSet Set() where TEntity : BaseEntity; /// /// Save changes /// /// int SaveChanges();
/// <summary> /// 继承自DbContext, IDbContext, /// 为什么IDbContext接口里面的属性和方法, 全部在DbContext里面有实现, 因此这里不需要做实现 /// </summary> public class NopObjectContext : DbContext, IDbContext { public NopObjectContext() : base("name=DefaultConnection") { //超时时常 ((IObjectContextAdapter)this).ObjectContext.CommandTimeout = 180; //这句代码指定我们是自己手动生成数据库 //Database.SetInitializer<XEngineContext>(null); } /// <summary> /// 覆盖DbContext里面的Set属性, 主要是为了自定义的BaseEntity. /// </summary> /// <typeparam name="TEntity">Entity type</typeparam> /// <returns>DbSet</returns> public new IDbSet<TEntity> Set<TEntity>() where TEntity : BaseEntity { return base.Set<TEntity>(); } protected override void OnModelCreating(DbModelBuilder modelBuilder) { //来自Nopcommerce里的动态加载所有的fluent api映射 dynamically load all configuration //System.Type configType = typeof(LanguageMap); //any of your configuration classes here //var typesToRegister = Assembly.GetAssembly(configType).GetTypes() modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();//去掉ef自建表的时候命名带复数 modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>(); //全局删掉级联删除, 因为不常用.移除这个默认约定,再在需要开启级联删除的FluentAPI关系映射中用. WillCascadeOnDelete(true) 单独开启 var typesToRegister = Assembly.GetExecutingAssembly().GetTypes() .Where(type => !String.IsNullOrEmpty(type.Namespace)) .Where(type => type.BaseType != null && type.BaseType.IsGenericType && type.BaseType.GetGenericTypeDefinition() == typeof(EntityTypeConfiguration<>)); foreach (var type in typesToRegister) { dynamic configurationInstance = Activator.CreateInstance(type); modelBuilder.Configurations.Add(configurationInstance); }; base.OnModelCreating(modelBuilder); }
下面来一个多对多的配置
下面是映射的map
如果用的联合主键的话.
![]() |
![]() 这里的主键数量必须和表的主键数量相同 |
public class Student { public int ID { get; set; } public string Name { get; set; } public int SiteID { get; set; } public virtual ICollection Courses{get;set;} } public class Course{ public int ID{get;set;} public string Name { get; set; } public int SiteID { get; set; } public virtual ICollection Students { get; set; } } public class SCContext : DbContext { public SCContext() : base("name=DefaultConnection") { Database.SetInitializer(null); } protected override void OnModelCreating(DbModelBuilder modelBuilder) { //dynamically load all configuration //System.Type configType = typeof(LanguageMap); //any of your configuration classes here //var typesToRegister = Assembly.GetAssembly(configType).GetTypes() modelBuilder.Conventions.Remove(); modelBuilder.Entity().ToTable("Student").HasKey(x => new { x.ID, x.SiteID }) .Property(x => x.ID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity); modelBuilder.Entity().ToTable("Course").HasKey(x => new { x.ID, x.SiteID }) .Property(x => x.ID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity); //modelBuilder.Entity().Property(x => x.Name); modelBuilder.Entity().HasMany(x => x.Courses) .WithMany(x => x.Students) .Map(r => { r.ToTable("Student_Course_Mapping"); r.MapLeftKey(new string[]{"StudentID", "StudentSiteID"}); r.MapRightKey(new string[] { "CourseID", "CourseSiteID" }); }); base.OnModelCreating(modelBuilder); } }
下面是一对一
![]() 同样在UserAccount里增加 ![]() |
![]() UserExt依赖于UserAccount |
最后是一对多
![]() 在UserAccount里增加 ![]() |
![]() 写在UserAddressMap里. 这个表里有外键, 依赖于UserAccount. ![]() |
最后来一发表结构
本人在长沙, 有工作可以加我QQ4658276