Class DatabaseConnectionProvider

Inheritance

object

DatabaseConnectionProvider

SqlDatabaseConnectionProvider

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DotNetNuke.Data

Assembly: DotNetNuke.dll

Syntax

public abstract class DatabaseConnectionProvider

Constructors

DatabaseConnectionProvider()

Declaration

protected DatabaseConnectionProvider()

Methods

BulkInsert(string, int, string, string, DataTable)

Declaration

public abstract void BulkInsert(string connectionString, int commandTimeout, string procedureName, string tableParameterName, DataTable dataTable)

Parameters

Type	Name	Description
string	connectionString
int	commandTimeout
string	procedureName
string	tableParameterName
DataTable	dataTable

BulkInsert(string, int, string, string, DataTable, Dictionary<string, object>)

Declaration

public abstract void BulkInsert(string connectionString, int commandTimeout, string procedureName, string tableParameterName, DataTable dataTable, Dictionary<string, object> commandParameters)

Parameters

Type	Name	Description
string	connectionString
int	commandTimeout
string	procedureName
string	tableParameterName
DataTable	dataTable
Dictionary<string, object>	commandParameters

ExecuteNonQuery(string, CommandType, int, string)

Declaration

public abstract int ExecuteNonQuery(string connectionString, CommandType commandType, int commandTimeout, string query)

Parameters

Type	Name	Description
string	connectionString
CommandType	commandType
int	commandTimeout
string	query

Returns

Type	Description
int

ExecuteNonQuery(string, CommandType, int, string, object[])

Declaration

public abstract void ExecuteNonQuery(string connectionString, CommandType commandType, int commandTimeout, string procedure, object[] commandParameters)

Parameters

Type	Name	Description
string	connectionString
CommandType	commandType
int	commandTimeout
string	procedure
object[]	commandParameters

ExecuteReader(string, CommandType, int, string, params object[])

Declaration

public abstract IDataReader ExecuteReader(string connectionString, CommandType commandType, int commandTimeout, string procedureName, params object[] commandParameters)

Parameters

Type	Name	Description
string	connectionString
CommandType	commandType
int	commandTimeout
string	procedureName
object[]	commandParameters

Returns

Type	Description
IDataReader

ExecuteScalar<T>(string, CommandType, int, string, params object[])

Declaration

public abstract T ExecuteScalar<T>(string connectionString, CommandType commandType, int commandTimeout, string procedureName, params object[] commandParameters)

Parameters

Type	Name	Description
string	connectionString
CommandType	commandType
int	commandTimeout
string	procedureName
object[]	commandParameters

Returns

Type	Description
T

Type Parameters

Name	Description
T

ExecuteSql(string, CommandType, int, string)

Declaration

public abstract IDataReader ExecuteSql(string connectionString, CommandType commandType, int commandTimeout, string query)

Parameters

Type	Name	Description
string	connectionString
CommandType	commandType
int	commandTimeout
string	query

Returns

Type	Description
IDataReader

Instance()

Declaration

public static DatabaseConnectionProvider Instance()

Returns

Type	Description
DatabaseConnectionProvider

Extension Methods

JsonExtensionsWeb.ToJson(object)