public static string GenerateTemplate(ITableSchema schema, SqlScriptType type, bool ifExists)
{
TableName tableName = schema.TableName;
TableClause script = new TableClause(schema);
switch (type)
{
case SqlScriptType.INSERT:
return(script.INSERT(schema.Columns));
case SqlScriptType.SELECT:
return(script.SELECT(schema.Columns));
case SqlScriptType.UPDATE:
return(script.UPDATE(schema.Columns));
case SqlScriptType.INSERT_OR_UPDATE:
return(script.INSERT_OR_UPDATE(schema.Columns));
case SqlScriptType.DELETE:
return(new Dependency(tableName.DatabaseName).DELETE(tableName)
+ script.DELETE(schema.Columns));
case SqlScriptType.DROP:
return(new Dependency(tableName.DatabaseName).DROP_TABLE(tableName, ifExists)
+ script.DROP_TABLE(ifExists));
}
return(null);
}
public static string GenerateTemplate(TableSchema schema, SqlScriptType type)
{
TableName tableName = schema.TableName;
TableClause script = new TableClause(schema);
switch (type)
{
case SqlScriptType.INSERT:
return script.INSERT(schema.Columns);
case SqlScriptType.SELECT:
return script.SELECT(schema.Columns);
case SqlScriptType.UPDATE:
return script.UPDATE(schema.Columns);
case SqlScriptType.INSERT_OR_UPDATE:
return script.INSERT_OR_UPDATE(schema.Columns);
case SqlScriptType.DELETE:
return new Dependency(tableName.DatabaseName).DELETE(tableName)
+ script.DELETE(schema.Columns);
}
return null;
}
