• Home
• Sharp
• Data
• Dialect

C# Class Sharp.Data.Dialect

Show file Open project: sharpmigrations/sharpmigrations Class Usage Examples

Public Methods

Method	Description
ConvertToNamedParameters ( int indexToStart, object values ) : Sharp.Data.In[]
ConvertToNamedParameters ( object values ) : Sharp.Data.In[]
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
GetCountSql ( string tableName ) : string
GetCreateIndexSql ( string indexName, string table ) : string
GetCreateTableSqls ( Table table ) : string[]
GetDbType ( string sqlType, int dataPrecision ) : DbType
GetDeleteSql ( string table ) : string
GetDialectName ( ) : string
GetDropColumnSql ( string table, string columnName ) : string[]
GetDropForeignKeySql ( string fkName, string tableName ) : string
GetDropIndexSql ( string indexName, string table ) : string
GetDropPrimaryKeySql ( object tableName, string primaryKeyName ) : 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
GetInsertSql ( string table, string columns, object values ) : string
GetLogicOperator ( LogicOperator op ) : string
GetModifyColumnSql ( string tableName, string columnName, Column columnDefinition ) : string
GetOrderBySql ( ) : string
GetOrderByWord ( OrderByDirection orderByDirection ) : string
GetParameterName ( int order ) : string
GetPrimaryKeySql ( string table, string pkName ) : 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
GetSelectSql ( string tables, string columns ) : string
GetTableExistsSql ( string tableName ) : string
GetUniqueKeySql ( string ukName, string table ) : string
GetUpdateSql ( string table, string columns, object values ) : string
GetWhereSql ( Filter filter, int parameterStartIndex ) : string
WrapSelectSqlWithPagination ( string sql, int skipRows, int numberOfRows ) : string

Protected Methods

Method	Description
GetColumnCommentsSql ( Table table ) : IEnumerable
GetDbTypeString ( DbType type, int precision ) : string
GetWhereOperatorCompare ( CompareOperator op ) : string

Method Details