Query statement

Energy.Query.Statement provides statement builders for SELECT and INSERT.

Base

Energy.Query.Statement.Base is the abstract base class for all statement builders. It can hold a dialect.

Select

Energy.Query.Statement.Select holds lists of columns, tables, and joins.

Energy.Query.Statement.Select select = new Energy.Query.Statement.Select();

Insert

Energy.Query.Statement.Insert builds an INSERT statement.

Energy.Query.Statement.Insert insert = new Energy.Query.Statement.Insert()
    .Table("Users")
    .Value("Name", "Alice")
    .Value("Email", "alice@example.com");

Dialect rendering

Dialects implement Energy.Interface.IDialect and provide methods like Select and Insert to render statements.

Energy.Query.Dialect.MYSQL dialect = new Energy.Query.Dialect.MYSQL();
// string sql = dialect.Select(select);

See also

  • query-dialect