Interface IEntitySqlWriter

Inherited Members
Namespace: LemonEdge.Connections.Database.Migrations.Core.SQLWriters
Assembly: LemonEdge.Database.Connector.dll
Syntax
public interface IEntitySqlWriter : IEntitySqlWriterCore

Methods

AlterColumn(string, IDbConnection, bool)

Alters the specified column to the new type You should delete all functions first that are schema bound before making table structural changes

Declaration
Task AlterColumn(string columnName, IDbConnection cn, bool forHistoryTable = false)
Parameters
Type Name Description
string columnName
IDbConnection cn
bool forHistoryTable
Returns
Type Description
Task

AlterColumnName(string, string, IDbConnection, bool)

Declaration
Task AlterColumnName(string columnName, string oldName, IDbConnection cn, bool forHistoryTable = false)
Parameters
Type Name Description
string columnName
string oldName
IDbConnection cn
bool forHistoryTable
Returns
Type Description
Task

AlterColumnType(ColumnDescriptor, bool, bool, bool, IDbConnection, bool)

Declaration
Task AlterColumnType(ColumnDescriptor prop, bool typeChanged, bool nullChanged, bool columnMaxLengthChanged, IDbConnection cn, bool forHistoryTable = false)
Parameters
Type Name Description
ColumnDescriptor prop
bool typeChanged
bool nullChanged
bool columnMaxLengthChanged
IDbConnection cn
bool forHistoryTable
Returns
Type Description
Task

AlterTableName(string, IDbConnection)

Declaration
Task AlterTableName(string oldName, IDbConnection cn)
Parameters
Type Name Description
string oldName
IDbConnection cn
Returns
Type Description
Task

ClearRelatedTableConstraints(ObseleteEntityDescriptor, IDataAccessor, IDbConnection)

Declaration
Task ClearRelatedTableConstraints(ObseleteEntityDescriptor obselete, IDataAccessor accessor, IDbConnection cn)
Parameters
Type Name Description
ObseleteEntityDescriptor obselete
IDataAccessor accessor
IDbConnection cn
Returns
Type Description
Task

ClearTableConstraints(string, IDataAccessor, IDbConnection)

Declaration
Task ClearTableConstraints(string tableName, IDataAccessor accessor, IDbConnection cn)
Parameters
Type Name Description
string tableName
IDataAccessor accessor
IDbConnection cn
Returns
Type Description
Task

CreateColumn(string, IDbConnection, bool)

Adds the specified column from the table for this entity. You should delete all functions first that are schema bound before making table structural changes

Declaration
Task CreateColumn(string columnName, IDbConnection cn, bool forHistoryTable = false)
Parameters
Type Name Description
string columnName
IDbConnection cn
bool forHistoryTable
Returns
Type Description
Task

CreateFunction(BaseFunctionDescriptor, IDbConnection)

Declaration
Task CreateFunction(BaseFunctionDescriptor function, IDbConnection cn)
Parameters
Type Name Description
BaseFunctionDescriptor function
IDbConnection cn
Returns
Type Description
Task

CreatePrimaryKey(IDbConnection, bool)

Declaration
Task CreatePrimaryKey(IDbConnection cn, bool forHistoryTable)
Parameters
Type Name Description
IDbConnection cn
bool forHistoryTable
Returns
Type Description
Task

CreateProcedure(BaseProcedureDescriptor, IDbConnection)

Declaration
Task CreateProcedure(BaseProcedureDescriptor function, IDbConnection cn)
Parameters
Type Name Description
BaseProcedureDescriptor function
IDbConnection cn
Returns
Type Description
Task

CreateTable(IDbConnection)

Declaration
Task CreateTable(IDbConnection cn)
Parameters
Type Name Description
IDbConnection cn
Returns
Type Description
Task

DeleteColumn(string, IDbConnection, bool)

Removes the specified column from the table for this entity. You should delete all functions first that are schema bound before making table structural changes

Declaration
Task DeleteColumn(string columnName, IDbConnection cn, bool forHistoryTable = false)
Parameters
Type Name Description
string columnName
IDbConnection cn
bool forHistoryTable
Returns
Type Description
Task

DoesColumnExist(string, IDbConnection, bool)

Declaration
Task<bool> DoesColumnExist(string columnName, IDbConnection cn, bool forHistoryTable)
Parameters
Type Name Description
string columnName
IDbConnection cn
bool forHistoryTable
Returns
Type Description
Task<bool>

DoesFunctionExist(BaseFunctionDescriptor, IDbConnection)

Declaration
Task<bool> DoesFunctionExist(BaseFunctionDescriptor function, IDbConnection cn)
Parameters
Type Name Description
BaseFunctionDescriptor function
IDbConnection cn
Returns
Type Description
Task<bool>

DoesIndexExist(TableIndex, IDbConnection, bool)

