public static IEnumerable <T> Fetch <T>(this IRdbmsDataAccessor self, BDadosTransaction transaction, Expression <Func <T, bool> > conditions = null, int?skip = null, int?limit = null, Expression <Func <T, object> > orderingMember = null, OrderingType ordering = OrderingType.Asc)
where T : IDataObject, new()
{
return(self.LoadAll <T>(
transaction,
Core.Interfaces.LoadAll.Where <T>(conditions)
.Skip(skip)
.Limit(limit)
.OrderBy(orderingMember, ordering)
));
}
public List <T> GetObjectList <T>(BDadosTransaction transaction, IDbCommand command) where T : new()
{
var refl = new ObjectReflector();
transaction?.Benchmarker.Mark("Enter lock command");
lock (command) {
transaction?.Benchmarker.Mark("- Starting Execute Query");
using (var reader = command.ExecuteReader(CommandBehavior.SingleResult | CommandBehavior.SequentialAccess | CommandBehavior.KeyInfo)) {
transaction?.Benchmarker.Mark("- Starting build");
return(Fi.Tech.MapFromReader <T>(reader).ToList());
}
}
}
public static List <T> AggregateLoad <T>(this IRdbmsDataAccessor self, BDadosTransaction transaction, Expression <Func <T, bool> > conditions = null, int?skip = null, int?limit = null, Expression <Func <T, object> > orderingMember = null, OrderingType ordering = OrderingType.Asc, MemberInfo GroupingMember = null, bool Linear = false)
where T : IDataObject, new()
{
return(self.AggregateLoad <T>(
transaction,
Core.Interfaces.LoadAll.Where <T>(conditions)
.Skip(skip)
.Limit(limit)
.OrderBy(orderingMember, ordering)
.GroupBy(GroupingMember)
.LinearIf(Linear)
));
}
public void BuildAggregateObject(BDadosTransaction transaction,
Type t, IDataReader reader, ObjectReflector refl,
object obj, Dictionary <string, (int[], string[])> fieldNamesDict, JoiningTable[] joinTables, IDictionary <int, Relation[]> joinRelations,
public IntermediateRdbmsLoadAllArgs(BDadosTransaction transaction, LoadAllArgs <T> largs)
{
Transaction = transaction;
LoadAllArgs = largs;
}
public static IntermediateRdbmsLoadAllArgs <T> Using <T>(this LoadAllArgs <T> me, BDadosTransaction transaction) where T : IDataObject, new()
{
return(new IntermediateRdbmsLoadAllArgs <T>(transaction, me));
}
public static int Execute(this IRdbmsDataAccessor self, BDadosTransaction transaction, string query, params object[] args)
{
return(self.Execute(transaction, (IQueryBuilder)Qb.Fmt(query, args)));
}
public static DataTable Query(this IRdbmsDataAccessor self, BDadosTransaction transaction, string query, params object[] args)
{
return(self.Query(transaction, Qb.Fmt(query, args)));
}
public static List <T> Query <T>(this IRdbmsDataAccessor self, BDadosTransaction transaction, string query, params object[] args) where T : IDataObject, new()
{
return(self.Query <T>(transaction, (IQueryBuilder)Qb.Fmt(query, args)));
}
public static List <T> LoadAll <T>(this IRdbmsDataAccessor self, BDadosTransaction transaction, string query, params object[] args) where T : IDataObject, new()
{
return(self.LoadAll(transaction, (IQueryBuilder)Qb.Fmt(query, args), (int?)null, (int?)null, (Expression <Func <T, object> >)null, OrderingType.Asc, (object)null));
}
