简易的搭个ef框架

1。怎么去通过nuget去获取entityframework的，就不说了，

2。DbContext，代表数据库文档，就可以理解为一个数据库，

3。数据库中含有多个表，也有各种操作，多种业务

 

public class NewscontentContext : DbContext
{
public NewscontentContext()
: base("connectdata")//这里的connectdata是对应web.config的一个配置，

//如configuration/connectionStrings下： <add name="connectdata" providerName="System.Data.SqlClient" connectionString="Data Source=.;Initial Catalog=db;User ID=sa;Password=123;Integrated Security=True" />
{

}

/// <summary>
/// 数据库对象 对应 newsModel
/// </summary>
public virtual IDbSet<newsModel> newsInfo { get; set; }

/// <summary>
/// 数据库对象 对应 newsclassModel
/// </summary>
public virtual IDbSet<newsclassModel> newsclassInfo { get; set; }

/// <summary>
/// 重写 模型创建方法
/// </summary>
/// <param name="modelBuilder"></param>

protected override void OnModelCreating(DbModelBuilder modelBuilder)

{
//return;
// TODO: 在这里写Fluent API
//公约
modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
modelBuilder.Conventions.Remove<IncludeMetadataConvention>();

modelBuilder.Configurations.Add(new newsMapping());

modelBuilder.Configurations.Add(new newsclassMapping());

base.OnModelCreating(modelBuilder);

}

}

 

model:

Newscontent.Model
{
[Table("t_news")]
public class newsModel
{

/// <summary>
///
/// </summary>
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity), Column("id")]
public long id { get; set; }
/// <summary>
///
/// </summary>
[Column("newsclass_id")]
public long newsclass_id { get; set; }
/// <summary>
///
/// </summary>
[MaxLength(255), Column("title")]
public string title { get; set; }

}

Mappping://这个类作用暂时也没怎么用到，它也可以做一些模型对象的配置，但似乎没必要在这里做，这里暂时保留

Newscontent.Mapping
{
public class newsMapping : EntityTypeConfiguration<newsModel>
{
}

}

 

DAL:

Newscontent.DAL
{
internal class newsDAL
{
#region standard function
public int Add(newsModel model)
{
using (var ctx = new NewscontentContext())
{
ctx.newsInfo.Add(model);
return ctx.SaveChanges();
}
}

public int Add(List<newsModel> model_list)
{
int iadd = 0;
using (var ctx = new NewscontentContext())
{
for (int i = 0; i < model_list.Count; i++)
{
ctx.newsInfo.Add(model_list[i]);
}
iadd = ctx.SaveChanges();
}
return iadd;
}

public int Update(newsModel model)
{
using (var ctx = new NewscontentContext())
{
ctx.Entry(model).State = System.Data.Entity.EntityState.Modified;
return ctx.SaveChanges();
}
}

public newsModel GetModel(long id)
{
using (var ctx = new NewscontentContext())
{
var datas = ctx.newsInfo.Where(q => q.id == id).ToList();
if (datas.Count == 0) return null;
return datas[0];
}
}

public int Delete(newsModel model)
{
using (var ctx = new NewscontentContext())
{
ctx.Entry(model).State = System.Data.Entity.EntityState.Deleted;
ctx.newsInfo.Remove(model);
return ctx.SaveChanges();
}
}

#endregion

}

 

既然有了，DAL，BLL也就可以有了，具体略

就简单的说这些，

转载于:https://www.cnblogs.com/ijunxiong/articles/6849675.html