Declaration
Task<bool> DoesIndexExist(TableIndex index, IDbConnection cn, bool forHistoryTable)
Parameters
Type Name Description
TableIndex index
IDbConnection cn
bool forHistoryTable
Returns
Type Description
Task<bool>

DoesOldTableExist(IDbConnection)

Declaration
Task<string> DoesOldTableExist(IDbConnection cn)
Parameters
Type Name Description
IDbConnection cn
Returns
Type Description
Task<string>

DoesProcedureExist(BaseProcedureDescriptor, IDbConnection)

Declaration
Task<bool> DoesProcedureExist(BaseProcedureDescriptor function, IDbConnection cn)
Parameters
Type Name Description
BaseProcedureDescriptor function
IDbConnection cn
Returns
Type Description
Task<bool>

DoesTableExist(IDbConnection)

Declaration
Task<bool> DoesTableExist(IDbConnection cn)
Parameters
Type Name Description
IDbConnection cn
Returns
Type Description
Task<bool>

DropAllIndexes(IDbConnection, bool)

Drop all indexes apart from primary and clustered - needs to be done through custom script (as those should be alter indexes to run on azure)

Declaration
Task DropAllIndexes(IDbConnection cn, bool forHistoryTable = false)
Parameters
Type Name Description
IDbConnection cn
bool forHistoryTable
Returns
Type Description
Task

DropFunction(BaseFunctionDescriptor, IDbConnection)

Declaration
Task DropFunction(BaseFunctionDescriptor function, IDbConnection cn)
Parameters
Type Name Description
BaseFunctionDescriptor function
IDbConnection cn
Returns
Type Description
Task

DropFunction(IDataAccessor, BaseFunctionDescriptor, IDbConnection)

Declaration
Task DropFunction(IDataAccessor accessor, BaseFunctionDescriptor function, IDbConnection cn)
Parameters
Type Name Description
IDataAccessor accessor
BaseFunctionDescriptor function
IDbConnection cn
Returns
Type Description
Task

DropPrimaryKey(IDbConnection, bool)

Declaration
Task DropPrimaryKey(IDbConnection cn, bool forHistoryTable)
Parameters
Type Name Description
IDbConnection cn
bool forHistoryTable
Returns
Type Description
Task

DropProcedure(BaseProcedureDescriptor, IDbConnection)

Declaration
Task DropProcedure(BaseProcedureDescriptor function, IDbConnection cn)
Parameters
Type Name Description
BaseProcedureDescriptor function
IDbConnection cn
Returns
Type Description
Task

DropProcedure(IDataAccessor, BaseProcedureDescriptor, IDbConnection)

Declaration
Task DropProcedure(IDataAccessor accessor, BaseProcedureDescriptor function, IDbConnection cn)
Parameters
Type Name Description
IDataAccessor accessor
BaseProcedureDescriptor function
IDbConnection cn
Returns
Type Description
Task

EnsureIndexesExist(IDbConnection, bool)

Declaration
Task EnsureIndexesExist(IDbConnection cn, bool forHistoryTable = false)
Parameters
Type Name Description
IDbConnection cn
bool forHistoryTable
Returns
Type Description
Task

GetColumnsInfo(IDbConnection, string)

Declaration
Task<IEnumerable<ColumnProperties>> GetColumnsInfo(IDbConnection cn, string tableName = "")
Parameters
Type Name Description
IDbConnection cn
string tableName
Returns
Type Description
Task<IEnumerable<ColumnProperties>>

GetExtraColumnNames(IEnumerable<string>)

Declaration
IEnumerable<string> GetExtraColumnNames(IEnumerable<string> existingColumnNames)
Parameters
Type Name Description
IEnumerable<string> existingColumnNames
Returns
Type Description
IEnumerable<string>

GetIncorrectColumnTypes(IEnumerable<ColumnProperties>)

Declaration
IEnumerable<ColumnProperties> GetIncorrectColumnTypes(IEnumerable<ColumnProperties> existingColumnNames)
Parameters
Type Name Description
IEnumerable<ColumnProperties> existingColumnNames
Returns
Type Description
IEnumerable<ColumnProperties>

GetMissingColumnNames(IEnumerable<string>)

Declaration
IEnumerable<(string MissingColName, string ExistingOldValue)> GetMissingColumnNames(IEnumerable<string> existingColumnNames)
Parameters
Type Name Description
IEnumerable<string> existingColumnNames
Returns
Type Description
IEnumerable<(string FileFormatName, string FileExtension)>

RenameColumn(string, string, IDbConnection)

Declaration
Task RenameColumn(string oldColumnName, string newColumnName, IDbConnection cn)
Parameters
Type Name Description
string oldColumnName
string newColumnName
IDbConnection cn
Returns
Type Description
Task

Extension Methods