C# Class Sharp.Data.Databases.SqLite.SqLiteDialect

Inheritance: Dialect

Show file Open project: sharpmigrations/sharpmigrations Class Usage Examples

Public Methods

Method	Description
GetAddColumnSql ( string table, Column column ) : string
GetAddCommentToColumnSql ( string tableName, string columnName, string comment ) : string
GetAddCommentToTableSql ( string tableName, string comment ) : string
GetColumnToSqlWhenCreate ( Column col ) : string
GetColumnValueToSql ( object value ) : string
GetCreateTableSqls ( Table table ) : string[]
GetDbType ( string sqlType, int dataPrecision ) : DbType
GetDropColumnSql ( string table, string columnName ) : string[]
GetDropForeignKeySql ( string fkName, string tableName ) : string
GetDropTableSqls ( string tableName ) : string[]
GetDropUniqueKeySql ( string uniqueKeyName, string tableName ) : string
GetForeignKeySql ( string fkName, string table, string column, string referencingTable, string referencingColumn, OnDelete onDelete ) : string
GetInsertReturningColumnSql ( string table, string columns, object values, string returningColumnName, string returningParameterName ) : string
GetModifyColumnSql ( string tableName, string columnName, Column columnDefinition ) : string
GetRemoveCommentFromColumnSql ( string tableName, string columnName ) : string
GetRemoveCommentFromTableSql ( string tableName ) : string
GetRenameColumnSql ( string tableName, string columnName, string newColumnName ) : string
GetRenameTableSql ( string tableName, string newTableName ) : string
GetTableExistsSql ( string tableName ) : string
GetUniqueKeySql ( string ukName, string table ) : string
WrapSelectSqlWithPagination ( string sql, int skipRows, int numberOfRows ) : string

Protected Methods

Method	Description
GetDbTypeString ( DbType type, int precision ) : string

Method Details

GetAddColumnSql() public method

public GetAddColumnSql ( string table, Column column ) : string
table	string
column	Sharp.Data.Schema.Column
return	string

GetAddCommentToColumnSql() public method

public GetAddCommentToColumnSql ( string tableName, string columnName, string comment ) : string
tableName	string
columnName	string
comment	string
return	string

GetAddCommentToTableSql() public method

public GetAddCommentToTableSql ( string tableName, string comment ) : string
tableName	string
comment	string
return	string

GetColumnToSqlWhenCreate() public method

public GetColumnToSqlWhenCreate ( Column col ) : string
col	Sharp.Data.Schema.Column
return	string

GetColumnValueToSql() public method

public GetColumnValueToSql ( object value ) : string
value	object
return	string

GetCreateTableSqls() public method

public GetCreateTableSqls ( Table table ) : string[]
table	Sharp.Data.Schema.Table
return	string[]

GetDbType() public method

public GetDbType ( string sqlType, int dataPrecision ) : DbType
sqlType	string
dataPrecision	int
return	DbType

GetDbTypeString() protected method

protected GetDbTypeString ( DbType type, int precision ) : string
type	DbType
precision	int
return	string

GetDropColumnSql() public method

public GetDropColumnSql ( string table, string columnName ) : string[]
table	string
columnName	string
return	string[]

GetDropForeignKeySql() public method

public GetDropForeignKeySql ( string fkName, string tableName ) : string
fkName	string
tableName	string
return	string

GetDropTableSqls() public method

public GetDropTableSqls ( string tableName ) : string[]
tableName	string
return	string[]

GetDropUniqueKeySql() public method

public GetDropUniqueKeySql ( string uniqueKeyName, string tableName ) : string
uniqueKeyName	string
tableName	string
return	string

GetForeignKeySql() public method

public GetForeignKeySql ( string fkName, string table, string column, string referencingTable, string referencingColumn, OnDelete onDelete ) : string
fkName	string
table	string
column	string
referencingTable	string
referencingColumn	string
onDelete	OnDelete
return	string

GetInsertReturningColumnSql() public method

public GetInsertReturningColumnSql ( string table, string columns, object values, string returningColumnName, string returningParameterName ) : string
table	string
columns	string
values	object
returningColumnName	string
returningParameterName	string
return	string

GetModifyColumnSql() public method

public GetModifyColumnSql ( string tableName, string columnName, Column columnDefinition ) : string
tableName	string
columnName	string
columnDefinition	Sharp.Data.Schema.Column
return	string

GetRemoveCommentFromColumnSql() public method

public GetRemoveCommentFromColumnSql ( string tableName, string columnName ) : string
tableName	string
columnName	string
return	string

GetRemoveCommentFromTableSql() public method

public GetRemoveCommentFromTableSql ( string tableName ) : string
tableName	string
return	string

GetRenameColumnSql() public method

public GetRenameColumnSql ( string tableName, string columnName, string newColumnName ) : string
tableName	string
columnName	string
newColumnName	string
return	string

GetRenameTableSql() public method

public GetRenameTableSql ( string tableName, string newTableName ) : string
tableName	string
newTableName	string
return	string

GetTableExistsSql() public method

public GetTableExistsSql ( string tableName ) : string
tableName	string
return	string

GetUniqueKeySql() public method

public GetUniqueKeySql ( string ukName, string table ) : string
ukName	string
table	string
return	string

WrapSelectSqlWithPagination() public method

public WrapSelectSqlWithPagination ( string sql, int skipRows, int numberOfRows ) : string
sql	string
skipRows	int
numberOfRows	int
return	string