C# 클래스 Zetbox.Server.SchemaManagement.OleDbProvider.OleDb

상속: ISchemaProvider
파일 보기 프로젝트 열기: daszat/zetbox

보호된 프로퍼티들

프로퍼티 타입 설명
db System.Data.OleDb.OleDbConnection
quotePrefix string
quoteSuffix string
tx System.Data.OleDb.OleDbTransaction

Private Properties

프로퍼티 타입 설명
ExecuteNonQuery void
FormatSchemaName string
ISchemaProvider DbType
ISchemaProvider IEnumerable
ISchemaProvider IEnumerable
ISchemaProvider IEnumerable
ISchemaProvider IEnumerable
ISchemaProvider ProcRef
ISchemaProvider bool
ISchemaProvider bool
ISchemaProvider bool
ISchemaProvider bool
ISchemaProvider bool
ISchemaProvider bool
ISchemaProvider bool
ISchemaProvider bool
ISchemaProvider int
ISchemaProvider long
ISchemaProvider string
ISchemaProvider string

공개 메소드들

메소드 설명
BeginTransaction ( ) : void
CheckColumnContainsNulls ( TableRef tblName, string colName ) : bool
CheckColumnContainsValues ( TableRef tblName, string colName ) : bool
CheckColumnExists ( TableRef tblName, string colName ) : bool
CheckFKColumnContainsUniqueValues ( TableRef tblName, string colName ) : bool
CheckTableContainsData ( TableRef tblName ) : bool
CheckTableExists ( TableRef tblName ) : 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
Dispose ( ) : void
ExecuteSqlResource ( Type type, string scriptResourceNameFormat ) : void
GetIsColumnNullable ( TableRef tblName, string colName ) : bool
GetProcedureDefinition ( ProcRef proc ) : string
GetProcedureName ( string schemaName, string procName ) : ProcRef
GetProcedureNames ( ) : IEnumerable
GetSafeConnectionString ( ) : string
GetSafeConnectionString ( string connectionString ) : string
GetTableColumnNames ( TableRef tblName ) : IEnumerable
GetTableColumns ( TableRef tbl ) : IEnumerable
GetTableName ( string schemaName, string tblName ) : TableRef
GetTableNames ( ) : IEnumerable
GetViewDefinition ( TableRef view ) : string
GetViewNames ( ) : IEnumerable
InsertFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string fkColName ) : void
MigrateFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void
Open ( string connectionString ) : void
QuoteIdentifier ( string val ) : string
ReadJoin ( TableRef tbl, IEnumerable colNames, IEnumerable joins ) : IDataReader
ReadTableData ( TableRef tbl, IEnumerable colNames ) : IDataReader
ReadTableData ( string sql ) : IDataReader
RefreshDbStats ( ) : void
RollbackTransaction ( ) : void
WriteTableData ( TableRef destTbl, IDataReader source, IEnumerable colNames ) : void
WriteTableData ( TableRef tbl, IEnumerable colNames, System values ) : void

보호된 메소드들

메소드 설명
ISchemaProvider ( ) : void
ISchemaProvider ( string>.ILookup refSpecs ) : void

Not supported.

ISchemaProvider ( List refreshProcNames ) : void
ISchemaProvider ( ProcRef funcName ) : void

Not supported.

ISchemaProvider ( ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights ) : void

Not supported.

ISchemaProvider ( TableRef viewName ) : void

Not supported.

ISchemaProvider ( TableRef tbl, IEnumerable cols ) : void

Not supported.

ISchemaProvider ( TableRef oldTblName, TableRef newTblName ) : void

Not supported.

ISchemaProvider ( TableRef viewName, TableRef tblName, TableRef tblNameRights, IList acls ) : void

Not supported.

ISchemaProvider ( TableRef tblName, TableRef refTblName, string colName, string newConstraintName, bool onDeleteCascade ) : void

Not supported.

ISchemaProvider ( TableRef tblName, bool idAsIdentityColumn ) : void

Not supported.

ISchemaProvider ( TableRef tblName, bool idAsIdentityColumn, bool createPrimaryKey ) : void

