3.EF6.0CodeFirst实现增删查改

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;namespace EF.Entity
{public abstract class BaseEntity{///

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;namespace EF.Entity
{///

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;namespace EF.Entity
{public class Publisher:BaseEntity{///

using EF.Entity;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.ModelConfiguration;
using System.Linq;
using System.Text;
using System.Threading.Tasks;namespace EF.Data
{public class BookMap:EntityTypeConfiguration{public BookMap(){//配置主键this.HasKey(s &＃61;> s.ID);//配置字段this.Property(s &＃61;> s.ID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);this.Property(s &＃61;> s.BookName).HasColumnType("nvarchar").HasMaxLength(50).IsRequired();// this.Property(s &＃61;> s.BookAuthor).HasColumnType("nvarchar(50)").IsRequired();//注意这个和BookName字段配置的区别之处:这样写EF生成不了数据库this.Property(s &＃61;> s.BookAuthor).HasColumnType("nvarchar").HasMaxLength(50).IsRequired();this.Property(s &＃61;> s.BookPrice).IsRequired();this.Property(s &＃61;> s.AddedDate).IsRequired();this.Property(s &＃61;> s.ModifiedDate).IsRequired();this.Property(s &＃61;> s.PublisherId).IsRequired();//配置关系[一个出版商可以出版很多书籍]【外键单独配置&＃xff0c;不是必须在Property中配置&＃xff0c;当然也可以在Property中配置】this.HasRequired(s &＃61;> s.Publisher).WithMany(s &＃61;> s.Books).HasForeignKey(s &＃61;> s.PublisherId).WillCascadeOnDelete(true);//配置表名字this.ToTable("Books");}}
}

using EF.Entity;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.ModelConfiguration;
using System.Linq;
using System.Text;
using System.Threading.Tasks;namespace EF.Data
{public class PublisherMap:EntityTypeConfiguration{public PublisherMap(){//配置主键this.HasKey(s &＃61;> s.ID);this.Property(s &＃61;> s.ID).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);// this.Property(s &＃61;> s.PublisherName).HasColumnType("nvarchar(50)").IsRequired();//这样写&＃xff0c;有问题&＃xff0c;生成不了数据库this.Property(s &＃61;> s.PublisherName).HasColumnType("nvarchar").HasMaxLength(50).IsRequired();this.Property(s &＃61;> s.AddedDate).IsRequired();this.Property(s &＃61;> s.ModifiedDate).IsRequired();}}
}

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Web;
using System.Web.Mvc;namespace EF.Web.Models
{public class PublisherModel{public PublisherModel(){PublisherList &＃61; new List();}[Display(Name&＃61;"PublisherName")]public int PublisherID { get; set; }public List PublisherList { get; set; }}
}

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Data.Entity.ModelConfiguration;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;namespace EF.Data
{public class EFDbContext:DbContext{public EFDbContext(): base("name&＃61;DbConnectionString"){ }protected override void OnModelCreating(DbModelBuilder modelBuilder){var typesToRegister &＃61; Assembly.GetExecutingAssembly().GetTypes().Where(type &＃61;> !String.IsNullOrEmpty(type.Namespace)).Where(type &＃61;> type.BaseType !&＃61; null && type.BaseType.IsGenericType&& type.BaseType.GetGenericTypeDefinition() &＃61;&＃61; typeof(EntityTypeConfiguration<>));foreach (var type in typesToRegister){dynamic configurationInstance &＃61; Activator.CreateInstance(type);modelBuilder.Configurations.Add(configurationInstance);} //base.OnModelCreating(modelBuilder);
}}
}

"DbConnectionString" connectionString&＃61;"Server&＃61;.;Database&＃61;EFCURDDB;uid&＃61;sa;Pwd&＃61;Password_1" providerName&＃61;"System.Data.SqlClient"/>

using EF.Data;
using EF.Entity;
using EF.Web.Models;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;namespace EF.Web.Controllers
{public class BookController : Controller{private EFDbContext db;public BookController(){db &＃61; new EFDbContext();}#region 列表///

&＃64;model EF.Entity.Book&＃64;{ViewBag.Title &＃61; "AddBook";
}

AddBook

&＃64;model EF.Entity.Book&＃64;{ViewBag.Title &＃61; "UpdateBook";
}

UpdateBook

&＃64;model IEnumerable&＃64;{ViewBag.Title &＃61; "Index";
}

Index

&＃64;Html.ActionLink("Create New", "AddBook")