Query script

Energy.Query.Script generates SQL scripts such as CREATE TABLE, DROP TABLE, and MERGE statements for a given SQL dialect.

Creating a script

Energy.Query.Script script = new Energy.Query.Script(Energy.Enumeration.SqlDialect.MYSQL);

Energy.Source.Structure.Table table = new Energy.Source.Structure.Table();
table.Name = "Users";
table.Columns.New("Id").Type = "BIGINT";
table.Columns.New("Name").Type = "VARCHAR(100)";

string create = script.CreateTable(table, Energy.Query.Style.Global);

Methods

Method	Description
`CreateTable(Table, Style)`	Generate CREATE TABLE script.
`CreateTable(Table)`	Generate CREATE TABLE script.
`CreateDescription(Table)`	Generate extended-property descriptions.
`CreateIndex(Table)`	Generate index scripts.
`DropTable(string)`	Generate DROP TABLE script.
`Merge(Table, bool)`	Generate MERGE/UPSERT script.
`Merge(Table)`	Generate MERGE script.
`CurrentTimestamp()`	Return current timestamp expression.

Dialect

The script is initialized with a dialect. You can also implicitly cast a dialect to a script.

Energy.Query.Script mysql = Energy.Enumeration.SqlDialect.MYSQL;

Format

The script uses an Energy.Query.Format object to quote identifiers. By default the format is derived from the dialect.

See also

query-dialect
query-style
source-structure