Not supported.

ISchemaProvider ( TableRef tblName, string constraintName ) : void

Not supported.

ISchemaProvider ( TableRef tblName, string colName, DbType type, int size, int scale, bool isNullable ) : void

Not supported.

ISchemaProvider ( TableRef tblName, string colName, IEnumerable discriminatorFilter ) : void

Not supported.

ISchemaProvider ( TableRef srcTblName, string srcColNames, TableRef tblName, string colNames, object>.Dictionary mappings ) : void

Not supported.

ISchemaProvider ( TableRef tblName, string oldConstraintName, TableRef refTblName, string colName, string newConstraintName, bool onDeleteCascade ) : void

Not supported.

ISchemaProvider ( TableRef tblName, string idxName, bool unique, bool clustered ) : void

Not supported.

ISchemaProvider ( TableRef tblName, string colName, object value ) : void

Not supported.

ISchemaProvider ( TableRef tblName, string colName, object value, IEnumerable discriminatorFilter ) : void

Not supported.

ISchemaProvider ( TableRef tblName, string oldColName, string newColName ) : void

Not supported.

ISchemaProvider ( TableRef tblName, string colName, string newConstraintName, Dictionary checkExpression ) : void

Not supported.

ISchemaProvider ( TriggerRef triggerName ) : void

Not supported.

ISchemaProvider ( TriggerRef triggerName, TableRef tblName, List tblList, List dependingCols ) : void

Not supported.

ISchemaProvider ( string dbName ) : void

Not supported.

ISchemaProvider ( string schemaName, bool force ) : void

Not supported.

비공개 메소드들

메소드 설명
ExecuteNonQuery ( string nonQueryFormat ) : void
FormatSchemaName ( DboRef dbo ) : string
ISchemaProvider ( string type ) : DbType

Not implemented.

ISchemaProvider ( ) : IEnumerable

Not supported.

ISchemaProvider ( ) : IEnumerable

Not supported.

ISchemaProvider ( ) : IEnumerable

Not supported.

ISchemaProvider ( ) : IEnumerable

Not supported.

ISchemaProvider ( string schemaName, string funcName ) : ProcRef

Not supported.

ISchemaProvider ( ProcRef funcName ) : bool

Not supported.

ISchemaProvider ( TableRef tblName, IEnumerable discriminatorFilter ) : bool

Not supported.

ISchemaProvider ( TableRef tblName, string constraintName ) : bool
ISchemaProvider ( TableRef tblName, string idxName, bool unique, bool clustered ) : bool

Not supported.

ISchemaProvider ( TableRef tblName, string fkName, string posName ) : bool

Not supported.

ISchemaProvider ( TableRef tblName, string colName, string newConstraintName, Dictionary checkExpression ) : bool

Not supported.

ISchemaProvider ( TriggerRef triggerName ) : bool

Not supported.

ISchemaProvider ( string dbName ) : bool

Not supported.

ISchemaProvider ( TableRef tblName, string colName ) : int

Not supported.

ISchemaProvider ( TableRef tblName ) : long

Not supported.

ISchemaProvider ( ) : string

Not supported.

ISchemaProvider ( DbType type ) : string

Not implemented.

메소드 상세

BeginTransaction() 공개 메소드

public BeginTransaction ( ) : void
리턴 void

CheckColumnContainsNulls() 공개 메소드

public CheckColumnContainsNulls ( TableRef tblName, string colName ) : bool
tblName TableRef
colName string
리턴 bool

CheckColumnContainsValues() 공개 메소드

public CheckColumnContainsValues ( TableRef tblName, string colName ) : bool
tblName TableRef
colName string
리턴 bool

CheckColumnExists() 공개 메소드

public CheckColumnExists ( TableRef tblName, string colName ) : bool
tblName TableRef
colName string
리턴 bool

CheckFKColumnContainsUniqueValues() 공개 메소드

public CheckFKColumnContainsUniqueValues ( TableRef tblName, string colName ) : bool
tblName TableRef
colName string
리턴 bool

CheckTableContainsData() 공개 메소드

