1:首先新建项目,导入Entity Framework程序集
2,添加一个实体
public class StudentInfo
{
public int StudentId { get; set; }
public string StudentName { get; set; }
public string DateOfBirth { get; set; }
public string Photo { get; set; }
public int Height { get; set; }
public int Weight { get; set; }
}
3:新建一个DbContextClass类,继承DbContext
public class DbContextClass:DbContext
{
public DbContextClass()
: base("name=DbContextClass")//此处的name实在web.config中配置的
//<connectionStrings>
//<add connectionString="server=.;database=DbContextClass;uid=sa;pwd=123456" name="DbContextClass" providerName="System.Data.SqlClient"/>
// </connectionStrings>
{
Database.SetInitializer(new CreateDatabaseIfNotExists<DbContextClass>());//默认实例,数据库不存在则创建
}
public DbSet<StudentInfo> StudentInfo { get; set; }
//此方法实现所有 的实体类,所有需要创建表的实体必须在此方法中指明
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
//移除表名为复数
modelBuilder.Entity<StudentInfo>().ToTable("tset");//设置当前实体的表名
modelBuilder.Entity<StudentInfo>().HasKey(p => p.StudentId);//设置主键
//自动添加实现EntityTypeConfiguration的类
base.OnModelCreating(modelBuilder);
}
}
{
public DbContextClass()
: base("name=DbContextClass")//此处的name实在web.config中配置的
//<connectionStrings>
//<add connectionString="server=.;database=DbContextClass;uid=sa;pwd=123456" name="DbContextClass" providerName="System.Data.SqlClient"/>
// </connectionStrings>
{
Database.SetInitializer(new CreateDatabaseIfNotExists<DbContextClass>());//默认实例,数据库不存在则创建
}
public DbSet<StudentInfo> StudentInfo { get; set; }
//此方法实现所有 的实体类,所有需要创建表的实体必须在此方法中指明
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
//移除表名为复数
modelBuilder.Entity<StudentInfo>().ToTable("tset");//设置当前实体的表名
modelBuilder.Entity<StudentInfo>().HasKey(p => p.StudentId);//设置主键
//自动添加实现EntityTypeConfiguration的类
base.OnModelCreating(modelBuilder);
}
}
好,逻辑完成,添加测试代码
var db = new DbContextClass();
for (int i = 0; i < 10; i++)
{
db.StudentInfo.Add(
new StudentInfo {
StudentId = 1,
StudentName = "韦小宝",
Height = 172,
Weight = 120,
DateOfBirth ="2016.7.12"
});
}
if ( db.SaveChanges()>0)
{
return Content("ok");
}
else
{
return Content("false");
}
for (int i = 0; i < 10; i++)
{
db.StudentInfo.Add(
new StudentInfo {
StudentId = 1,
StudentName = "韦小宝",
Height = 172,
Weight = 120,
DateOfBirth ="2016.7.12"
});
}
if ( db.SaveChanges()>0)
{
return Content("ok");
}
else
{
return Content("false");
}