Class VistaDBConnectionProviderBase

Namespace

DevExpress.Xpo.DB

Assembly

DevExpress.Xpo.v24.1.dll

public abstract class VistaDBConnectionProviderBase : ConnectionProviderSql, IDisposable

Inheritance

object

VistaDBConnectionProviderBase

Implements

IDisposable

Derived

VistaDB5ConnectionProvider

VistaDB6ConnectionProvider

VistaDBConnectionProvider

Constructors

VistaDBConnectionProviderBase(IDbConnection, AutoCreateOption)

public VistaDBConnectionProviderBase(IDbConnection connection, AutoCreateOption autoCreateOption)

Parameters

connection IDbConnection

autoCreateOption AutoCreateOption

Fields

VistaDB4AssemblyName

protected const string VistaDB4AssemblyName = "VistaDB.4"

Field Value

string

VistaDB5AssemblyName

protected const string VistaDB5AssemblyName = "VistaDB.5.NET40"

Field Value

string

VistaDB6AssemblyName

protected const string VistaDB6AssemblyName = "VistaDB.6"

Field Value

string

Properties

BraceJoin

public override bool BraceJoin { get; }

Property Value

bool

DbTypeMapper

protected override DbTypeMapperBase DbTypeMapper { get; }

Property Value

DbTypeMapperBase

MaxBinaryDataType

protected virtual string MaxBinaryDataType { get; }

Property Value

string

MaxBinarySize

protected virtual int MaxBinarySize { get; }

Property Value

int

MaxStringDataType

protected virtual string MaxStringDataType { get; }

Property Value

string

MaxStringSize

protected virtual int MaxStringSize { get; }

Property Value

int

NeedsIndexForForeignKey

protected override bool NeedsIndexForForeignKey { get; }

Property Value

bool

SingleDataType

protected virtual string SingleDataType { get; }

Property Value

string

Methods

BeginTransactionCore(object)

protected override void BeginTransactionCore(object il)

Parameters

il object

CollectTablesToCreate(ICollection)

public override ICollection CollectTablesToCreate(ICollection tables)

Parameters

tables ICollection

Returns

ICollection

CommandBuilderDeriveParameters(IDbCommand)

protected override void CommandBuilderDeriveParameters(IDbCommand command)

Parameters

command IDbCommand

CommitTransactionCore()

protected override void CommitTransactionCore()

ConvertToDbParameter(object, TypeCode)

protected override object ConvertToDbParameter(object clientValue, TypeCode clientValueTypeCode)

Parameters

clientValue object

clientValueTypeCode TypeCode

Returns

object

CreateColumn(DBTable, DBColumn)

