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 + ";"); }