C# Class Zetbox.Server.SchemaManagement.OleDbProvider.OleDb

Inheritance: ISchemaProvider

Afficher le fichier Open project: daszat/zetbox

Protected Properties

Свойство	Type	Description
db	System.Data.OleDb.OleDbConnection
quotePrefix	string
quoteSuffix	string
tx	System.Data.OleDb.OleDbTransaction

Private Properties

Свойство	Type	Description
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

Méthodes publiques

Méthode	Description
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

Méthodes protégées

Méthode	Description
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.

Private Methods

Méthode	Description
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.

Method Details

BeginTransaction() public méthode

public BeginTransaction ( ) : void
Résultat	void

CheckColumnContainsNulls() public méthode

public CheckColumnContainsNulls ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
Résultat	bool

CheckColumnContainsValues() public méthode

public CheckColumnContainsValues ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
Résultat	bool

CheckColumnExists() public méthode

public CheckColumnExists ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
Résultat	bool

CheckFKColumnContainsUniqueValues() public méthode

public CheckFKColumnContainsUniqueValues ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
Résultat	bool

CheckTableContainsData() public méthode

public CheckTableContainsData ( TableRef tblName ) : bool
tblName	TableRef
Résultat	bool

CheckTableExists() public méthode

public CheckTableExists ( TableRef tblName ) : bool
tblName	TableRef
Résultat	bool

CheckViewExists() public méthode

public CheckViewExists ( TableRef viewName ) : bool
viewName	TableRef
Résultat	bool

CommitTransaction() public méthode

public CommitTransaction ( ) : void
Résultat	void

CopyColumnData() public méthode

public CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void
srcTblName	TableRef
srcColName	string
tblName	TableRef
colName	string
Résultat	void

CopyColumnData() public méthode

public CopyColumnData ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string discriminatorValue ) : void
srcTblName	TableRef
srcColName	string
tblName	TableRef
colName	string
discriminatorValue	string
Résultat	void

CopyFKs() public méthode

public CopyFKs ( TableRef srcTblName, string srcColName, TableRef destTblName, string destColName, string srcFKColName ) : void
srcTblName	TableRef
srcColName	string
destTblName	TableRef
destColName	string
srcFKColName	string
Résultat	void

Dispose() public méthode

public Dispose ( ) : void
Résultat	void

ExecuteSqlResource() public méthode

public ExecuteSqlResource ( Type type, string scriptResourceNameFormat ) : void
type	System.Type
scriptResourceNameFormat	string
Résultat	void

GetIsColumnNullable() public méthode

public GetIsColumnNullable ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
Résultat	bool

GetProcedureDefinition() public méthode

public GetProcedureDefinition ( ProcRef proc ) : string
proc	ProcRef
Résultat	string

GetProcedureName() public méthode

public GetProcedureName ( string schemaName, string procName ) : ProcRef
schemaName	string
procName	string
Résultat	ProcRef

GetProcedureNames() public méthode

public GetProcedureNames ( ) : IEnumerable
Résultat	IEnumerable

GetSafeConnectionString() public méthode

public GetSafeConnectionString ( ) : string
Résultat	string

GetSafeConnectionString() public méthode

public GetSafeConnectionString ( string connectionString ) : string
connectionString	string
Résultat	string

GetTableColumnNames() public méthode

public GetTableColumnNames ( TableRef tblName ) : IEnumerable
tblName	TableRef
Résultat	IEnumerable

GetTableColumns() public méthode

public GetTableColumns ( TableRef tbl ) : IEnumerable
tbl	TableRef
Résultat	IEnumerable

GetTableName() public méthode

public GetTableName ( string schemaName, string tblName ) : TableRef
schemaName	string
tblName	string
Résultat	TableRef

GetTableNames() public méthode

public GetTableNames ( ) : IEnumerable
Résultat	IEnumerable

GetViewDefinition() public méthode

public GetViewDefinition ( TableRef view ) : string
view	TableRef
Résultat	string

GetViewNames() public méthode

public GetViewNames ( ) : IEnumerable
Résultat	IEnumerable

ISchemaProvider() protected méthode

protected ISchemaProvider ( ) : void
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( string>.ILookup refSpecs ) : void
refSpecs	string>.ILookup
Résultat	void

ISchemaProvider() protected méthode

