Method | Description | |
---|---|---|
BulkInsert ( |
Lets you efficiently bulk insert many entities to the database. After inserting into the datasource, the PetShop.Business.Product object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns) |
|
Delete ( |
Deletes a row from the DataSource. Deletes based on primary key(s). |
|
Find ( |
Returns rows from the DataSource that meet the parameter conditions.
|
|
Find ( |
Returns rows meeting the whereClause condition from the DataSource. Operators must be capitalized (OR, AND). |
|
GetAll ( |
Gets All rows from the DataSource.
|
|
GetByCategoryId ( |
Gets rows from the datasource based on the IxProduct2 index.
|
|
GetByCategoryIdName ( |
Gets rows from the datasource based on the IxProduct3 index.
|
|
GetByCategoryIdProductIdName ( |
Gets rows from the datasource based on the IxProduct4 index.
|
|
GetByName ( |
Gets rows from the datasource based on the IxProduct1 index.
|
|
GetByProductId ( |
Gets rows from the datasource based on the PK__Product__B40CC6CD0AD2A005 index.
|
|
GetPaged ( |
Gets a page of rows from the DataSource.
|
|
Insert ( |
Inserts a PetShop.Business.Product object into the datasource using a transaction. After inserting into the datasource, the PetShop.Business.Product object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns) |
|
SqlProductProviderBase ( ) : System |
Creates a new SqlProductProviderBase instance.
|
|
SqlProductProviderBase ( string connectionString, bool useStoredProcedure, string providerInvariantName ) : System |
Creates a new SqlProductProviderBase instance. Uses connection string to connect to datasource.
|
|
Update ( |
Update an existing row in the datasource. After updating the datasource, the PetShop.Business.Product object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns) |
public BulkInsert ( |
||
transactionManager | The transaction manager. | |
entities | TList |
The entities. |
return | void |
public Delete ( |
||
transactionManager | ||
_productId | string | . Primary Key. |
return | bool |
public Find ( |
||
transactionManager | ||
parameters | IFilterParameterCollection | A collection of |
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 | TList |
public Find ( |
||
transactionManager | ||
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'). |
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 | TList |
public GetAll ( |
||
transactionManager | ||
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 | TList |
public GetByCategoryId ( |
||
transactionManager | ||
_categoryId | string | |
start | int | Row number at which to start reading. |
pageLength | int | Number of rows to return. |
count | int | out parameter to get total records for query. |
return | TList |
public GetByCategoryIdName ( |
||
transactionManager | ||
_categoryId | string | |
_name | string | |
start | int | Row number at which to start reading. |
pageLength | int | Number of rows to return. |
count | int | out parameter to get total records for query. |
return | TList |
public GetByCategoryIdProductIdName ( |
||
transactionManager | ||
_categoryId | string | |
_productId | string | |
_name | string | |
start | int | Row number at which to start reading. |
pageLength | int | Number of rows to return. |
count | int | out parameter to get total records for query. |
return | TList |
public GetByName ( |
||
transactionManager | ||
_name | string | |
start | int | Row number at which to start reading. |
pageLength | int | Number of rows to return. |
count | int | out parameter to get total records for query. |
return | TList |
public GetByProductId ( |
||
transactionManager | ||
_productId | string | |
start | int | Row number at which to start reading. |
pageLength | int | Number of rows to return. |
count | int | out parameter to get total records for query. |
return |
public GetPaged ( |
||
transactionManager | ||
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 | Number of rows in the DataSource. |
return | TList |
public Insert ( |
||
transactionManager | ||
entity | PetShop | PetShop.Business.Product object to insert. |
return | bool |
public SqlProductProviderBase ( string connectionString, bool useStoredProcedure, string providerInvariantName ) : System | ||
connectionString | string | The connection string to the database. |
useStoredProcedure | bool | A boolean value that indicates if we should use stored procedures or embedded queries. |
providerInvariantName | string | Name of the invariant provider use by the DbProviderFactory. |
return | System |
public Update ( |
||
transactionManager | ||
entity | PetShop | PetShop.Business.Product object to update. |
return | bool |