Class PetaPocoHelper

Inheritance

object

PetaPocoHelper

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DotNetNuke.Data.PetaPoco

Assembly: DotNetNuke.dll

Syntax

public static class PetaPocoHelper

Methods

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

Declaration

public static void BulkInsert(string connectionString, int timeoutSec, string procedureName, string tableParameterName, DataTable dataTable)

Parameters

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

BulkInsert(string, string, string, DataTable)

Declaration

public static void BulkInsert(string connectionString, string procedureName, string tableParameterName, DataTable dataTable)

Parameters

Type	Name	Description
string	connectionString
string	procedureName
string	tableParameterName
DataTable	dataTable

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
string	connectionString
string	procedureName
string	tableParameterName
DataTable	dataTable
Dictionary<string, object>	args

BulkInsert(string, string, string, DataTable, int, 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
string	connectionString
string	procedureName
string	tableParameterName
DataTable	dataTable
int	timeoutSec
Dictionary<string, object>	args

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

Declaration

public static void ExecuteNonQuery(string connectionString, CommandType type, int timeoutSec, string sql, params object[] args)

Parameters

Type	Name	Description
string	connectionString
CommandType	type
int	timeoutSec
string	sql
object[]	args

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

Declaration

public static void ExecuteNonQuery(string connectionString, CommandType type, string sql, params object[] args)

Parameters

Type	Name	Description
string	connectionString
CommandType	type
string	sql
object[]	args

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

Declaration

public static IDataReader ExecuteReader(string connectionString, CommandType type, int timeoutSec, string sql, params object[] args)

Parameters

Type	Name	Description
string	connectionString
CommandType	type
int	timeoutSec
string	sql
object[]	args

Returns

Type	Description
IDataReader

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

Declaration

public static IDataReader ExecuteReader(string connectionString, CommandType type, string sql, params object[] args)

Parameters

Type	Name	Description
string	connectionString
CommandType	type
string	sql
object[]	args

Returns

Type	Description
IDataReader

ExecuteSQL(string, string)

Declaration

public static void ExecuteSQL(string connectionString, string sql)

Parameters

Type	Name	Description
string	connectionString
string	sql

ExecuteSQL(string, string, int)

Declaration

public static void ExecuteSQL(string connectionString, string sql, int timeoutSec)

Parameters

Type	Name	Description
string	connectionString
string	sql
int	timeoutSec

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

Declaration

public static T ExecuteScalar<T>(string connectionString, CommandType type, int timeoutSec, string sql, params object[] args)

Parameters

Type	Name	Description
string	connectionString
CommandType	type
int	timeoutSec
string	sql
object[]	args

Returns

Type	Description
T

Type Parameters

Name	Description
T

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

Declaration

public static T ExecuteScalar<T>(string connectionString, CommandType type, string sql, params object[] args)

Parameters

Type	Name	Description
string	connectionString
CommandType	type
string	sql
object[]	args

Returns

Type	Description
T

Type Parameters

Name	Description
T