Class SqlDatabaseConnectionProvider

Inheritance

object

DatabaseConnectionProvider

SqlDatabaseConnectionProvider

Inherited Members

DatabaseConnectionProvider.Instance()

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 class SqlDatabaseConnectionProvider : DatabaseConnectionProvider

Constructors

SqlDatabaseConnectionProvider()

Declaration

public SqlDatabaseConnectionProvider()

Methods

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

Declaration

public override 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

Overrides

DatabaseConnectionProvider.BulkInsert(string, int, string, string, DataTable)

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

Declaration

public override 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

Overrides

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

ExecuteNonQuery(string, CommandType, int, string)

Declaration

public override 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

Overrides

DatabaseConnectionProvider.ExecuteNonQuery(string, CommandType, int, string)

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

Declaration

public override 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

Overrides

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

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

Declaration

public override 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

Overrides

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

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

Declaration

public override 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

Overrides

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

ExecuteSql(string, CommandType, int, string)

Declaration

public override 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

Overrides

DatabaseConnectionProvider.ExecuteSql(string, CommandType, int, string)

Extension Methods

JsonExtensionsWeb.ToJson(object)