Метод | Описание | |
---|---|---|
AlterColumn ( TableRef tblName, string colName, DbType type, int size, int scale, bool isNullable ) : void | ||
BeginTransaction ( ) : void | ||
CheckCheckConstraintExists ( TableRef tblName, string constraintName ) : bool | ||
CheckCheckConstraintPossible ( TableRef tblName, string colName, string newConstraintName, Dictionary |
||
CheckColumnContainsNulls ( TableRef tblName, string colName ) : bool | ||
CheckColumnContainsValues ( TableRef tblName, string colName ) : bool | ||
CheckColumnExists ( TableRef tblName, string colName ) : bool | ||
CheckDatabaseExists ( string dbName ) : bool | ||
CheckFKColumnContainsUniqueValues ( TableRef tblName, string colName ) : bool | ||
CheckFKConstraintExists ( TableRef tblName, string fkName ) : bool | ||
CheckFunctionExists ( ProcRef funcName ) : bool | ||
CheckIndexExists ( TableRef tblName, string idxName ) : bool | ||
CheckIndexPossible ( TableRef tblName, string idxName, bool unique, bool clustered ) : bool | ||
CheckPositionColumnValidity ( TableRef tblName, string fkName, string positionColumnName ) : bool | ||
CheckProcedureExists ( ProcRef procName ) : bool | ||
CheckSchemaExists ( string schemaName ) : bool | ||
CheckTableContainsData ( TableRef tblName ) : bool | ||
CheckTableContainsData ( TableRef tblName, IEnumerable |
||
CheckTableExists ( TableRef tblName ) : bool | ||
CheckTriggerExists ( TriggerRef triggerName ) : bool | ||
CheckViewExists ( TableRef viewName ) : bool | ||
CommitTransaction ( ) : void | ||
CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void | ||
CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string discriminatorValue ) : void | ||
CopyFKs ( TableRef srcTblName, string srcColName, TableRef destTblName, string destColName, string srcFKColName ) : void | ||
CountRows ( TableRef tblName ) : long | ||
CreateCheckConstraint ( TableRef tblName, string colName, string newConstraintName, Dictionary |
||
CreateColumn ( TableRef tblName, string colName, DbType type, int size, int scale, bool isNullable ) : void | ||
CreateContinuousSequenceNumberProcedure ( ) : void | ||
CreateDatabase ( string dbName ) : void | ||
CreateEmptyRightsViewUnmaterialized ( TableRef viewName ) : void | ||
CreateFKConstraint ( TableRef tblName, TableRef refTblName, string colName, string constraintName, bool onDeleteCascade ) : void | ||
CreateIndex ( TableRef tblName, string idxName, bool unique, bool clustered ) : void | ||
CreatePositionColumnValidCheckProcedures ( string>.ILookup |
||
CreateRefreshAllRightsProcedure ( List |
||
CreateRefreshRightsOnProcedure ( ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights ) : void | ||
CreateRightsViewUnmaterialized ( TableRef viewName, TableRef tblName, TableRef tblNameRights, IList |
||
CreateSchema ( string schemaName ) : void | ||
CreateSequenceNumberProcedure ( ) : void | ||
CreateTable ( TableRef tblName, IEnumerable |
||
CreateTable ( TableRef tblName, bool idAsIdentityColumn ) : void | ||
CreateTable ( TableRef tblName, bool idAsIdentityColumn, bool createPrimaryKey ) : void | ||
CreateUpdateRightsTrigger ( TriggerRef triggerName, TableRef tblName, List |
||
DbTypeToNative ( DbType type ) : string | ||
DblinkConnect ( TableRef tblName ) : void | ||
Dispose ( ) : void | ||
DropAllObjects ( ) : void | ||
DropCheckConstraint ( TableRef tblName, string constraintName ) : void | ||
DropColumn ( TableRef tblName, string colName ) : void | ||
DropDatabase ( string dbName ) : void | ||
DropFKConstraint ( TableRef tblName, string constraintName ) : void | ||
DropFunction ( ProcRef funcName ) : void | ||
DropIndex ( TableRef tblName, string idxName ) : void | ||
DropProcedure ( ProcRef procName ) : void | ||
DropSchema ( string schemaName, bool force ) : void | ||
DropTable ( TableRef tblName ) : void | ||
DropTrigger ( TriggerRef triggerName ) : void | ||
DropView ( TableRef viewName ) : void | ||
EnsureInfrastructure ( ) : void | ||
ExecRefreshAllRightsProcedure ( ) : void | ||
ExecRefreshRightsOnProcedure ( ProcRef procName ) : void | ||
ExecuteSqlResource ( |
||
GetColumnMaxLength ( TableRef tblName, string colName ) : int | ||
GetFKConstraintNames ( ) : IEnumerable |
||
GetFunctionName ( string schemaName, string funcName ) : ProcRef | ||
GetFunctionNames ( ) : IEnumerable |
||
GetHasColumnDefaultValue ( TableRef tblName, string colName ) : bool | ||
GetIsColumnNullable ( TableRef tblName, string colName ) : bool | ||
GetProcedureDefinition ( ProcRef proc ) : string | ||
GetProcedureName ( string schemaName, string procName ) : ProcRef | ||
GetProcedureNames ( ) : IEnumerable |
||
GetSafeConnectionString ( ) : string | ||
GetSafeConnectionString ( string connectionString ) : string | ||
GetSavedSchema ( ) : string | ||
GetSchemaNames ( ) : IEnumerable |
||
GetTableColumnNames ( TableRef tblName ) : IEnumerable |
||
GetTableColumns ( TableRef tblName ) : IEnumerable |
||
GetTableName ( string schemaName, string tblName ) : TableRef | ||
GetTableNames ( ) : IEnumerable |
||
GetTriggerNames ( ) : IEnumerable |
||
GetViewDefinition ( TableRef view ) : string | ||
GetViewNames ( ) : IEnumerable |
||
InsertFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string fkColName ) : void | ||
LoggingSchemaProviderAdapter ( ISchemaProvider provider ) : System | ||
MapColumnData ( TableRef srcTblName, string srcColNames, TableRef tblName, string colNames, object>.Dictionary | ||
MigrateFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void | ||
NativeToDbType ( string type ) : DbType | ||
Open ( string connectionString ) : void | ||
QuoteIdentifier ( string name ) : string | ||
ReadJoin ( TableRef tblName, IEnumerable |
||
ReadTableData ( TableRef tblName, IEnumerable |
||
ReadTableData ( string sql ) : IDataReader | ||
RefreshDbStats ( ) : void | ||
RenameColumn ( TableRef tblName, string oldColName, string newColName ) : void | ||
RenameDiscriminatorValue ( TableRef tblName, string oldValue, string newValue ) : void | ||
RenameFKConstraint ( TableRef tblName, string oldConstraintName, TableRef refTblName, string colName, string newConstraintName, bool onDeleteCascade ) : void | ||
RenameIndex ( TableRef tblName, string oldIdxName, string newIdxName ) : void | ||
RenameTable ( TableRef oldTblName, TableRef newTblName ) : void | ||
RepairPositionColumn ( TableRef tblName, string positionColumnName ) : bool | ||
RollbackTransaction ( ) : void | ||
SaveSchema ( string schema ) : void | ||
TruncateTable ( TableRef tblName ) : void | ||
WriteDefaultValue ( TableRef tblName, string colName, object value ) : void | ||
WriteDefaultValue ( TableRef tblName, string colName, object value, IEnumerable |
||
WriteGuidDefaultValue ( TableRef tblName, string colName ) : void | ||
WriteGuidDefaultValue ( TableRef tblName, string colName, IEnumerable |
||
WriteTableData ( TableRef destTbl, IDataReader source, IEnumerable |
||
WriteTableData ( TableRef destTbl, IEnumerable |
Метод | Описание | |
---|---|---|
LogExistance ( string type, DboRef dboName, bool result, string spec = "" ) : void | ||
LogExistance ( string type, string name, bool result, string spec = "" ) : void | ||
LogNameFetcher ( string type, IEnumerable |
||
LogNameFetcher ( string type, IEnumerable |
||
LogNameFetcher ( string type, IEnumerable |
public AlterColumn ( TableRef tblName, string colName, DbType type, int size, int scale, bool isNullable ) : void | ||
tblName | TableRef | |
colName | string | |
type | DbType | |
size | int | |
scale | int | |
isNullable | bool | |
Результат | void |
public CheckCheckConstraintExists ( TableRef tblName, string constraintName ) : bool | ||
tblName | TableRef | |
constraintName | string | |
Результат | bool |
public CheckCheckConstraintPossible ( TableRef tblName, string colName, string newConstraintName, Dictionary |
||
tblName | TableRef | |
colName | string | |
newConstraintName | string | |
checkExpressions | Dictionary |
|
Результат | bool |
public CheckColumnContainsNulls ( TableRef tblName, string colName ) : bool | ||
tblName | TableRef | |
colName | string | |
Результат | bool |
public CheckColumnContainsValues ( TableRef tblName, string colName ) : bool | ||
tblName | TableRef | |
colName | string | |
Результат | bool |
public CheckColumnExists ( TableRef tblName, string colName ) : bool | ||
tblName | TableRef | |
colName | string | |
Результат | bool |
public CheckDatabaseExists ( string dbName ) : bool | ||
dbName | string | |
Результат | bool |
public CheckFKColumnContainsUniqueValues ( TableRef tblName, string colName ) : bool | ||
tblName | TableRef | |
colName | string | |
Результат | bool |
public CheckFKConstraintExists ( TableRef tblName, string fkName ) : bool | ||
tblName | TableRef | |
fkName | string | |
Результат | bool |
public CheckFunctionExists ( ProcRef funcName ) : bool | ||
funcName | ProcRef | |
Результат | bool |
public CheckIndexExists ( TableRef tblName, string idxName ) : bool | ||
tblName | TableRef | |
idxName | string | |
Результат | bool |
public CheckIndexPossible ( TableRef tblName, string idxName, bool unique, bool clustered ) : bool | ||
tblName | TableRef | |
idxName | string | |
unique | bool | |
clustered | bool | |
Результат | bool |
public CheckPositionColumnValidity ( TableRef tblName, string fkName, string positionColumnName ) : bool | ||
tblName | TableRef | |
fkName | string | |
positionColumnName | string | |
Результат | bool |
public CheckProcedureExists ( ProcRef procName ) : bool | ||
procName | ProcRef | |
Результат | bool |
public CheckSchemaExists ( string schemaName ) : bool | ||
schemaName | string | |
Результат | bool |
public CheckTableContainsData ( TableRef tblName ) : bool | ||
tblName | TableRef | |
Результат | bool |
public CheckTableContainsData ( TableRef tblName, IEnumerable |
||
tblName | TableRef | |
discriminatorFilter | IEnumerable |
|
Результат | bool |
public CheckTableExists ( TableRef tblName ) : bool | ||
tblName | TableRef | |
Результат | bool |
public CheckTriggerExists ( TriggerRef triggerName ) : bool | ||
triggerName | TriggerRef | |
Результат | bool |
public CheckViewExists ( TableRef viewName ) : bool | ||
viewName | TableRef | |
Результат | bool |
public CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void | ||
srcTblName | TableRef | |
srcColName | string | |
tblName | TableRef | |
colName | string | |
Результат | void |
public CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string discriminatorValue ) : void | ||
srcTblName | TableRef | |
srcColName | string | |
tblName | TableRef | |
colName | string | |
discriminatorValue | string | |
Результат | void |
public CopyFKs ( TableRef srcTblName, string srcColName, TableRef destTblName, string destColName, string srcFKColName ) : void | ||
srcTblName | TableRef | |
srcColName | string | |
destTblName | TableRef | |
destColName | string | |
srcFKColName | string | |
Результат | void |
public CountRows ( TableRef tblName ) : long | ||
tblName | TableRef | |
Результат | long |
public CreateCheckConstraint ( TableRef tblName, string colName, string newConstraintName, Dictionary |
||
tblName | TableRef | |
colName | string | |
newConstraintName | string | |
checkExpressions | Dictionary |
|
Результат | void |
public CreateColumn ( TableRef tblName, string colName, DbType type, int size, int scale, bool isNullable ) : void | ||
tblName | TableRef | |
colName | string | |
type | DbType | |
size | int | |
scale | int | |
isNullable | bool | |
Результат | void |
public CreateContinuousSequenceNumberProcedure ( ) : void | ||
Результат | void |
public CreateDatabase ( string dbName ) : void | ||
dbName | string | |
Результат | void |
public CreateEmptyRightsViewUnmaterialized ( TableRef viewName ) : void | ||
viewName | TableRef | |
Результат | void |
public CreateFKConstraint ( TableRef tblName, TableRef refTblName, string colName, string constraintName, bool onDeleteCascade ) : void | ||
tblName | TableRef | |
refTblName | TableRef | |
colName | string | |
constraintName | string | |
onDeleteCascade | bool | |
Результат | void |
public CreateIndex ( TableRef tblName, string idxName, bool unique, bool clustered ) : void | ||
tblName | TableRef | |
idxName | string | |
unique | bool | |
clustered | bool | |
Результат | void |
public CreatePositionColumnValidCheckProcedures ( string>.ILookup |
||
refSpecs | string>.ILookup | |
Результат | void |
public CreateRefreshAllRightsProcedure ( List |
||
refreshProcNames | List |
|
Результат | void |
public CreateRefreshRightsOnProcedure ( ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights ) : void | ||
procName | ProcRef | |
viewUnmaterializedName | TableRef | |
tblName | TableRef | |
tblNameRights | TableRef | |
Результат | void |
public CreateRightsViewUnmaterialized ( TableRef viewName, TableRef tblName, TableRef tblNameRights, IList |
||
viewName | TableRef | |
tblName | TableRef | |
tblNameRights | TableRef | |
acls | IList |
|
Результат | void |
public CreateSchema ( string schemaName ) : void | ||
schemaName | string | |
Результат | void |
public CreateSequenceNumberProcedure ( ) : void | ||
Результат | void |
public CreateTable ( TableRef tblName, IEnumerable |
||
tblName | TableRef | |
cols | IEnumerable |
|
Результат | void |
public CreateTable ( TableRef tblName, bool idAsIdentityColumn ) : void | ||
tblName | TableRef | |
idAsIdentityColumn | bool | |
Результат | void |
public CreateTable ( TableRef tblName, bool idAsIdentityColumn, bool createPrimaryKey ) : void | ||
tblName | TableRef | |
idAsIdentityColumn | bool | |
createPrimaryKey | bool | |
Результат | void |
public CreateUpdateRightsTrigger ( TriggerRef triggerName, TableRef tblName, List |
||
triggerName | TriggerRef | |
tblName | TableRef | |
tblList | List |
|
dependingCols | List |
|
Результат | void |
public DbTypeToNative ( DbType type ) : string | ||
type | DbType | |
Результат | string |
public DblinkConnect ( TableRef tblName ) : void | ||
tblName | TableRef | |
Результат | void |
public DropCheckConstraint ( TableRef tblName, string constraintName ) : void | ||
tblName | TableRef | |
constraintName | string | |
Результат | void |
public DropColumn ( TableRef tblName, string colName ) : void | ||
tblName | TableRef | |
colName | string | |
Результат | void |
public DropDatabase ( string dbName ) : void | ||
dbName | string | |
Результат | void |
public DropFKConstraint ( TableRef tblName, string constraintName ) : void | ||
tblName | TableRef | |
constraintName | string | |
Результат | void |
public DropFunction ( ProcRef funcName ) : void | ||
funcName | ProcRef | |
Результат | void |
public DropIndex ( TableRef tblName, string idxName ) : void | ||
tblName | TableRef | |
idxName | string | |
Результат | void |
public DropProcedure ( ProcRef procName ) : void | ||
procName | ProcRef | |
Результат | void |
public DropSchema ( string schemaName, bool force ) : void | ||
schemaName | string | |
force | bool | |
Результат | void |
public DropTable ( TableRef tblName ) : void | ||
tblName | TableRef | |
Результат | void |
public DropTrigger ( TriggerRef triggerName ) : void | ||
triggerName | TriggerRef | |
Результат | void |
public DropView ( TableRef viewName ) : void | ||
viewName | TableRef | |
Результат | void |
public ExecRefreshAllRightsProcedure ( ) : void | ||
Результат | void |
public ExecRefreshRightsOnProcedure ( ProcRef procName ) : void | ||
procName | ProcRef | |
Результат | void |
public ExecuteSqlResource ( |
||
type | ||
scriptResourceNameFormat | string | |
Результат | void |
public GetColumnMaxLength ( TableRef tblName, string colName ) : int | ||
tblName | TableRef | |
colName | string | |
Результат | int |
public GetFKConstraintNames ( ) : IEnumerable |
||
Результат | IEnumerable |
public GetFunctionName ( string schemaName, string funcName ) : ProcRef | ||
schemaName | string | |
funcName | string | |
Результат | ProcRef |
public GetHasColumnDefaultValue ( TableRef tblName, string colName ) : bool | ||
tblName | TableRef | |
colName | string | |
Результат | bool |
public GetIsColumnNullable ( TableRef tblName, string colName ) : bool | ||
tblName | TableRef | |
colName | string | |
Результат | bool |
public GetProcedureDefinition ( ProcRef proc ) : string | ||
proc | ProcRef | |
Результат | string |
public GetProcedureName ( string schemaName, string procName ) : ProcRef | ||
schemaName | string | |
procName | string | |
Результат | ProcRef |
public GetProcedureNames ( ) : IEnumerable |
||
Результат | IEnumerable |
public GetSafeConnectionString ( ) : string | ||
Результат | string |
public GetSafeConnectionString ( string connectionString ) : string | ||
connectionString | string | |
Результат | string |
public GetTableColumnNames ( TableRef tblName ) : IEnumerable |
||
tblName | TableRef | |
Результат | IEnumerable |
public GetTableColumns ( TableRef tblName ) : IEnumerable |
||
tblName | TableRef | |
Результат | IEnumerable |
public GetTableName ( string schemaName, string tblName ) : TableRef | ||
schemaName | string | |
tblName | string | |
Результат | TableRef |
public GetViewDefinition ( TableRef view ) : string | ||
view | TableRef | |
Результат | string |
public InsertFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string fkColName ) : void | ||
srcTblName | TableRef | |
srcColName | string | |
tblName | TableRef | |
colName | string | |
fkColName | string | |
Результат | void |
public LoggingSchemaProviderAdapter ( ISchemaProvider provider ) : System | ||
provider | ISchemaProvider | |
Результат | System |
public MapColumnData ( TableRef srcTblName, string srcColNames, TableRef tblName, string colNames, object>.Dictionary | ||
srcTblName | TableRef | |
srcColNames | string | |
tblName | TableRef | |
colNames | string | |
mappings | object>.Dictionary | |
Результат | void |
public MigrateFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void | ||
srcTblName | TableRef | |
srcColName | string | |
tblName | TableRef | |
colName | string | |
Результат | void |
public NativeToDbType ( string type ) : DbType | ||
type | string | |
Результат | DbType |
public Open ( string connectionString ) : void | ||
connectionString | string | |
Результат | void |
public QuoteIdentifier ( string name ) : string | ||
name | string | |
Результат | string |
public ReadJoin ( TableRef tblName, IEnumerable |
||
tblName | TableRef | |
colNames | IEnumerable |
|
joins | IEnumerable |
|
Результат | IDataReader |
public ReadTableData ( TableRef tblName, IEnumerable |
||
tblName | TableRef | |
colNames | IEnumerable |
|
Результат | IDataReader |
public ReadTableData ( string sql ) : IDataReader | ||
sql | string | |
Результат | IDataReader |
public RenameColumn ( TableRef tblName, string oldColName, string newColName ) : void | ||
tblName | TableRef | |
oldColName | string | |
newColName | string | |
Результат | void |
public RenameDiscriminatorValue ( TableRef tblName, string oldValue, string newValue ) : void | ||
tblName | TableRef | |
oldValue | string | |
newValue | string | |
Результат | void |
public RenameFKConstraint ( TableRef tblName, string oldConstraintName, TableRef refTblName, string colName, string newConstraintName, bool onDeleteCascade ) : void | ||
tblName | TableRef | |
oldConstraintName | string | |
refTblName | TableRef | |
colName | string | |
newConstraintName | string | |
onDeleteCascade | bool | |
Результат | void |
public RenameIndex ( TableRef tblName, string oldIdxName, string newIdxName ) : void | ||
tblName | TableRef | |
oldIdxName | string | |
newIdxName | string | |
Результат | void |
public RenameTable ( TableRef oldTblName, TableRef newTblName ) : void | ||
oldTblName | TableRef | |
newTblName | TableRef | |
Результат | void |
public RepairPositionColumn ( TableRef tblName, string positionColumnName ) : bool | ||
tblName | TableRef | |
positionColumnName | string | |
Результат | bool |
public SaveSchema ( string schema ) : void | ||
schema | string | |
Результат | void |
public TruncateTable ( TableRef tblName ) : void | ||
tblName | TableRef | |
Результат | void |
public WriteDefaultValue ( TableRef tblName, string colName, object value ) : void | ||
tblName | TableRef | |
colName | string | |
value | object | |
Результат | void |
public WriteDefaultValue ( TableRef tblName, string colName, object value, IEnumerable |
||
tblName | TableRef | |
colName | string | |
value | object | |
discriminatorFilter | IEnumerable |
|
Результат | void |
public WriteGuidDefaultValue ( TableRef tblName, string colName ) : void | ||
tblName | TableRef | |
colName | string | |
Результат | void |
public WriteGuidDefaultValue ( TableRef tblName, string colName, IEnumerable |
||
tblName | TableRef | |
colName | string | |
discriminatorFilter | IEnumerable |
|
Результат | void |
public WriteTableData ( TableRef destTbl, IDataReader source, IEnumerable |
||
destTbl | TableRef | |
source | IDataReader | |
colNames | IEnumerable |
|
Результат | void |
public WriteTableData ( TableRef destTbl, IEnumerable |
||
destTbl | TableRef | |
colNames | IEnumerable |
|
values | IEnumerable | |
Результат | void |