public CheckTableContainsData ( TableRef tblName ) : bool
tblName TableRef
리턴 bool

CheckTableExists() 공개 메소드

public CheckTableExists ( TableRef tblName ) : bool
tblName TableRef
리턴 bool

CheckViewExists() 공개 메소드

public CheckViewExists ( TableRef viewName ) : bool
viewName TableRef
리턴 bool

CommitTransaction() 공개 메소드

public CommitTransaction ( ) : void
리턴 void

CopyColumnData() 공개 메소드

public CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void
srcTblName TableRef
srcColName string
tblName TableRef
colName string
리턴 void

CopyColumnData() 공개 메소드

public CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string discriminatorValue ) : void
srcTblName TableRef
srcColName string
tblName TableRef
colName string
discriminatorValue string
리턴 void

CopyFKs() 공개 메소드

public CopyFKs ( TableRef srcTblName, string srcColName, TableRef destTblName, string destColName, string srcFKColName ) : void
srcTblName TableRef
srcColName string
destTblName TableRef
destColName string
srcFKColName string
리턴 void

Dispose() 공개 메소드

public Dispose ( ) : void
리턴 void

ExecuteSqlResource() 공개 메소드

public ExecuteSqlResource ( Type type, string scriptResourceNameFormat ) : void
type System.Type
scriptResourceNameFormat string
리턴 void

GetIsColumnNullable() 공개 메소드

public GetIsColumnNullable ( TableRef tblName, string colName ) : bool
tblName TableRef
colName string
리턴 bool

GetProcedureDefinition() 공개 메소드

public GetProcedureDefinition ( ProcRef proc ) : string
proc ProcRef
리턴 string

GetProcedureName() 공개 메소드

public GetProcedureName ( string schemaName, string procName ) : ProcRef
schemaName string
procName string
리턴 ProcRef

GetProcedureNames() 공개 메소드

public GetProcedureNames ( ) : IEnumerable
리턴 IEnumerable

GetSafeConnectionString() 공개 메소드

public GetSafeConnectionString ( ) : string
리턴 string

GetSafeConnectionString() 공개 메소드

public GetSafeConnectionString ( string connectionString ) : string
connectionString string
리턴 string

GetTableColumnNames() 공개 메소드

public GetTableColumnNames ( TableRef tblName ) : IEnumerable
tblName TableRef
리턴 IEnumerable

GetTableColumns() 공개 메소드

public GetTableColumns ( TableRef tbl ) : IEnumerable
tbl TableRef
리턴 IEnumerable

GetTableName() 공개 메소드

public GetTableName ( string schemaName, string tblName ) : TableRef
schemaName string
tblName string
리턴 TableRef

GetTableNames() 공개 메소드

public GetTableNames ( ) : IEnumerable
리턴 IEnumerable

GetViewDefinition() 공개 메소드

public GetViewDefinition ( TableRef view ) : string
view TableRef
리턴 string

GetViewNames() 공개 메소드

public GetViewNames ( ) : IEnumerable
리턴 IEnumerable

ISchemaProvider() 보호된 메소드

protected ISchemaProvider ( ) : void
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( string>.ILookup refSpecs ) : void
refSpecs string>.ILookup
리턴 void

ISchemaProvider() 보호된 메소드

