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