Class MsSqlConnectionData
- Namespace
- Dynamicweb.DataManagement
- Assembly
- Dynamicweb.DataManagement.dll
Provides methods for selecting and modification MS SQL Server database data
public class MsSqlConnectionData : DMConnectionData
- Inheritance
-
MsSqlConnectionData
- Inherited Members
Constructors
MsSqlConnectionData(MsSqlConnection)
Creates new object defining connection to MS SQL Server data source
public MsSqlConnectionData(MsSqlConnection connection)
Parameters
connection
MsSqlConnection
Methods
CriteriaToNativeQuery(Criteria)
Builds sql query command based on criteria parameters
public override string CriteriaToNativeQuery(Criteria criteria)
Parameters
criteria
CriteriaCriteria instance
Returns
- string
string representation of sql command text
GetCriteriaVariables(Criteria)
Gets variable of criteria
public override IEnumerable<QueryVariable> GetCriteriaVariables(Criteria criteria)
Parameters
criteria
CriteriaCriteria object
Returns
- IEnumerable<QueryVariable>
Colection of query variables
GetDataSet(string)
Retrieves dataset based on sqlCommand
public DataSet GetDataSet(string sqlCommandText)
Parameters
sqlCommandText
stringText 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
stringName of target table
fields
FieldCollectionField 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
CriteriaCriteria 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
stringName of table
fields
FieldCollectionCollection of Fields
Returns
- bool
True if operation succeded