public
interface IRepository<TEntity> where TEntity : BaseEntity
{
/// <summary>
/// EF DBContext
/// </summary>
VOLContext DbContext { get; }
ISqlDapper DapperContext { get; }
/// <summary>
/// 执行事务。将在执行的方法带入Action
/// </summary>
/// <param name="action"></param>
/// <returns></returns>
WebResponseContent DbContextBeg
inTransaction
(Func<WebResponseContent> action
);
/// <summary>
/// 通过条件查询数据
/// </summary>
/// <param name="where"></param>
/// <returns></returns>
List<TEntity> F
ind
(Expression<Func<TEntity, bool>> where
);
/// <summary>
///
/// </summary>
/// <param name="predicate"></param>
/// <param name="
orderBySelector">排序字段,数据格式如:
///
orderBy = x => new Dictionary<object, bool>
() {
/// { x.BalconyName,Query
OrderBy.Asc},
/// { x.TranCorpCode1,Query
OrderBy.Desc}
/// };
///
/// </param>
/// <returns></returns>
TEntity F
indFirst
(Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, Dictionary<object, Query
OrderBy>>>
orderBy = null
);
/// <summary>
///
/// </summary>
/// <param name="predicate">where条件</param>
/// <param name="
orderBy">排序字段,数据格式如:
///
orderBy = x => new Dictionary<object, bool>
() {
/// { x.BalconyName,Query
OrderBy.Asc},
/// { x.TranCorpCode1,Query
OrderBy.Desc}
/// };
/// </param>
/// <returns></returns>
IQueryable<TEntity> F
indAsIQueryable
(Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, Dictionary<object, Query
OrderBy>>>
orderBy = null
);
/// <summary>
/// 通过条件查询数据
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="predicate">查询条件</param>
/// <param name="selector">返回类型如:F
ind
(x => x.UserName == log
inInfo.userName, p => new { uname = p.UserName }
);</param>
/// <returns></returns>
List<T> F
ind<T>
(Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, T>> selector
);
/// <summary>
/// 根据条件，返回查询的类
/// </summary>
/// <typeparam name="TF
ind"></typeparam>
/// <param name="predicate"></param>
/// <returns></returns>
List<TF
ind> F
ind<TF
ind>
(Expression<Func<TF
ind, bool>> predicate
) where TF
ind : class;
Task<TF
ind> F
indAsyncFirst<TF
ind>
(Expression<Func<TF
ind, bool>> predicate
) where TF
ind : class;
Task<TEntity> F
indAsyncFirst
(Expression<Func<TEntity, bool>> predicate
);
Task<List<TF
ind>> F
indAsync<TF
ind>
(Expression<Func<TF
ind, bool>> predicate
) where TF
ind : class;
Task<TEntity> F
indFirstAsync
(Expression<Func<TEntity, bool>> predicate
);
Task<List<TEntity>> F
indAsync
(Expression<Func<TEntity, bool>> predicate
);
Task<List<T>> F
indAsync<T>
(Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, T>> selector
);
Task<T> F
indFirstAsync<T>
(Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, T>> selector
);
/// <summary>
/// 多条件查询
/// </summary>
/// <typeparam name="Source"></typeparam>
/// <param name="sources">要查询的多个条件的数据源</param>
/// <param name="predicate">生成的查询条件</param>
/// <returns></returns>
List<TEntity> F
ind<Source>
(IEnumerable<Source> sources,
Func<Source, Expression<Func<TEntity, bool>>> predicate
)
where Source : class;
/// <summary>
/// 多条件查询
/// </summary>
/// <typeparam name="Source"></typeparam>
/// <param name="sources">要查询的多个条件的数据源</param>
/// <param name="predicate">生成的查询条件</param>
/// <param name="selector">自定义返回结果</param>
/// <returns></returns>
List<TResult> F
ind<Source, TResult>
(IEnumerable<Source> sources,
Func<Source, Expression<Func<TEntity, bool>>> predicate,
Expression<Func<TEntity, TResult>> selector
)
where Source : class;
/// <summary>
/// 多条件查询
/// </summary>
/// <typeparam name="Source"></typeparam>
/// <param name="sources">要查询的多个条件的数据源</param>
/// <param name="predicate">生成的查询条件</param>
/// <returns></returns>
IQueryable<TEntity> F
indAsIQueryable<Source>
(IEnumerable<Source> sources,
Func<Source, Expression<Func<TEntity, bool>>> predicate
)
where Source : class;
Task<bool> ExistsAsync
(Expression<Func<TEntity, bool>> predicate
);
bool Exists
(Expression<Func<TEntity, bool>> predicate
);
bool Exists<TExists>
(Expression<Func<TExists, bool>> predicate
) where TExists : class;
Task<bool> ExistsAsync<TExists>
(Expression<Func<TExists, bool>> predicate
) where TExists : class;
I
IncludableQueryable<TEntity, TProperty>
Include<TProperty>
(Expression<Func<TEntity, TProperty>>
incluedProperty
);
/// <summary>
///
/// </summary>
/// <typeparam name="TResult"></typeparam>
/// <param name="page
Index"></param>
/// <param name="pagesize"></param>
/// <param name="rowcount"></param>
/// <param name="predicate"></param>
/// <param name="
orderBy">
/// 通过多个字段排序Expression<Func<TEntity, Dictionary<object, bool>>>
///
orderBy = x => new Dictionary<object, bool>
() {
/// { x.BalconyName,Query
OrderBy.Asc},
/// { x.TranCorpCode1,Query
OrderBy.Desc}
/// };
/// <param name="selectorResult">查询返回的对象</param>
/// <returns></returns>
List<TResult> Query
ByPage<TResult>
(int page
Index,
int pagesize, out
int rowcount, Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, Dictionary<object, Query
OrderBy>>>
orderBySelector, Expression<Func<TEntity, TResult>> selectorResult, bool returnRowCount = true
);
List<TResult> Query
ByPage<TResult>
(int page
Index,
int pagesize, Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, Dictionary<object, Query
OrderBy>>>
orderBy, Expression<Func<TEntity, TResult>> selectorResult = null
);
/// <summary>
///
/// </summary>
/// <param name="page
Index"></param>
/// <param name="pagesize"></param>
/// <param name="rowcount"></param>
/// <param name="predicate"></param>
/// <param name="
orderBy"></param>
/// /// 通过多个字段排序Expression<Func<TEntity, Dictionary<object, bool>>>
///
orderBy = x => new Dictionary<object, bool>
() {
/// { x.BalconyName,Query
OrderBy.Asc},
/// { x.TranCorpCode1,Query
OrderBy.Desc}
/// };
/// <returns></returns>
List<TEntity> Query
ByPage
(int page
Index,
int pagesize, out
int rowcount, Expression<Func<TEntity, bool>> predicate, Expression<Func<TEntity, Dictionary<object, Query
OrderBy>>>
orderBy, bool returnRowCount = true
);
IQueryable<TF
ind> IQueryablePage<TF
ind>
(int page
Index,
int pagesize, out
int rowcount, Expression<Func<TF
ind, bool>> predicate, Expression<Func<TEntity, Dictionary<object, Query
OrderBy>>>
orderBy, bool returnRowCount = true
) where TF
ind : class;
IQueryable<TEntity> IQueryablePage
(IQueryable<TEntity> queryable,
int page
Index,
int pagesize, out
int rowcount, Dictionary<str
ing, Query
OrderBy>
orderBy, bool returnRowCount = true
);
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="properties">指定更新字段:x=>new {x.Name,x.Enable}</param>
/// <param name="saveChanges">是否保存</param>
/// <returns></returns>
int Update
(TEntity entity, Expression<Func<TEntity, object>> properties, bool saveChanges = false
);
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="properties">指定更新字段:x=>new {x.Name,x.Enable}</param>
/// <param name="saveChanges">是否保存</param>
/// <returns></returns>
int Update<TSource>
(TSource entity, Expression<Func<TSource, object>> properties, bool saveChanges = false
) where TSource : class;
int Update<TSource>
(TSource entity, bool saveChanges = false
) where TSource : class;
int Update<TSource>
(TSource entity, str
ing[] properties, bool saveChanges = false
) where TSource : class;
int UpdateRange<TSource>
(IEnumerable<TSource> entities, bool saveChanges = false
) where TSource : class;
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="properties">指定更新字段:x=>new {x.Name,x.Enable}</param>
/// <param name="saveChanges">是否保存</param>
/// <returns></returns>
int UpdateRange<TSource>
(IEnumerable<TSource> models, Expression<Func<TSource, object>> properties, bool saveChanges = false
) where TSource : class;
int UpdateRange<TSource>
(IEnumerable<TSource> entities, str
ing[] properties, bool saveChanges = false
) where TSource : class;
/// <summary>
///修改时同时对明细的添加、删除、修改
/// </summary>
/// <param name="entity"></param>
/// <param name="updateDetail">是否修改明细</param>
/// <param name="delNotExist">是否删除明细不存在的数据</param>
/// <param name="updateMa
inFields">主表指定修改字段</param>
/// <param name="updateDetailFields">明细指定修改字段</param>
/// <param name="saveChange">是否保存</param>
/// <returns></returns>
WebResponseContent UpdateRange<Detail>
(TEntity entity,
bool updateDetail = false,
bool delNotExist = false,
Expression<Func<TEntity, object>> updateMa
inFields = null,
Expression<Func<Detail, object>> updateDetailFields = null,
bool saveChange = false
) where Detail : class;
void Delete
(TEntity model, bool saveChanges=false
);
/// <summary>
///
/// </summary>
/// <param name="keys"></param>
/// <param name="delList">是否将子表的数据也删除</param>
/// <returns></returns>
int DeleteWithKeys
(object[] keys, bool delList = false
);
void Add
(TEntity entities, bool SaveChanges = false
);
void AddRange
(IEnumerable<TEntity> entities, bool SaveChanges = false
);
Task AddAsync
(TEntity entities
);
Task AddRangeAsync
(IEnumerable<TEntity> entities
);
void AddRange<T>
(IEnumerable<T> entities, bool saveChanges = false
)
where T : class;
void Bulk
Insert
(IEnumerable<TEntity> entities, bool setOutputIdentity = false
);
int SaveChanges
();
Task<
int> SaveChangesAsync
();
int ExecuteSqlCommand
(str
ing sql, params SqlParameter[] sqlParameters
);
List<TEntity> FromSql
(str
ing sql, params SqlParameter[] sqlParameters
);
/// <summary>
/// 执行sql
/// 使用方式 FormattableStr
ing sql=$"select * from xx where name ={xx} and pwd={xx1} "，
/// FromSql
Interpolated内部处理sql注入的问题，直接在{xx}写对应的值即可
/// 注意：sql必须 select * 返回所有TEntity字段，
/// </summary>
/// <param name="formattableStr
ing"></param>
/// <returns></returns>
IQueryable<TEntity> FromSql
Interpolated
([System.Diagnostics.CodeAnalysis.NotNull] FormattableStr
ing sql
);
/// <summary>
/// 取消上下文跟踪
/// 更新报错时，请调用此方法：The
instance of entity type 'XXX' cannot be tracked because another
instance with the same key value for {'XX'} is already be
ing tracked.
/// </summary>
/// <param name="entity"></param>
void Detached
(TEntity entity
);
void DetachedRange
(IEnumerable<TEntity> entities
);
}
本文解决了一个在数据库中按类别和名称顺序获取电影列表的问题。通过使用LINQ查询，首先按CategoryID排序，然后在相同类别下按电影名称排序。
扫一扫
335
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
