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

Inheritance: ISchemaProvider

Protected Properties

Property	Type	Description
db	System.Data.OleDb.OleDbConnection
quotePrefix	string
quoteSuffix	string
tx	System.Data.OleDb.OleDbTransaction

Private Properties

Property	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

Public Methods

Method	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

Protected Methods

Method	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

Method	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 method

public BeginTransaction ( ) : void
return	void

CheckColumnContainsNulls() public method

public CheckColumnContainsNulls ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
return	bool

CheckColumnContainsValues() public method

public CheckColumnContainsValues ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
return	bool

CheckColumnExists() public method

public CheckColumnExists ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
return	bool

CheckFKColumnContainsUniqueValues() public method

public CheckFKColumnContainsUniqueValues ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
return	bool

CheckTableContainsData() public method

public CheckTableContainsData ( TableRef tblName ) : bool
tblName	TableRef
return	bool

CheckTableExists() public method

public CheckTableExists ( TableRef tblName ) : bool
tblName	TableRef
return	bool

CheckViewExists() public method

public CheckViewExists ( TableRef viewName ) : bool
viewName	TableRef
return	bool

CommitTransaction() public method

public CommitTransaction ( ) : void
return	void

CopyColumnData() public method

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

CopyColumnData() public method

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

CopyFKs() public method

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

Dispose() public method

public Dispose ( ) : void
return	void

ExecuteSqlResource() public method

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

GetIsColumnNullable() public method

public GetIsColumnNullable ( TableRef tblName, string colName ) : bool
tblName	TableRef
colName	string
return	bool

GetProcedureDefinition() public method

public GetProcedureDefinition ( ProcRef proc ) : string
proc	ProcRef
return	string

GetProcedureName() public method

public GetProcedureName ( string schemaName, string procName ) : ProcRef
schemaName	string
procName	string
return	ProcRef

GetProcedureNames() public method

public GetProcedureNames ( ) : IEnumerable
return	IEnumerable

GetSafeConnectionString() public method

public GetSafeConnectionString ( ) : string
return	string

GetSafeConnectionString() public method

public GetSafeConnectionString ( string connectionString ) : string
connectionString	string
return	string

GetTableColumnNames() public method

public GetTableColumnNames ( TableRef tblName ) : IEnumerable
tblName	TableRef
return	IEnumerable

GetTableColumns() public method

public GetTableColumns ( TableRef tbl ) : IEnumerable
tbl	TableRef
return	IEnumerable

GetTableName() public method

public GetTableName ( string schemaName, string tblName ) : TableRef
schemaName	string
tblName	string
return	TableRef

GetTableNames() public method

public GetTableNames ( ) : IEnumerable
return	IEnumerable

GetViewDefinition() public method

public GetViewDefinition ( TableRef view ) : string
view	TableRef
return	string

GetViewNames() public method

public GetViewNames ( ) : IEnumerable
return	IEnumerable

ISchemaProvider() protected method

protected ISchemaProvider ( ) : void
return	void

ISchemaProvider() protected method

Not supported.

protected ISchemaProvider ( string>.ILookup refSpecs ) : void
refSpecs	string>.ILookup
return	void

ISchemaProvider() protected method

protected ISchemaProvider ( List refreshProcNames ) : void
refreshProcNames	List
return	void

ISchemaProvider() protected method

Not supported.

protected ISchemaProvider ( ProcRef funcName ) : void
funcName	ProcRef
return	void

ISchemaProvider() protected method

Not supported.

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

ISchemaProvider() protected method

Not supported.

protected ISchemaProvider ( TableRef viewName ) : void
viewName	TableRef
return	void

ISchemaProvider() protected method

Not supported.

protected ISchemaProvider ( TableRef tbl, IEnumerable cols ) : void
tbl	TableRef
cols	IEnumerable
return	void

ISchemaProvider() protected method

Not supported.

protected ISchemaProvider ( TableRef oldTblName, TableRef newTblName ) : void
oldTblName	TableRef
newTblName	TableRef
return	void

ISchemaProvider() protected method

Not supported.

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

ISchemaProvider() protected method

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
return	void

ISchemaProvider() protected method

Not supported.

protected ISchemaProvider ( TableRef tblName, bool idAsIdentityColumn ) : void
tblName	TableRef
idAsIdentityColumn	bool
return	void

ISchemaProvider() protected method

Not supported.

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

ISchemaProvider() protected method

Not supported.

protected ISchemaProvider ( TableRef tblName, string constraintName ) : void
tblName	TableRef
constraintName	string
return	void

ISchemaProvider() protected method

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
return	void

ISchemaProvider() protected method

Not supported.

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

ISchemaProvider() protected method

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
return	void

ISchemaProvider() protected method

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
return	void

ISchemaProvider() protected method

Not supported.

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

ISchemaProvider() protected method

Not supported.

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

ISchemaProvider() protected method

Not supported.

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

ISchemaProvider() protected method

Not supported.

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

ISchemaProvider() protected method

Not supported.

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

ISchemaProvider() protected method

Not supported.

protected ISchemaProvider ( TriggerRef triggerName ) : void
triggerName	TriggerRef
return	void

ISchemaProvider() protected method

Not supported.

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

ISchemaProvider() protected method

Not supported.

protected ISchemaProvider ( string dbName ) : void
dbName	string
return	void

ISchemaProvider() protected method

Not supported.

protected ISchemaProvider ( string schemaName, bool force ) : void
schemaName	string
force	bool
return	void

InsertFKs() public method

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

MigrateFKs() public method

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

Open() public method

public Open ( string connectionString ) : void
connectionString	string
return	void

QuoteIdentifier() public method

public QuoteIdentifier ( string val ) : string
val	string
return	string

ReadJoin() public method

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

ReadTableData() public method

public ReadTableData ( TableRef tbl, IEnumerable colNames ) : IDataReader
tbl	TableRef
colNames	IEnumerable
return	IDataReader

ReadTableData() public method

public ReadTableData ( string sql ) : IDataReader
sql	string
return	IDataReader

RefreshDbStats() public method

public RefreshDbStats ( ) : void
return	void

RollbackTransaction() public method

public RollbackTransaction ( ) : void
return	void

WriteTableData() public method

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

WriteTableData() public method

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

Property Details

db protected_oe property

protected OleDbConnection,System.Data.OleDb db
return	System.Data.OleDb.OleDbConnection

quotePrefix protected_oe property

protected string quotePrefix
return	string

quoteSuffix protected_oe property

protected string quoteSuffix
return	string

tx protected_oe property

protected OleDbTransaction,System.Data.OleDb tx
return	System.Data.OleDb.OleDbTransaction