Take the community feedback survey now.

AI OnAI Off

Class DataAccessBase

Helper base class for data access. It is recommended to use IDatabaseExecutor directly instead.

Inheritance
System.Object
DataAccessBase
CategoryDB
ContentAclDB
ContentCoreDataDB
ContentPathDB
ContentSoftLinkDB
ContentVersionDB
ConvertPageTypeDB
DatabaseInformationDB
FrameDB
LanguageDB
PageLanguageSettingDB
PageQuickSearchDB
PlugInDB
PropertyDefinitionTypeDB
PropertySearchDB
SiteConfigDB
TabInfoDB
UniqueSequenceDB
URLSegmentDB
Namespace: EPiServer.DataAccess
Assembly: EPiServer.dll
Version: 12.0.3
Syntax
public abstract class DataAccessBase : Object

Constructors

DataAccessBase(IDatabaseExecutor)

Initializes a new instance of the DataAccessBase class. This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected DataAccessBase(IDatabaseExecutor databaseExecuor)
Parameters
Type Name Description
IDatabaseExecutor databaseExecuor

The IDatabaseExecutor that will be used for database communication.

Properties

Executor

Set database handler used for this instance This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
public IDatabaseExecutor Executor { get; set; }
Property Value
Type Description
IDatabaseExecutor

Methods

CreateCommand()

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected DbCommand CreateCommand()
Returns
Type Description
System.Data.Common.DbCommand

CreateCommand(String)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected DbCommand CreateCommand(string cmdText)
Parameters
Type Name Description
System.String cmdText
Returns
Type Description
System.Data.Common.DbCommand

CreateDataAdapter()

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
public DbDataAdapter CreateDataAdapter()
Returns
Type Description
System.Data.Common.DbDataAdapter

CreateDataAdapter(DbCommand)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
public DbDataAdapter CreateDataAdapter(DbCommand cmd)
Parameters
Type Name Description
System.Data.Common.DbCommand cmd
Returns
Type Description
System.Data.Common.DbDataAdapter

CreateDataAdapter(DbCommand, DbCommand, DbCommand)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
public DbDataAdapter CreateDataAdapter(DbCommand cmdInsert, DbCommand cmdUpdate, DbCommand cmdDelete)
Parameters
Type Name Description
System.Data.Common.DbCommand cmdInsert
System.Data.Common.DbCommand cmdUpdate
System.Data.Common.DbCommand cmdDelete
Returns
Type Description
System.Data.Common.DbDataAdapter

CreateDataAdapter(DbCommand, DbCommand, DbCommand, DbCommand)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
public DbDataAdapter CreateDataAdapter(DbCommand cmdSelect, DbCommand cmdInsert, DbCommand cmdUpdate, DbCommand cmdDelete)
Parameters
Type Name Description
System.Data.Common.DbCommand cmdSelect
System.Data.Common.DbCommand cmdInsert
System.Data.Common.DbCommand cmdUpdate
System.Data.Common.DbCommand cmdDelete
Returns
Type Description
System.Data.Common.DbDataAdapter

CreateParameter(String, DbType, ParameterDirection, Object)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected DbParameter CreateParameter(string parameterName, DbType dbType, ParameterDirection paramDir, object paramValue)
Parameters
Type Name Description
System.String parameterName
System.Data.DbType dbType
System.Data.ParameterDirection paramDir
System.Object paramValue
Returns
Type Description
System.Data.Common.DbParameter

CreateParameter(String, DbType, Int32)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected DbParameter CreateParameter(string parameterName, DbType dbType, int size)
Parameters
Type Name Description
System.String parameterName
System.Data.DbType dbType
System.Int32 size
Returns
Type Description
System.Data.Common.DbParameter

CreateParameter(String, Object)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected DbParameter CreateParameter(string parameterName, object val)
Parameters
Type Name Description
System.String parameterName
System.Object val
Returns
Type Description
System.Data.Common.DbParameter

CreateParameterSource(String, DbType, Int32, ParameterDirection, String)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected DbParameter CreateParameterSource(string parameterName, DbType dbType, int size, ParameterDirection dir, string sourceColumn)
Parameters
Type Name Description
System.String parameterName
System.Data.DbType dbType
System.Int32 size
System.Data.ParameterDirection dir
System.String sourceColumn
Returns
Type Description
System.Data.Common.DbParameter

CreateParameterSource(String, DbType, Int32, String)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected DbParameter CreateParameterSource(string parameterName, DbType dbType, int size, string sourceColumn)
Parameters
Type Name Description
System.String parameterName
System.Data.DbType dbType
System.Int32 size
System.String sourceColumn
Returns
Type Description
System.Data.Common.DbParameter

CreateParameterType(String, DbType)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected DbParameter CreateParameterType(string parameterName, DbType dbType)
Parameters
Type Name Description
System.String parameterName
System.Data.DbType dbType
Returns
Type Description
System.Data.Common.DbParameter

CreateReturnParameter()

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected DbParameter CreateReturnParameter()
Returns
Type Description
System.Data.Common.DbParameter

CreateTextCommand(String)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected DbCommand CreateTextCommand(string cmdText)
Parameters
Type Name Description
System.String cmdText
Returns
Type Description
System.Data.Common.DbCommand

EscapeWildcardChars(String)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
public string EscapeWildcardChars(string s)
Parameters
Type Name Description
System.String s
Returns
Type Description
System.String

GetReturnValue(DbCommand)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected int GetReturnValue(DbCommand cmd)
Parameters
Type Name Description
System.Data.Common.DbCommand cmd
Returns
Type Description
System.Int32

GetValue(DbCommand, String)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected object GetValue(DbCommand cmd, string parameterName)
Parameters
Type Name Description
System.Data.Common.DbCommand cmd
System.String parameterName
Returns
Type Description
System.Object

ProviderSpecificParameterName(String)

Returns the parameter name decorated according to the rules for the current DataFactory provider. This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
public string ProviderSpecificParameterName(string parameterName)
Parameters
Type Name Description
System.String parameterName

The parameter name that should be decorated.
Returns
Type Description
System.String

The decorated parameter name.

SetValue(DbCommand, String, Object)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected void SetValue(DbCommand cmd, string parameterName, object val)
Parameters
Type Name Description
System.Data.Common.DbCommand cmd
System.String parameterName
System.Object val

ToSystemNull(Object)

This member supports the EPiServer infrastructure and is not intended to be used directly from your code.

Declaration
protected object ToSystemNull(object val)
Parameters
Type Name Description
System.Object val
Returns
Type Description
System.Object

Extension Methods