C# Class Nettiers.AdventureWorks.Data.SqlClient.SqlVSalesPersonProviderBase

This class is the base repository for the CRUD operations on the VSalesPerson objects.
Inheritance: VSalesPersonProviderBase
Exibir arquivo Open project: netTiers/netTiers

Public Methods

Method Description
Find ( TransactionManager transactionManager, IFilterParameterCollection parameters, string orderBy, int start, int pageLength, int &count ) : VList

Returns rows from the DataSource that meet the parameter conditions.

Get ( TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength, int &count ) : VList

Gets a page of rows from the DataSource.

GetAll ( TransactionManager transactionManager, int start, int pageLength, int &count ) : VList

Gets All rows from the DataSource.

SqlVSalesPersonProviderBase ( string connectionString, bool useStoredProcedure, string providerInvariantName ) : System

Creates a new SqlVSalesPersonProviderBase instance. Uses connection string to connect to datasource.

Protected Methods

Method Description
SqlVSalesPersonProviderBase ( ) : System

Creates a new SqlVSalesPersonProviderBase instance. Uses connection string to connect to datasource.

Method Details

Find() public method

Returns rows from the DataSource that meet the parameter conditions.
public Find ( TransactionManager transactionManager, IFilterParameterCollection parameters, string orderBy, int start, int pageLength, int &count ) : VList
transactionManager TransactionManager object
parameters IFilterParameterCollection A collection of objects.
orderBy string Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);
start int Row number at which to start reading.
pageLength int Number of rows to return.
count int out. The number of rows that match this query.
return VList

Get() public method

Gets a page of rows from the DataSource.
public Get ( TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength, int &count ) : VList
transactionManager TransactionManager object
whereClause string Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').
orderBy string Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);
start int Row number at which to start reading.
pageLength int Number of rows to return.
count int The total number of rows in the data source.
return VList

GetAll() public method

Gets All rows from the DataSource.
public GetAll ( TransactionManager transactionManager, int start, int pageLength, int &count ) : VList
transactionManager TransactionManager object.
start int Row number at which to start reading.
pageLength int Number of rows to return.
count int The total number of rows in the data source.
return VList

SqlVSalesPersonProviderBase() protected method

Creates a new SqlVSalesPersonProviderBase instance. Uses connection string to connect to datasource.
protected SqlVSalesPersonProviderBase ( ) : System
return System

SqlVSalesPersonProviderBase() public method

Creates a new SqlVSalesPersonProviderBase instance. Uses connection string to connect to datasource.
public SqlVSalesPersonProviderBase ( string connectionString, bool useStoredProcedure, string providerInvariantName ) : System
connectionString string The connection string to the database.
useStoredProcedure bool A boolean value that indicates if we use stored procedures or embedded queries.
providerInvariantName string Name of the invariant provider use by the DbProviderFactory.
return System