/// <summary> /// 执行没有返回值的存储过程 /// </summary> /// <param name="procedureName">存储过程名称</param> /// <param name="parameters">参数</param> public static Task ExecuteProcedureAsync <TDbContext>([NotNull] this CasualDapperRepository <TDbContext> repository, [NotNull] string procedureName, [CanBeNull] object parameters = null) where TDbContext : ActiveDbContext { return(repository.Connection.ExecuteAsync(procedureName, parameters, transaction: repository.ActiveTransaction, commandType: CommandType.StoredProcedure)); }
/// <summary> /// 查询对象 /// </summary> /// <typeparam name="TDbContext">DB 上下文</typeparam> /// <typeparam name="TFirst">映射的第一个对象类型</typeparam> /// <typeparam name="TSecond">映射的第二个对象类型</typeparam> /// <typeparam name="TReturn">最终返回的对象类型</typeparam> /// <param name="repository"></param> /// <param name="sql">查询语句</param> /// <param name="map">映射关系</param> /// <param name="parameters">参数</param> /// <returns></returns> public static Task <IEnumerable <TReturn> > QueryAsync <TDbContext, TFirst, TSecond, TReturn>([NotNull] this CasualDapperRepository <TDbContext> repository, [NotNull] string sql, [NotNull] Func <TFirst, TSecond, TReturn> map, [CanBeNull] object parameters = null) where TDbContext : ActiveDbContext { return(repository.Connection.QueryAsync(sql, map, parameters, transaction: repository.ActiveTransaction)); }
public static Task <IEnumerable <TEntity> > ExecuteProcedureAsync <TDbContext, TEntity>([NotNull] this CasualDapperRepository <TDbContext> repository, [NotNull] string procedureName, [CanBeNull] object parameters = null) where TDbContext : ActiveDbContext where TEntity : class { return(repository.Connection.QueryAsync <TEntity>(procedureName, parameters, transaction: repository.ActiveTransaction, commandType: CommandType.StoredProcedure)); }