public override void CreateColumn(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

CreateDataBase()

protected override void CreateDataBase()

CreateDbTypeMapper(Type, Type)

protected abstract DbTypeMapperBase CreateDbTypeMapper(Type vistaDbTypeEnumType, Type vistaDbParameterType)

Parameters

vistaDbTypeEnumType Type

vistaDbParameterType Type

Returns

DbTypeMapperBase

CreateForeignKey(DBTable, DBForeignKey)

public override void CreateForeignKey(DBTable table, DBForeignKey fk)

Parameters

table DBTable

fk DBForeignKey

CreateIndex(DBTable, DBIndex)

public override void CreateIndex(DBTable table, DBIndex index)

Parameters

table DBTable

index DBIndex

CreateParameter(IDbCommand, object, string, DBColumnType, string, int)

protected override IDataParameter CreateParameter(IDbCommand command, object value, string name, DBColumnType dbType, string dbTypeName, int size)

Parameters

command IDbCommand

value object

name string

dbType DBColumnType

dbTypeName string

size int

Returns

IDataParameter

CreatePrimaryKey(DBTable)

public override void CreatePrimaryKey(DBTable table)

Parameters

table DBTable

CreateTable(DBTable)

public override void CreateTable(DBTable table)

Parameters

table DBTable

Dispose()

public void Dispose()

FormatBinary(BinaryOperatorType, string, string)

public override string FormatBinary(BinaryOperatorType operatorType, string leftOperand, string rightOperand)

Parameters

operatorType BinaryOperatorType

leftOperand string

rightOperand string

Returns

string

FormatColumn(string)

public override string FormatColumn(string columnName)

Parameters

columnName string

Returns

string

FormatColumn(string, string)

public override string FormatColumn(string columnName, string tableAlias)

Parameters

columnName string

tableAlias string

Returns

string

FormatConstant(object)

protected virtual string FormatConstant(object value)

Parameters

value object

Returns

string

FormatConstraint(string)

public override string FormatConstraint(string constraintName)

Parameters

constraintName string

Returns

string

FormatDelete(string, string)

public override string FormatDelete(string tableName, string whereClause)

Parameters

tableName string

whereClause string

Returns

string

FormatFunction(FunctionOperatorType, params string[])

public override string FormatFunction(FunctionOperatorType operatorType, params string[] operands)

Parameters

operatorType FunctionOperatorType

operands string[]

Returns

string

FormatFunction(ProcessParameter, FunctionOperatorType, params object[])

public override string FormatFunction(ProcessParameter processParameter, FunctionOperatorType operatorType, params object[] operands)

Parameters

processParameter ProcessParameter

operatorType FunctionOperatorType

operands object[]

Returns

string

FormatInsert(string, string, string)

public override string FormatInsert(string tableName, string fields, string values)

Parameters

tableName string

fields string

values string

Returns

string

FormatInsertDefaultValues(string)

public override string FormatInsertDefaultValues(string tableName)

Parameters

tableName string

Returns

string

FormatSelect(string, string, string, string, string, string, int)

public override string FormatSelect(string selectedPropertiesSql, string fromSql, string whereSql, string orderBySql, string groupBySql, string havingSql, int topSelectedRecords)

Parameters

selectedPropertiesSql string

fromSql string

whereSql string

orderBySql string

groupBySql string

havingSql string

topSelectedRecords int

Returns

string

FormatTable(string, string)

public override string FormatTable(string schema, string tableName)

Parameters

schema string

tableName string

Returns

string

FormatTable(string, string, string)

public override string FormatTable(string schema, string tableName, string tableAlias)

Parameters

schema string

tableName string

tableAlias string

Returns

string

FormatUpdate(string, string, string)

public override string FormatUpdate(string tableName, string sets, string whereClause)

Parameters

tableName string

sets string

whereClause string

Returns

string

GetDBTypeString(DBColumn, out short)

protected string GetDBTypeString(DBColumn column, out short size)

Parameters

column DBColumn

size short

Returns

string

GetIdentity(InsertStatement, TaggedParametersHolder)

protected override long GetIdentity(InsertStatement root, TaggedParametersHolder identitiesByTag)

Parameters

root InsertStatement

identitiesByTag TaggedParametersHolder

Returns

long

GetIdentityAsync(InsertStatement, TaggedParametersHolder, AsyncOperationIdentifier, CancellationToken)

protected override Task<long> GetIdentityAsync(InsertStatement root, TaggedParametersHolder identitiesByTag, AsyncOperationIdentifier asyncOperationId, CancellationToken cancellationToken)

Parameters

root InsertStatement

identitiesByTag TaggedParametersHolder

asyncOperationId AsyncOperationIdentifier

cancellationToken CancellationToken

Returns

Task<long>

GetParameterName(OperandValue, int, ref bool)

public override string GetParameterName(OperandValue parameter, int index, ref bool createParameter)

Parameters

parameter OperandValue

index int

createParameter bool

Returns

string

GetSafeNameTableMaxLength()

protected override int GetSafeNameTableMaxLength()

Returns

int

GetSqlCreateColumnFullAttributes(DBTable, DBColumn)

public override string GetSqlCreateColumnFullAttributes(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForBoolean(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForBoolean(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForByte(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForByte(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForByteArray(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForByteArray(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForChar(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForChar(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForDateTime(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForDateTime(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForDecimal(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForDecimal(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForDouble(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForDouble(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForGuid(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForGuid(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForInt16(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForInt16(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForInt32(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForInt32(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForInt64(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForInt64(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForSByte(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForSByte(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForSingle(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForSingle(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForString(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForString(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForUInt16(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForUInt16(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForUInt32(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForUInt32(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetSqlCreateColumnTypeForUInt64(DBTable, DBColumn)

protected override string GetSqlCreateColumnTypeForUInt64(DBTable table, DBColumn column)

Parameters

table DBTable

column DBColumn

Returns

string

GetStorageTablesList(bool)

public override string[] GetStorageTablesList(bool includeViews)

Parameters

includeViews bool

Returns

string[]

GetStoredProcedures()

public override DBStoredProcedure[] GetStoredProcedures()

Returns

DBStoredProcedure[]

GetTableSchema(DBTable, bool, bool)

public override void GetTableSchema(DBTable table, bool checkIndexes, bool checkForeignKeys)

Parameters

table DBTable

checkIndexes bool

checkForeignKeys bool

OpenConnectionInternal()

protected override void OpenConnectionInternal()

ProcessClearDatabase()

protected override void ProcessClearDatabase()

ProcessUpdateSchema(bool, params DBTable[])

protected override UpdateSchemaResult ProcessUpdateSchema(bool skipIfFirstTableNotExists, params DBTable[] tables)

Parameters

skipIfFirstTableNotExists bool

tables DBTable[]

Returns

UpdateSchemaResult

ProcessUpdateSchemaAsync(AsyncOperationIdentifier, CancellationToken, bool, DBTable[])

protected override Task<UpdateSchemaResult> ProcessUpdateSchemaAsync(AsyncOperationIdentifier asyncOperationId, CancellationToken cancellationToken, bool skipIfFirstTableNotExists, DBTable[] tables)

Parameters

asyncOperationId AsyncOperationIdentifier

cancellationToken CancellationToken

skipIfFirstTableNotExists bool

tables DBTable[]

Returns

Task<UpdateSchemaResult>

RollbackTransactionCore()

protected override void RollbackTransactionCore()

WrapException(Exception, IDbCommand)

protected override Exception WrapException(Exception e, IDbCommand query)

Parameters

e Exception

query IDbCommand

Returns

Exception