EF_简单的增删改查

时间:2021-10-26 22:51:05
EF_简单的增删改查

EF分为三种code_first,model_first,dabase_first这三种模式,网上的例子有好多,但是用了之后感觉实际中都不是这么用的,此处记录写下来日后用的着了可以快速应用,记录如下:

新建项目添加EF6.2

需要四个东西:

1.表对应的model实例,此例中为: shop_test

2.EF连接数据的对象类,此例中为: EF_DATA_DBCONTEXT

3.数据操作的接口类,此例中为: IRepository

4.数据实际操作类,实现接口IRespository的类,此例中为: DataAccessObject

EF_简单的增删改查

1.shop_test

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.ComponentModel.DataAnnotations.Schema;
using System.ComponentModel.DataAnnotations;

using System.Runtime.Serialization;

namespace EF_TEST
{
[DataContract]
[Serializable]
[Table("shop_test")]
public partial class shop_test
{

[DataMember(Name ="id")]
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int id { get; set; }

[DataMember(Name ="shopname")]
public string shopname { get; set; }

[DataMember(Name ="create_time")]
public DateTime create_time { get; set; }

[DataMember(Name ="test_msg")]
public string test_msg { get; set; }

}
}

2.EF_DATA_DBCONTEXT

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Data.Entity;

namespace EF_TEST
{

//用EF进行连接时需要指定的连接数据库的
class EF_DATA_DBCONTEXT:DbContext
{
public EF_DATA_DBCONTEXT(string contr) : base(contr)
{

}

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
//base.OnModelCreating(modelBuilder);
}

public DbSet<shop_test> shoptests { get; set; }

}
}

3.IRepository

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Linq.Expressions;
using System.Data.Entity;

using System.Data.Entity.Infrastructure;

namespace EF_TEST
{
interface IRepository
{

DbContext CurrentDbContext
{
get;
}

DbEntityEntry<T> Attach<T>(T entity) where T : class;

T Insert<T>(T entity) where T : class;

T Insert<T>(T entity, bool isCommit) where T : class;

void InsertRange<T>(IEnumerable<T> entities) where T : class;

void InsertRange<T>(IEnumerable<T> entities, bool isCommit) where T : class;

void Update<T>(T entity) where T : class;

void Update<T>(T entity, bool isCommit) where T : class;

void UpdateRange<T>(IEnumerable<T> entities) where T : class;

void UpdateRange<T>(IEnumerable<T> entities, bool isCommit) where T : class;

void Delete<T>(T entity) where T : class;

void Delete<T>(T entity, bool isCommit) where T : class;

void DeleteRange<T>(IEnumerable<T> entities) where T : class;

void DeleteRange<T>(IEnumerable<T> entities, bool isCommit) where T : class;

T Find<T>(params object[] keyValues) where T : class;

T Find<T>(object keyValue) where T : class;

List<T> FindAll<T>(Expression<Func<T, bool>> conditions = null) where T : class;

List<T> FindAllByPage<T, S>(Expression<Func<T, bool>> conditions, Expression<Func<T, S>> orderBy, int pageSize, int pageIndex) where T : class;

int SaveChanges();

}
}

4.DataAccessObject

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Data.Entity;
using System.Linq.Expressions;

using System.Data.Entity.Infrastructure;

using System.Data;

namespace EF_TEST
{
class DataAccessObject:IRepository,IDisposable
{

private DbContext _currentDbContext = null;

public DbContext CurrentDbContext
{
get
{
return this._currentDbContext;
}
}

public DataAccessObject(DbContext dbContext)
{
this._currentDbContext = dbContext;
}

public DbEntityEntry<T> Attach<T>(T entity) where T : class
{
DbSet<T> dbSet = this._currentDbContext.Set<T>();
dbSet.Attach(entity);
return this._currentDbContext.Entry<T>(entity);
}

public T Insert<T>(T entity) where T : class
{
return this.Insert<T>(entity, true);
}

public T Insert<T>(T entity, bool isCommit) where T : class
{
this._currentDbContext.Set<T>().Add(entity);
if (isCommit)
{
this._currentDbContext.SaveChanges();
}
return entity;
}

public void InsertRange<T>(IEnumerable<T> entities) where T : class
{
this.InsertRange<T>(entities, true);
}

public void InsertRange<T>(IEnumerable<T> entities, bool isCommit) where T : class
{
this._currentDbContext.Set<T>().AddRange(entities);
if (isCommit)
{
this._currentDbContext.SaveChanges();
}
}

public void Update<T>(T entity) where T : class
{
this.Update<T>(entity, true);
}

public void Update<T>(T entity, bool isCommit) where T : class
{
this._currentDbContext.Set<T>().Attach(entity);
//this._currentDbContext.Entry<T>(entity).set_State(16);
this._currentDbContext.Entry<T>(entity).State = EntityState.Modified;
if (isCommit)
{
this._currentDbContext.SaveChanges();
}
}

public void UpdateRange<T>(IEnumerable<T> entities) where T : class
{
this.UpdateRange<T>(entities, true);
}

public void UpdateRange<T>(IEnumerable<T> entities, bool isCommit) where T : class
{
foreach (T current in entities)
{
this._currentDbContext.Set<T>().Attach(current);
// this._currentDbContext.Entry<T>(current).set_State(16);
this._currentDbContext.Entry<T>(current).State = EntityState.Modified;
}
if (isCommit)
{
this._currentDbContext.SaveChanges();
}
}

public void Delete<T>(T entity) where T : class
{
this.Delete<T>(entity, true);
}

public void Delete<T>(T entity, bool isCommit) where T : class
{
this._currentDbContext.Set<T>().Remove(entity);
if (isCommit)
{
this._currentDbContext.SaveChanges();
}
}

public void DeleteRange<T>(IEnumerable<T> entities) where T : class
{
this.DeleteRange<T>(entities, true);
}

public void DeleteRange<T>(IEnumerable<T> entities, bool isCommit) where T : class
{
this._currentDbContext.Set<T>().RemoveRange(entities);
if (isCommit)
{
this._currentDbContext.SaveChanges();
}
}

public int SaveChanges()
{
return this._currentDbContext.SaveChanges();
}

public T Find<T>(params object[] keyValues) where T : class
{
return this._currentDbContext.Set<T>().Find(keyValues);
}

public T Find<T>(object keyValue) where T : class
{
object[] array = new object[]
{
keyValue
};
return this._currentDbContext.Set<T>().Find(array);
}

public List<T> FindAll<T>(Expression<Func<T, bool>> conditions = null) where T : class
{
List<T> result;
if (conditions == null)
{
result = this._currentDbContext.Set<T>().ToList<T>();
}
else
{
result = this._currentDbContext.Set<T>().Where(conditions).ToList<T>();
}
return result;
}

public List<T> FindAllByPage<T, S>(Expression<Func<T, bool>> conditions, Expression<Func<T, S>> orderBy, int pageSize, int pageIndex) where T : class
{
IQueryable<T> source = (conditions == null) ? this._currentDbContext.Set<T>() : this._currentDbContext.Set<T>().Where(conditions);
return source.OrderByDescending(orderBy).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList<T>();
}

public void Dispose()
{
this._currentDbContext.Dispose();
}

}
}

