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 + ";");
}
public SqlQuery ToQuery(IEnumerable <TableType> rows)
{
var parameterFactory = new ParameterFactory();
var query = "";
var rowList = rows.ToList();
foreach (var row in rowList)
{
var tableName = tableInformation.GetSchemaAndTableName();
var columns = tableInformation.GetColumnNames(excludeIdentityColumns: true, excludeComputedFields: true, excludeIgnoredFields: true);
var values = tableInformation.GetColumnValues(row, excludeIdentityColumns: true, excludeComputedFields: true, excludeIgnoredFields: true);
var identityColumn = tableInformation.GetIdentityColumn();
query += "INSERT INTO " + tableName + " (" + string.Join(", ", columns) + ") SELECT " + string.Join(", ", values.Select(parameterFactory.Create)) + "; ";
if (identityColumn != null && rowList.Count == 1)
{
query += "SELECT SCOPE_IDENTITY();";
}
}
return(new SqlQuery(query, parameterFactory.GetParameters()));
}