Interface IQueryTableBuilder

Creates TABLEs in SQL.

Inherited Members
Namespace: LemonEdge.DataAccess.Core.Abstractions.Builders
Assembly: LemonEdge.DataAccess.Core.Abstractions.dll
Syntax
public interface IQueryTableBuilder : IQueryBuilder

Properties

Collation

Gets the table COLLATION.

Declaration
string Collation { get; }
Property Value
Type Description
string

DeclareTable

Uses DECLARE {name} TABLE syntax instead of CREATE TABLE {name}.

Declaration
bool DeclareTable { get; }
Property Value
Type Description
bool

TableName

The table name.

Declaration
string TableName { get; }
Property Value
Type Description
string

Methods

AddColumn(string, ColumnType, bool)

Adds a COLUMN to the table.

Declaration
void AddColumn(string columnName, ColumnType definition, bool addAtEnd = false)
Parameters
Type Name Description
string columnName

The column name.
ColumnType definition

The type of the column.
bool addAtEnd

Whether to append.

AddConstraints(string)

Adds CONSTRAINT statements.

Declaration
void AddConstraints(string constraints)
Parameters
Type Name Description
string constraints

The SQL.

Extension Methods