Class PetaPocoHelper

Inheritance
System.Object
PetaPocoHelper
Namespace: DotNetNuke.Data.PetaPoco
Assembly: DotNetNuke.dll
Syntax
public static class PetaPocoHelper : object

Methods

| Improve this Doc View Source

BulkInsert(String, Int32, String, String, DataTable)

Declaration
public static void BulkInsert(string connectionString, int timeoutSec, string procedureName, string tableParameterName, DataTable dataTable)
Parameters
Type Name Description
System.String connectionString
System.Int32 timeoutSec
System.String procedureName
System.String tableParameterName
DataTable dataTable
| Improve this Doc View Source

BulkInsert(String, String, String, DataTable, Dictionary<String, Object>)

Declaration
public static void BulkInsert(string connectionString, string procedureName, string tableParameterName, DataTable dataTable, Dictionary<string, object> args)
Parameters
Type Name Description
System.String connectionString
System.String procedureName
System.String tableParameterName
DataTable dataTable
Dictionary<System.String, System.Object> args
| Improve this Doc View Source

BulkInsert(String, String, String, DataTable, Int32, Dictionary<String, Object>)

Declaration
public static void BulkInsert(string connectionString, string procedureName, string tableParameterName, DataTable dataTable, int timeoutSec, Dictionary<string, object> args)
Parameters
Type Name Description
System.String connectionString
System.String procedureName
System.String tableParameterName
DataTable dataTable
System.Int32 timeoutSec
Dictionary<System.String, System.Object> args
| Improve this Doc View Source

BulkInsert(String, String, String, DataTable)

Declaration
public static void BulkInsert(string connectionString, string procedureName, string tableParameterName, DataTable dataTable)
Parameters
Type Name Description
System.String connectionString
System.String procedureName
System.String tableParameterName
DataTable dataTable
| Improve this Doc View Source

ExecuteNonQuery(String, CommandType, Int32, String, Object[])

Declaration
public static void ExecuteNonQuery(string connectionString, CommandType type, int timeoutSec, string sql, params object[] args)
Parameters
Type Name Description
System.String connectionString
CommandType type
System.Int32 timeoutSec
System.String sql
System.Object[] args
| Improve this Doc View Source

ExecuteNonQuery(String, CommandType, String, Object[])

Declaration
public static void ExecuteNonQuery(string connectionString, CommandType type, string sql, params object[] args)
Parameters
Type Name Description
System.String connectionString
CommandType type
System.String sql
System.Object[] args
| Improve this Doc View Source

ExecuteReader(String, CommandType, Int32, String, Object[])

Declaration
public static IDataReader ExecuteReader(string connectionString, CommandType type, int timeoutSec, string sql, params object[] args)
Parameters
Type Name Description
System.String connectionString
CommandType type
System.Int32 timeoutSec
System.String sql
System.Object[] args
Returns
Type Description
IDataReader
| Improve this Doc View Source

ExecuteReader(String, CommandType, String, Object[])

Declaration
public static IDataReader ExecuteReader(string connectionString, CommandType type, string sql, params object[] args)
Parameters
Type Name Description
System.String connectionString
CommandType type
System.String sql
System.Object[] args
Returns
Type Description
IDataReader
| Improve this Doc View Source

ExecuteScalar<T>(String, CommandType, Int32, String, Object[])

Declaration
public static T ExecuteScalar<T>(string connectionString, CommandType type, int timeoutSec, string sql, params object[] args)
Parameters
Type Name Description
System.String connectionString
CommandType type
System.Int32 timeoutSec
System.String sql
System.Object[] args
Returns
Type Description
T
Type Parameters
Name Description
T
| Improve this Doc View Source

ExecuteScalar<T>(String, CommandType, String, Object[])

Declaration
public static T ExecuteScalar<T>(string connectionString, CommandType type, string sql, params object[] args)
Parameters
Type Name Description
System.String connectionString
CommandType type
System.String sql
System.Object[] args
Returns
Type Description
T
Type Parameters
Name Description
T
| Improve this Doc View Source

ExecuteSQL(String, String, Int32)

Declaration
public static void ExecuteSQL(string connectionString, string sql, int timeoutSec)
Parameters
Type Name Description
System.String connectionString
System.String sql
System.Int32 timeoutSec
| Improve this Doc View Source

ExecuteSQL(String, String)

Declaration
public static void ExecuteSQL(string connectionString, string sql)
Parameters
Type Name Description
System.String connectionString
System.String sql