public SubquerySourceBuilder(ISelect select,
IReadQueryExecutor readQueryExecutor,
ITableAliasGenerator tableAliasGenerator,
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
CommandParameterValues parameterValues,
Parameters parameters,
ParameterDefaults parameterDefaults)
: base(readQueryExecutor, tableAliasGenerator, uniqueParameterNameGenerator, parameterValues, parameters, parameterDefaults)
{
this.select = select;
}
public SubquerySourceBuilder(ISelect select,
IRelationalTransaction relationalTransaction,
ITableAliasGenerator tableAliasGenerator,
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
CommandParameterValues parameterValues,
Parameters parameters,
ParameterDefaults parameterDefaults)
: base(relationalTransaction, tableAliasGenerator, uniqueParameterNameGenerator, parameterValues, parameters, parameterDefaults)
{
this.select = select;
}
public TableSourceQueryBuilder(string tableOrViewName,
IRelationalTransaction relationalTransaction,
ITableAliasGenerator tableAliasGenerator,
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
CommandParameterValues parameterValues,
Parameters parameters,
ParameterDefaults parameterDefaults)
: base(relationalTransaction, tableAliasGenerator, uniqueParameterNameGenerator, parameterValues, parameters, parameterDefaults)
{
this.tableOrViewName = tableOrViewName;
}
public DeleteQueryBuilder(
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
Action <Type, Where, CommandParameterValues, int?> executeDelete,
IEnumerable <IWhereClause> whereClauses,
CommandParameterValues parameterValues)
{
this.uniqueParameterNameGenerator = uniqueParameterNameGenerator;
this.executeDelete = executeDelete;
this.whereClauses = whereClauses;
this.parameterValues = parameterValues;
}
public DeleteQueryBuilder(IRelationalTransaction relationalTransaction,
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
string tableName,
IEnumerable <IWhereClause> whereClauses,
CommandParameterValues parameterValues)
{
this.relationalTransaction = relationalTransaction;
this.uniqueParameterNameGenerator = uniqueParameterNameGenerator;
this.tableName = tableName;
this.whereClauses = whereClauses;
this.parameterValues = parameterValues;
}
public DeleteQueryBuilder(
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
DataModificationQueryBuilder queryBuilder,
IWriteQueryExecutor queryExecutor,
IEnumerable <IWhereClause> whereClauses = null,
CommandParameterValues parameterValues = null)
{
this.uniqueParameterNameGenerator = uniqueParameterNameGenerator;
this.queryBuilder = queryBuilder;
this.queryExecutor = queryExecutor;
this.whereClauses = whereClauses ?? new List <IWhereClause>();
this.parameterValues = parameterValues ?? new CommandParameterValues();
}
public TableSourceQueryBuilder(string tableOrViewName,
string schemaName,
IReadTransaction readQueryExecutor,
ITableAliasGenerator tableAliasGenerator,
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
CommandParameterValues parameterValues,
Parameters parameters,
ParameterDefaults parameterDefaults)
: base(readQueryExecutor, tableAliasGenerator, uniqueParameterNameGenerator, parameterValues, parameters, parameterDefaults)
{
this.schemaName = schemaName;
this.tableOrViewName = tableOrViewName;
}
protected SourceQueryBuilder(IRelationalTransaction relationalTransaction,
ITableAliasGenerator tableAliasGenerator,
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
CommandParameterValues parameterValues,
Parameters parameters,
ParameterDefaults parameterDefaults)
{
RelationalTransaction = relationalTransaction;
TableAliasGenerator = tableAliasGenerator;
UniqueParameterNameGenerator = uniqueParameterNameGenerator;
ParamValues = parameterValues;
Params = parameters;
ParamDefaults = parameterDefaults;
}
protected SourceQueryBuilder(IReadQueryExecutor readQueryExecutor,
ITableAliasGenerator tableAliasGenerator,
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
CommandParameterValues parameterValues,
Parameters parameters,
ParameterDefaults parameterDefaults)
{
ReadQueryExecutor = readQueryExecutor;
TableAliasGenerator = tableAliasGenerator;
UniqueParameterNameGenerator = uniqueParameterNameGenerator;
ParamValues = parameterValues;
Params = parameters;
ParamDefaults = parameterDefaults;
}
public QueryBuilder(TSelectBuilder selectBuilder,
IRelationalTransaction transaction,
ITableAliasGenerator tableAliasGenerator,
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
CommandParameterValues paramValues,
Parameters @params,
ParameterDefaults paramDefaults)
{
this.selectBuilder = selectBuilder;
this.transaction = transaction;
this.tableAliasGenerator = tableAliasGenerator;
this.uniqueParameterNameGenerator = uniqueParameterNameGenerator;
this.paramValues = paramValues;
this.@params = @params;
this.paramDefaults = paramDefaults;
}
public JoinSourceQueryBuilder(IAliasedSelectSource originalSource,
JoinType joinType,
IAliasedSelectSource nextJoin,
IRelationalTransaction relationalTransaction,
ITableAliasGenerator tableAliasGenerator,
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
CommandParameterValues parameterValues,
Parameters parameters,
ParameterDefaults parameterDefaults)
: base(relationalTransaction, tableAliasGenerator, uniqueParameterNameGenerator, parameterValues, parameters, parameterDefaults)
{
this.originalSource = originalSource;
clauses = new List <JoinClause>();
joinSource = nextJoin;
type = joinType;
}
public QueryBuilder(TSelectBuilder selectBuilder,
IReadQueryExecutor readQueryExecutor,
ITableAliasGenerator tableAliasGenerator,
IUniqueParameterNameGenerator uniqueParameterNameGenerator,
CommandParameterValues paramValues,
Parameters @params,
ParameterDefaults paramDefaults)
{
this.selectBuilder = selectBuilder;
this.readQueryExecutor = readQueryExecutor;
this.tableAliasGenerator = tableAliasGenerator;
this.uniqueParameterNameGenerator = uniqueParameterNameGenerator;
this.paramValues = paramValues;
this.@params = @params;
this.paramDefaults = paramDefaults;
}
protected static (IQueryBuilder <Foo> builder, (Parameters parameters, CommandParameterValues paramValues)) NewQueryBuilder(IUniqueParameterNameGenerator uniqueParameterNameGenerator = null)
{
var parameters = new Parameters();
var captures = new CommandParameterValues();
var builder = new QueryBuilder <Foo, TableSelectBuilder>(
new TableSelectBuilder(new SimpleTableSource("Foo")),
Substitute.For <IRelationalTransaction>(),
new TableAliasGenerator(),
uniqueParameterNameGenerator ?? CreateSubstituteParameterNameGenerator(),
captures,
parameters,
new ParameterDefaults()
);
return(builder, (parameters, captures));
}
public UniqueParameter(IUniqueParameterNameGenerator parameterNameGenerator, Parameter parameter)
: base(parameterNameGenerator.GenerateUniqueParameterName(parameter.ParameterName), parameter.DataType)
{
}