protected ISchemaProvider ( List refreshProcNames ) : void
refreshProcNames	List
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( ProcRef funcName ) : void
funcName	ProcRef
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( ProcRef procName, TableRef viewUnmaterializedName, TableRef tblName, TableRef tblNameRights ) : void
procName	ProcRef
viewUnmaterializedName	TableRef
tblName	TableRef
tblNameRights	TableRef
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef viewName ) : void
viewName	TableRef
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef tbl, IEnumerable cols ) : void
tbl	TableRef
cols	IEnumerable
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef oldTblName, TableRef newTblName ) : void
oldTblName	TableRef
newTblName	TableRef
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef viewName, TableRef tblName, TableRef tblNameRights, IList acls ) : void
viewName	TableRef
tblName	TableRef
tblNameRights	TableRef
acls	IList
Résultat	void

ISchemaProvider() protected méthode

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
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef tblName, bool idAsIdentityColumn ) : void
tblName	TableRef
idAsIdentityColumn	bool
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef tblName, bool idAsIdentityColumn, bool createPrimaryKey ) : void
tblName	TableRef
idAsIdentityColumn	bool
createPrimaryKey	bool
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef tblName, string constraintName ) : void
tblName	TableRef
constraintName	string
Résultat	void

ISchemaProvider() protected méthode

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
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef tblName, string colName, IEnumerable discriminatorFilter ) : void
tblName	TableRef
colName	string
discriminatorFilter	IEnumerable
Résultat	void

ISchemaProvider() protected méthode

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
Résultat	void

ISchemaProvider() protected méthode

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
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef tblName, string idxName, bool unique, bool clustered ) : void
tblName	TableRef
idxName	string
unique	bool
clustered	bool
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef tblName, string colName, object value ) : void
tblName	TableRef
colName	string
value	object
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef tblName, string colName, object value, IEnumerable discriminatorFilter ) : void
tblName	TableRef
colName	string
value	object
discriminatorFilter	IEnumerable
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef tblName, string oldColName, string newColName ) : void
tblName	TableRef
oldColName	string
newColName	string
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TableRef tblName, string colName, string newConstraintName, Dictionary checkExpression ) : void
tblName	TableRef
colName	string
newConstraintName	string
checkExpression	Dictionary
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TriggerRef triggerName ) : void
triggerName	TriggerRef
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( TriggerRef triggerName, TableRef tblName, List tblList, List dependingCols ) : void
triggerName	TriggerRef
tblName	TableRef
tblList	List
dependingCols	List
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( string dbName ) : void
dbName	string
Résultat	void

ISchemaProvider() protected méthode

Not supported.

protected ISchemaProvider ( string schemaName, bool force ) : void
schemaName	string
force	bool
Résultat	void

InsertFKs() public méthode

public InsertFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName, string fkColName ) : void
srcTblName	TableRef
srcColName	string
tblName	TableRef
colName	string
fkColName	string
Résultat	void

MigrateFKs() public méthode

public MigrateFKs ( TableRef srcTblName, string srcColName, TableRef tblName, string colName ) : void
srcTblName	TableRef
srcColName	string
tblName	TableRef
colName	string
Résultat	void

Open() public méthode

public Open ( string connectionString ) : void
connectionString	string
Résultat	void

QuoteIdentifier() public méthode

public QuoteIdentifier ( string val ) : string
val	string
Résultat	string

ReadJoin() public méthode

public ReadJoin ( TableRef tbl, IEnumerable colNames, IEnumerable joins ) : IDataReader
tbl	TableRef
colNames	IEnumerable
joins	IEnumerable
Résultat	IDataReader

ReadTableData() public méthode

public ReadTableData ( TableRef tbl, IEnumerable colNames ) : IDataReader
tbl	TableRef
colNames	IEnumerable
Résultat	IDataReader

ReadTableData() public méthode

public ReadTableData ( string sql ) : IDataReader
sql	string
Résultat	IDataReader

RefreshDbStats() public méthode

public RefreshDbStats ( ) : void
Résultat	void

RollbackTransaction() public méthode

public RollbackTransaction ( ) : void
Résultat	void

WriteTableData() public méthode

public WriteTableData ( TableRef destTbl, IDataReader source, IEnumerable colNames ) : void
destTbl	TableRef
source	IDataReader
colNames	IEnumerable
Résultat	void

WriteTableData() public méthode

public WriteTableData ( TableRef tbl, IEnumerable colNames, System values ) : void
tbl	TableRef
colNames	IEnumerable
values	System
Résultat	void

Property Details

db protected_oe property

protected OleDbConnection,System.Data.OleDb db
Résultat	System.Data.OleDb.OleDbConnection

quotePrefix protected_oe property

protected string quotePrefix
Résultat	string

quoteSuffix protected_oe property

protected string quoteSuffix
Résultat	string

tx protected_oe property

protected OleDbTransaction,System.Data.OleDb tx
Résultat	System.Data.OleDb.OleDbTransaction