Class AccessConnectionData

Namespace

Dynamicweb.DataManagement

Assembly

Dynamicweb.DataManagement.dll

Provides methods for selecting and modification Access database data

public class AccessConnectionData : DMConnectionData

Inheritance

object

DMConnectionData

AccessConnectionData

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

AccessConnectionData(AccessConnection)

Creates new object defining connection to Access data source

public AccessConnectionData(AccessConnection connection)

Parameters

connection AccessConnection

Methods

CriteriaToNativeQuery(Criteria)

Builds sql query command based on criteria parameters

public override string CriteriaToNativeQuery(Criteria criteria)

Parameters

criteria Criteria

Criteria instance

Returns

string

string representation of sql command text

GetCriteriaVariables(Criteria)

Gets variable of criteria

public override IEnumerable<QueryVariable> GetCriteriaVariables(Criteria criteria)

Parameters

criteria Criteria

Criteria object

Returns

IEnumerable<QueryVariable>

Colection of query variables

GetDataSet(string)

Retrieves dataset based on sqlCommand

public DataSet GetDataSet(string sqlCommandText)

Parameters

sqlCommandText string

Text of sql command

Returns

DataSet

DataSet

InsertTableRow(string, FieldCollection)

Inserts row with data into table

public override bool InsertTableRow(string tableName, FieldCollection fields)

Parameters

tableName string

Name of target table

fields FieldCollection

Field collection to be inserted

Returns

bool

True if operation succeded

SelectQuery(Criteria, IEnumerable<QueryVariable>)

Gets data as DataTable using criataria with defined values

public override DataTable SelectQuery(Criteria criteria, IEnumerable<QueryVariable> variables)

Parameters

criteria Criteria

Criteria object

variables IEnumerable<QueryVariable>

Collection of query variables

Returns

DataTable

Datatable object

UpdateTableRow(string, FieldCollection)

Updates row in table with new data

public override bool UpdateTableRow(string tableName, FieldCollection fields)

Parameters

tableName string

Name of table

fields FieldCollection

Collection of Fields

Returns

bool

True if operation succeded