protected ISchemaProvider ( List refreshProcNames ) : void
refreshProcNames List
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( ProcRef funcName ) : void
funcName ProcRef
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights ) : void
procName ProcRef
viewUnmaterializedName TableRef
tblName TableRef
tblNameRights TableRef
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef viewName ) : void
viewName TableRef
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef tbl, IEnumerable cols ) : void
tbl TableRef
cols IEnumerable
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef oldTblName, TableRef newTblName ) : void
oldTblName TableRef
newTblName TableRef
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef viewName, TableRef tblName, TableRef tblNameRights, IList acls ) : void
viewName TableRef
tblName TableRef
tblNameRights TableRef
acls IList
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef tblName, TableRef refTblName, string colName, string newConstraintName, bool onDeleteCascade ) : void
tblName TableRef
refTblName TableRef
colName string
newConstraintName string
onDeleteCascade bool
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef tblName, bool idAsIdentityColumn ) : void
tblName TableRef
idAsIdentityColumn bool
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef tblName, bool idAsIdentityColumn, bool createPrimaryKey ) : void
tblName TableRef
idAsIdentityColumn bool
createPrimaryKey bool
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef tblName, string constraintName ) : void
tblName TableRef
constraintName string
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( 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

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef tblName, string colName, IEnumerable discriminatorFilter ) : void
tblName TableRef
colName string
discriminatorFilter IEnumerable
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef srcTblName, string srcColNames, TableRef tblName, string colNames, object>.Dictionary mappings ) : void
srcTblName TableRef
srcColNames string
tblName TableRef
colNames string
mappings object>.Dictionary
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( 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

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef tblName, string idxName, bool unique, bool clustered ) : void
tblName TableRef
idxName string
unique bool
clustered bool
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef tblName, string colName, object value ) : void
tblName TableRef
colName string
value object
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef tblName, string colName, object value, IEnumerable discriminatorFilter ) : void
tblName TableRef
colName string
value object
discriminatorFilter IEnumerable
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef tblName, string oldColName, string newColName ) : void
tblName TableRef
oldColName string
newColName string
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TableRef tblName, string colName, string newConstraintName, Dictionary checkExpression ) : void
tblName TableRef
colName string
newConstraintName string
checkExpression Dictionary
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TriggerRef triggerName ) : void
triggerName TriggerRef
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( TriggerRef triggerName, TableRef tblName, List tblList, List dependingCols ) : void
triggerName TriggerRef
tblName TableRef
tblList List
dependingCols List
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( string dbName ) : void
dbName string
리턴 void

ISchemaProvider() 보호된 메소드

Not supported.
protected ISchemaProvider ( string schemaName, bool force ) : void
schemaName string
force bool
리턴 void

InsertFKs() 공개 메소드

public InsertFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string fkColName ) : void
srcTblName TableRef
srcColName string
tblName TableRef
colName string
fkColName string
리턴 void

MigrateFKs() 공개 메소드

public MigrateFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void
srcTblName TableRef
srcColName string
tblName TableRef
colName string
리턴 void

Open() 공개 메소드

public Open ( string connectionString ) : void
connectionString string
리턴 void

QuoteIdentifier() 공개 메소드

public QuoteIdentifier ( string val ) : string
val string
리턴 string

ReadJoin() 공개 메소드

public ReadJoin ( TableRef tbl, IEnumerable colNames, IEnumerable joins ) : IDataReader
tbl TableRef
colNames IEnumerable
joins IEnumerable
리턴 IDataReader

ReadTableData() 공개 메소드

public ReadTableData ( TableRef tbl, IEnumerable colNames ) : IDataReader
tbl TableRef
colNames IEnumerable
리턴 IDataReader

ReadTableData() 공개 메소드

public ReadTableData ( string sql ) : IDataReader
sql string
리턴 IDataReader

RefreshDbStats() 공개 메소드

public RefreshDbStats ( ) : void
리턴 void

RollbackTransaction() 공개 메소드

public RollbackTransaction ( ) : void
리턴 void

WriteTableData() 공개 메소드

public WriteTableData ( TableRef destTbl, IDataReader source, IEnumerable colNames ) : void
destTbl TableRef
source IDataReader
colNames IEnumerable
리턴 void

WriteTableData() 공개 메소드

public WriteTableData ( TableRef tbl, IEnumerable colNames, System values ) : void
tbl TableRef
colNames IEnumerable
values System
리턴 void

프로퍼티 상세

db 보호되어 있는 프로퍼티

protected OleDbConnection,System.Data.OleDb db
리턴 System.Data.OleDb.OleDbConnection

quotePrefix 보호되어 있는 프로퍼티

protected string quotePrefix
리턴 string

quoteSuffix 보호되어 있는 프로퍼티

protected string quoteSuffix
리턴 string

tx 보호되어 있는 프로퍼티

protected OleDbTransaction,System.Data.OleDb tx
리턴 System.Data.OleDb.OleDbTransaction