Class SqlDatabaseConnectionProvider
Inheritance
System.Object
SqlDatabaseConnectionProvider
Assembly: DotNetNuke.dll
Syntax
public class SqlDatabaseConnectionProvider : DatabaseConnectionProvider
Methods
|
Improve this Doc
View Source
BulkInsert(String, Int32, 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 |
System.String |
connectionString |
|
System.Int32 |
commandTimeout |
|
System.String |
procedureName |
|
System.String |
tableParameterName |
|
DataTable |
dataTable |
|
Dictionary<System.String, System.Object> |
commandParameters |
|
Overrides
|
Improve this Doc
View Source
BulkInsert(String, Int32, String, String, DataTable)
Declaration
public override void BulkInsert(string connectionString, int commandTimeout, string procedureName, string tableParameterName, DataTable dataTable)
Parameters
Type |
Name |
Description |
System.String |
connectionString |
|
System.Int32 |
commandTimeout |
|
System.String |
procedureName |
|
System.String |
tableParameterName |
|
DataTable |
dataTable |
|
Overrides
|
Improve this Doc
View Source
ExecuteNonQuery(String, CommandType, Int32, String, Object[])
Declaration
public override void ExecuteNonQuery(string connectionString, CommandType commandType, int commandTimeout, string procedure, object[] commandParameters)
Parameters
Type |
Name |
Description |
System.String |
connectionString |
|
CommandType |
commandType |
|
System.Int32 |
commandTimeout |
|
System.String |
procedure |
|
System.Object[] |
commandParameters |
|
Overrides
|
Improve this Doc
View Source
ExecuteNonQuery(String, CommandType, Int32, String)
Declaration
public override int ExecuteNonQuery(string connectionString, CommandType commandType, int commandTimeout, string query)
Parameters
Type |
Name |
Description |
System.String |
connectionString |
|
CommandType |
commandType |
|
System.Int32 |
commandTimeout |
|
System.String |
query |
|
Returns
Type |
Description |
System.Int32 |
|
Overrides
|
Improve this Doc
View Source
ExecuteReader(String, CommandType, Int32, String, Object[])
Declaration
public override IDataReader ExecuteReader(string connectionString, CommandType commandType, int commandTimeout, string procedureName, params object[] commandParameters)
Parameters
Type |
Name |
Description |
System.String |
connectionString |
|
CommandType |
commandType |
|
System.Int32 |
commandTimeout |
|
System.String |
procedureName |
|
System.Object[] |
commandParameters |
|
Returns
Type |
Description |
IDataReader |
|
Overrides
|
Improve this Doc
View Source
ExecuteScalar<T>(String, CommandType, Int32, String, Object[])
Declaration
public override T ExecuteScalar<T>(string connectionString, CommandType commandType, int commandTimeout, string procedureName, params object[] commandParameters)
Parameters
Type |
Name |
Description |
System.String |
connectionString |
|
CommandType |
commandType |
|
System.Int32 |
commandTimeout |
|
System.String |
procedureName |
|
System.Object[] |
commandParameters |
|
Returns
Type Parameters
Overrides
|
Improve this Doc
View Source
ExecuteSql(String, CommandType, Int32, String)
Declaration
public override IDataReader ExecuteSql(string connectionString, CommandType commandType, int commandTimeout, string query)
Parameters
Type |
Name |
Description |
System.String |
connectionString |
|
CommandType |
commandType |
|
System.Int32 |
commandTimeout |
|
System.String |
query |
|
Returns
Type |
Description |
IDataReader |
|
Overrides
Extension Methods