ef core 公共接口封装

1. public interface ICommonDAL<T> where T : class, new()
2. {
4. protected EFContext context { get; }
6. /// <summary>
7. /// 新增一个实体
8. /// </summary>
9. /// <param name="entity"></param>
10. /// <returns></returns>
11. public int Add(T entity)
12. {
13. if (entity == null)
14. return -1;
16. context.Entry<T>(entity).State = Microsoft.EntityFrameworkCore.EntityState.Added;
17. return context.SaveChanges();
18. }
20. /// <summary>
21. /// 批量添加
22. /// </summary>
23. /// <param name="entitys"></param>
24. /// <returns></returns>
25. public int BatchAdd(List<T> entitys)
26. {
27. if (entitys == null)
28. return -1;
30. foreach (T item in entitys)
31. {
32. context.Entry<T>(item).State = Microsoft.EntityFrameworkCore.EntityState.Added;
33. }
35. return context.SaveChanges();
36. }
38. public int Deleted(T entity)
39. {
40. if (entity == null)
41. return -1;
43. context.Entry<T>(entity).State = Microsoft.EntityFrameworkCore.EntityState.Deleted;
44. return context.SaveChanges();
45. }
47. public T AddReturnEntity(T entity)
48. {
49. context.Entry(entity).State = Microsoft.EntityFrameworkCore.EntityState.Added;
50. int count = context.SaveChanges();
51. if (count > 0)
52. return entity;
53. else
54. return null;
55. }
57. public int Update(T t, string keyName)
58. {
59. var entry = context.Entry<T>(t);
60. //把user对象加入上下文,但是没有改变
61. entry.State = Microsoft.EntityFrameworkCore.EntityState.Unchanged;
62. //使用反射找到不为空的字段
63. foreach (var item in t.GetType().GetProperties())
64. {
65. //虚拟属性是导航属性
66. if (item.GetMethod.IsVirtual)
67. {
68. continue;
69. }
70. //拿到属性值
71. object obj = item.GetValue(t);
72. if (obj != null)
73. {
74. //不是主键才去修改，如果是主键就不需要修改了
75. if (item.Name != keyName)
76. {
77. //表示该字段需要更新
78. entry.Property(item.Name).IsModified = true;
79. }
80. }
81. }
82. return context.SaveChanges();
83. }
85. public T GetElementById(int Id)
86. {
87. string name = typeof(T).Name;
88. T element = context.Database.SqlQuery<T>("select * from " + name + " where Id=@Id", new SqlParameter("@Id", Id)).FirstOrDefault();
89. return element;
90. }
92. //public T GetMyNoteFileById(int Id)
93. //{
94. // T value = context.Set<T>().Where(a=>a.);
95. // return myNoteFile;
96. //}
97. }