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

This class is the base repository for the CRUD operations on the VProductAndDescription objects.

Inheritance: VProductAndDescriptionProviderBase

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.
SqlVProductAndDescriptionProviderBase ( string connectionString, bool useStoredProcedure, string providerInvariantName ) : System	Creates a new SqlVProductAndDescriptionProviderBase instance. Uses connection string to connect to datasource.

Method	Description
SqlVProductAndDescriptionProviderBase ( ) : System	Creates a new SqlVProductAndDescriptionProviderBase instance. Uses connection string to connect to datasource.

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

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

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

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

protected SqlVProductAndDescriptionProviderBase ( ) : System
return	System

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

public SqlVProductAndDescriptionProviderBase ( 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