控制台程序:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Data.Entity;

using System.Transactions;

namespace EF_TEST
{
class Program
{
static void Main(string[] args)
{

//config中的数据库的连接字符串
string CONSTR = System.Configuration.ConfigurationManager.ConnectionStrings["CONSTR"].ConnectionString;

//EF的DB连接对象
EF_DATA_DBCONTEXT db = new EF_DATA_DBCONTEXT(CONSTR);

//实现的的具体方法
IRepository DB_LINK = new DataAccessObject(db);

//进行的查询操作
List<shop_test> msg = DB_LINK.FindAll<shop_test>(p => p.id >= 0);

Console.WriteLine("查询ID大于0的所有数据");
Console.WriteLine("共查询到的信息行数:{0}--最后一个数据的时间:{1}", msg.Count, msg.Max(u => u.create_time).ToString());

//插入操作
shop_test insert_shop = new shop_test() { shopname="test", test_msg="ss", create_time =DateTime.Now };

using (TransactionScope scope =new TransactionScope() )
{
DB_LINK.Insert<shop_test>(insert_shop,false);

shop_test insert_second = new shop_test() { shopname=insert_shop.shopname, test_msg=insert_shop.test_msg, create_time=DateTime.Now };

DB_LINK.Insert<shop_test>(insert_second, false);

DB_LINK.SaveChanges();

scope.Complete();
}

Console.WriteLine("插入的id:{0}--shopname {1}---test_msg:{2} ---create_time:{2}", insert_shop.id, insert_shop.shopname, insert_shop.test_msg, insert_shop.create_time);

//更新操作
msg = DB_LINK.FindAll<shop_test>(u => u.id > 0);

Console.WriteLine("查询ID大于0的所有数据");
Console.WriteLine("共查询到的信息行数:{0}--最后一个数据的时间:{1}", msg.Count, msg.Max(u => u.create_time));

//更新操作,更新最大时间为当前时间

shop_test update_shop = (from i in msg
let max_time = msg.Max(u => u.create_time)
where i.create_time == max_time
select i
).FirstOrDefault();

update_shop.create_time = DateTime.Now;

DB_LINK.Update<shop_test>(update_shop);

Console.WriteLine("更新的id:{0}--shopname {1}---test_msg:{2} ---create_time:{2}", insert_shop.id, insert_shop.shopname, insert_shop.test_msg, insert_shop.create_time);

//删除操作;
Console.WriteLine("查询ID大于0的所有数据");
Console.WriteLine("共查询到的信息行数:{0}--最后一个数据的时间:{1}", msg.Count, msg.Max(u => u.create_time));

//删除操作 删除时间最早的数据
msg = DB_LINK.FindAll<shop_test>(u => u.id > 0);

shop_test delete_shop = (from i in msg
let max_time = msg.Max(u => u.create_time)
where i.create_time == max_time
select i
).FirstOrDefault();

DB_LINK.Delete<shop_test>(delete_shop);

Console.WriteLine("删除的id:{0}--shopname {1}---test_msg:{2} ---create_time:{2}", insert_shop.id, insert_shop.shopname, insert_shop.test_msg, insert_shop.create_time);

Console.WriteLine("查询ID大于0的所有数据");
Console.WriteLine("共查询到的信息行数:{0}--最后一个数据的时间:{1}", msg.Count, msg.Max(u=>u.create_time));

Console.ReadKey();

}
}
}

配置文件,及其数据库的表结构:

<connectionStrings>
<!--<add name="CONSTR" connectionString="DATA SOURCE=127.0.0.1;INITIAL CATALOG=TEST;USER ID=SA;PASSWORD=123"/>-->
<add name="CONSTR" connectionString="Data Source=127.0.0.1;Database=TEST;UID=sa;PWD=123;" providerName="System.Data.SqlClient"/>
</connectionStrings>

CREATE TABLE [dbo].[shop_test](
[id] [INT] IDENTITY(1,1) NOT NULL,
[shopname] [VARCHAR](50) NULL,
[create_time] [DATETIME] NULL,
CONSTRAINT [PK_shop_test] PRIMARY KEY NONCLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
)