internal InsertValue(SpryInsert <TDto> spry, SpryInsertTable <TDto> table)
{
_spry = spry;
_table = table;
_insertColumnBuilder = new StringBuilder();
_insertValueBuilder = new StringBuilder();
_parameters = table.Parameters;
}
internal Where(TTable table, SpryParameters parameters, string columnName)
{
_whereBuilder = new StringBuilder();
_table = table;
_parameters = parameters;
_columnName = columnName.Replace(";", "");
_columnParameterName = CleanParameterName(_columnName);
}
public TColType ExecuteScalar <TColType>(IDbConnection connection, CommandType commandType = CommandType.Text, SpryParameters parameters = null)
{
Parameters.Add(parameters);
return(new SqlExecutor(Build()).ExecuteScalar <TColType>(connection, commandType, Parameters));
}
public IEnumerable <dynamic> Query(IDbConnection connection, CommandType commandType = CommandType.Text, SpryParameters parameters = null)
{
Parameters.Add(parameters);
return(new SqlExecutor(Build()).Query(connection, commandType, Parameters));
}
public int Execute(IDbConnection connection, CommandType commandType = CommandType.Text, SpryParameters parameters = null)
{
return(_table.Execute(connection, parameters: parameters));
}
public TColType ExecuteScalar <TColType>(IDbConnection connection, CommandType commandType = CommandType.Text, SpryParameters parameters = null)
{
return(_table.ExecuteScalar <TColType>(connection, parameters: parameters));
}
public IEnumerable <dynamic> Query(IDbConnection connection, CommandType commandType = CommandType.Text, SpryParameters parameters = null)
{
return(_table.Query(connection, parameters: parameters));
}
