protected virtual string GenerateLoadSql() { var commandText = "select " + SelectModifier + string.Join(", ", ColDefs.Select(x => TableName + ".[" + x.ColumnName + "]").ToArray()) + " from " + TableName + " " + Join; var queryFilter = QueryFilter; if (!string.IsNullOrEmpty(queryFilter)) { commandText += " where " + queryFilter; } var orderModifer = OrderModifier; if (!string.IsNullOrWhiteSpace(orderModifer)) { commandText += " order by " + orderModifer; } return(commandText); }
protected virtual string GenerateInsertSql() { return ("insert into " + TableName + "(" + string.Join(", ", ColDefs.Select(x => x.ColumnName).ToArray()) + ") values (" + string.Join(", ", ColDefs.Select(x => "@" + x.ColumnName).ToArray()) + ")"); }
public virtual DdlCreateTableStatement AddColumnDefinition(Identifier colname, ColumnDefinition def) { ColDefs.Add(new Pair <Identifier, ColumnDefinition>(colname, def)); return(this); }