private string CreateQuery(ParameterFactory parameterFactory)
{
var tableName = tableInformation.GetSchemaAndTableName();
var whereQueryPart = WhereGenerator.CreateQuery(parameterFactory, whereStatement);
return
("DELETE FROM " + tableName
+ whereQueryPart + ";");
}
private string CreateQuery(ParameterFactory parameterFactory)
{
var tableName = tableInformation.GetSchemaAndTableName();
var whereQueryPart = WhereGenerator.CreateQuery(parameterFactory, whereStatement);
var query = "UPDATE " + tableName + " SET ";
query += GenerateSetExpressions(parameterFactory);
query += whereQueryPart;
return(query);
}
private string CreateQuery(ParameterFactory parameterFactory)
{
var tableName = tableInformation.GetSchemaAndTableName();
var topPart = TopOrNull == null
? string.Empty
: "TOP " + TopOrNull.Value + " ";
var columns = tableInformation.GetColumnNames(excludeIgnoredFields: true, fieldsToInclude: FieldsToInclude);
var whereQueryPart = WhereGenerator.CreateQuery(parameterFactory, whereStatement);
var orderByQueryPart = OrderByGenerator.CreateQuery(orderByStatements);
return
("SELECT " + topPart + string.Join(", ", columns)
+ " FROM " + tableName
+ whereQueryPart
+ orderByQueryPart + ";");
}
