Class DbProvider

Inheritance

System.Object

DbProvider

OleDbDataProviderBase

OracleProviderBase

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: FChoice.Common.Data

Assembly: FChoice.Common.dll

Syntax

public abstract class DbProvider

Constructors

DbProvider()

Declaration

protected DbProvider()

Properties

CanBatchQueries

Declaration

public virtual bool CanBatchQueries { get; }

Property Value

Type	Description
System.Boolean

ConnectionString

Declaration

public virtual string ConnectionString { get; set; }

Property Value

Type	Description
System.String

MaxInListItems

Declaration

public abstract int MaxInListItems { get; }

Property Value

Type	Description
System.Int32

ProviderCanBatchQueries

Declaration

protected abstract bool ProviderCanBatchQueries { get; }

Property Value

Type	Description
System.Boolean

ProviderName

Declaration

public abstract string ProviderName { get; }

Property Value

Type	Description
System.String

RequiresDbNameParameter

Declaration

public abstract bool RequiresDbNameParameter { get; }

Property Value

Type	Description
System.Boolean

TypeMapper

Declaration

public abstract TypeMapper TypeMapper { get; }

Property Value

Type	Description
TypeMapper

Methods

ConstructConnectionString(NameValueCollection)

Declaration

public static string ConstructConnectionString(NameValueCollection keyValues)

Parameters

Type	Name	Description
System.Collections.Specialized.NameValueCollection	keyValues

Returns

Type	Description
System.String

CreateCommand(IDbConnection)

Declaration

public virtual IDbCommand CreateCommand(IDbConnection dbConnection)

Parameters

Type	Name	Description
System.Data.IDbConnection	dbConnection

Returns

Type	Description
System.Data.IDbCommand

CreateConnectionString(String, String, String, String, String)

Declaration

public abstract string CreateConnectionString(string dbServer, string dbName, string dbUser, string dbPass, string extraParams)

Parameters

Type	Name	Description
System.String	dbServer
System.String	dbName
System.String	dbUser
System.String	dbPass
System.String	extraParams

Returns

Type	Description
System.String

CreateParameter(String, Object)

Declaration

public abstract IDbDataParameter CreateParameter(string name, object value)

Parameters

Type	Name	Description
System.String	name
System.Object	value

Returns

Type	Description
System.Data.IDbDataParameter

FormatDateLiteral(DateTime)

Declaration

public abstract string FormatDateLiteral(DateTime value)

Parameters

Type	Name	Description
System.DateTime	value

Returns

Type	Description
System.String

GetAdapter()

Declaration

public abstract DbDataAdapter GetAdapter()

Returns

Type	Description
System.Data.Common.DbDataAdapter

GetAdapter(IDbConnection)

Declaration

public abstract DbDataAdapter GetAdapter(IDbConnection conn)

Parameters

Type	Name	Description
System.Data.IDbConnection	conn

Returns

Type	Description
System.Data.Common.DbDataAdapter

GetAdapter(IDbConnection, String)

Declaration

public abstract DbDataAdapter GetAdapter(IDbConnection conn, string sqlStmt)

Parameters

Type	Name	Description
System.Data.IDbConnection	conn
System.String	sqlStmt

Returns

Type	Description
System.Data.Common.DbDataAdapter

GetAsStatement(String)

Declaration

public abstract string GetAsStatement(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
System.String

GetBitwiseAndStatement(Object, Object)

Declaration

public abstract string GetBitwiseAndStatement(object operand1, object operand2)

Parameters

Type	Name	Description
System.Object	operand1
System.Object	operand2

Returns

Type	Description
System.String

GetConnection()

Declaration

public abstract IDbConnection GetConnection()

Returns

Type	Description
System.Data.IDbConnection

GetConnection(String)

Declaration

public abstract IDbConnection GetConnection(string conStr)

Parameters

Type	Name	Description
System.String	conStr

Returns

Type	Description
System.Data.IDbConnection

GetDateStatement()

Declaration

public abstract string GetDateStatement()

Returns

Type	Description
System.String

GetDBDate()

Declaration

public abstract DateTime GetDBDate()

Returns

Type	Description
System.DateTime

GetDbVersion()

Declaration

public Version GetDbVersion()

Returns

Type	Description
System.Version

GetDbVersion(Boolean)

Declaration

public Version GetDbVersion(bool force)

Parameters

Type	Name	Description
System.Boolean	force

Returns

Type	Description
System.Version

GetParameterNamePrefix()

Declaration

public abstract string GetParameterNamePrefix()

Returns

Type	Description
System.String

GetVersionFromString(String)

Declaration

protected Version GetVersionFromString(string versionStr)

Parameters

Type	Name	Description
System.String	versionStr

Returns

Type	Description
System.Version

Initialize()

Declaration

protected abstract void Initialize()

Load(XmlNodeList)

Declaration

protected abstract void Load(XmlNodeList configArguments)

Parameters

Type	Name	Description
System.Xml.XmlNodeList	configArguments

ParseConnectionString(String)

Declaration

public static NameValueCollection ParseConnectionString(string connectStr)

Parameters

Type	Name	Description
System.String	connectStr

Returns

Type	Description
System.Collections.Specialized.NameValueCollection

PerformGetDbVersion()

Declaration

protected abstract Version PerformGetDbVersion()

Returns

Type	Description
System.Version

PrepareParameter(IDbDataParameter, CommandType)

Declaration

public virtual void PrepareParameter(IDbDataParameter param, CommandType cmdType)

Parameters

Type	Name	Description
System.Data.IDbDataParameter	param
System.Data.CommandType	cmdType

PrepareSQLStatement(String, CommandType, DataParameterCollection)

Declaration

public abstract string PrepareSQLStatement(string sqlStmt, CommandType cmdType, DataParameterCollection commandParams)

Parameters

Type	Name	Description
System.String	sqlStmt
System.Data.CommandType	cmdType
DataParameterCollection	commandParams

Returns

Type	Description
System.String

RemoveParameterNamePrefix(String)

Declaration

public abstract string RemoveParameterNamePrefix(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
System.String

SetDatabaseParameterTypeForClobText(IDbDataParameter, Boolean)

Declaration

public virtual void SetDatabaseParameterTypeForClobText(IDbDataParameter dbParameter, bool isParameterUnicode)

Parameters

Type	Name	Description
System.Data.IDbDataParameter	dbParameter
System.Boolean	isParameterUnicode

TestConnection()

Declaration

public bool TestConnection()

Returns

Type	Description
System.Boolean

TestConnection(out Exception)

Declaration

public bool TestConnection(out Exception outEx)

Parameters

Type	Name	Description
System.Exception	outEx

Returns

Type	Description
System.Boolean

ValidateConnectionParams(String, String, String, String)

Declaration

public abstract bool ValidateConnectionParams(string dbServer, string dbName, string dbUser, string dbPass)

Parameters

Type	Name	Description
System.String	dbServer
System.String	dbName
System.String	dbUser
System.String	dbPass

Returns

Type	Description
System.Boolean