Method | Description | |
---|---|---|
BulkInsert ( TransactionManager transactionManager, TList |
Lets you efficiently bulk insert many entities to the database. After inserting into the datasource, the Nettiers.AdventureWorks.Entities.BillOfMaterials object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns) |
|
Delete ( TransactionManager transactionManager, System _billOfMaterialsId ) : bool |
Deletes a row from the DataSource. Deletes based on primary key(s). |
|
Find ( TransactionManager transactionManager, IFilterParameterCollection parameters, string orderBy, int start, int pageLength, int &count ) : TList |
Returns rows from the DataSource that meet the parameter conditions.
|
|
Find ( TransactionManager transactionManager, string whereClause, int start, int pageLength, int &count ) : TList |
Returns rows meeting the whereClause condition from the DataSource. Operators must be capitalized (OR, AND). |
|
GetAll ( TransactionManager transactionManager, int start, int pageLength, int &count ) : TList |
Gets All rows from the DataSource.
|
|
GetByBillOfMaterialsId ( TransactionManager transactionManager, System _billOfMaterialsId, int start, int pageLength, int &count ) : |
Gets rows from the datasource based on the PK_BillOfMaterials_BillOfMaterialsID index.
|
|
GetByComponentId ( TransactionManager transactionManager, System _componentId, int start, int pageLength, int &count ) : TList |
Gets rows from the datasource based on the FK_BillOfMaterials_Product_ComponentID key. FK_BillOfMaterials_Product_ComponentID Description: Foreign key constraint referencing Product.ComponentID.
|
|
GetByProductAssemblyId ( TransactionManager transactionManager, System _productAssemblyId, int start, int pageLength, int &count ) : TList |
Gets rows from the datasource based on the FK_BillOfMaterials_Product_ProductAssemblyID key. FK_BillOfMaterials_Product_ProductAssemblyID Description: Foreign key constraint referencing Product.ProductAssemblyID.
|
|
GetByProductAssemblyIdComponentIdStartDate ( TransactionManager transactionManager, System _productAssemblyId, System _componentId, System _startDate, int start, int pageLength, int &count ) : |
Gets rows from the datasource based on the AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate index.
|
|
GetByUnitMeasureCode ( TransactionManager transactionManager, System _unitMeasureCode, int start, int pageLength, int &count ) : TList |
Gets rows from the datasource based on the IX_BillOfMaterials_UnitMeasureCode index.
|
|
GetPaged ( TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength, int &count ) : TList |
Gets a page of rows from the DataSource.
|
|
Insert ( TransactionManager transactionManager, Nettiers entity ) : bool |
Inserts a Nettiers.AdventureWorks.Entities.BillOfMaterials object into the datasource using a transaction. After inserting into the datasource, the Nettiers.AdventureWorks.Entities.BillOfMaterials object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns) |
|
SqlBillOfMaterialsProviderBase ( ) : System |
Creates a new SqlBillOfMaterialsProviderBase instance.
|
|
SqlBillOfMaterialsProviderBase ( string connectionString, bool useStoredProcedure, string providerInvariantName ) : System |
Creates a new SqlBillOfMaterialsProviderBase instance. Uses connection string to connect to datasource.
|
|
Update ( TransactionManager transactionManager, Nettiers entity ) : bool |
Update an existing row in the datasource. After updating the datasource, the Nettiers.AdventureWorks.Entities.BillOfMaterials object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns) |
public BulkInsert ( TransactionManager transactionManager, TList |
||
transactionManager | TransactionManager | The transaction manager. |
entities | TList |
The entities. |
return | void |
public Delete ( TransactionManager transactionManager, System _billOfMaterialsId ) : bool | ||
transactionManager | TransactionManager | |
_billOfMaterialsId | System | Primary key for BillOfMaterials records.. Primary Key. |
return | bool |
public Find ( TransactionManager transactionManager, IFilterParameterCollection parameters, string orderBy, int start, int pageLength, int &count ) : TList |
||
transactionManager | 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 transactionManager, string whereClause, int start, int pageLength, int &count ) : TList |
||
transactionManager | 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 transactionManager, int start, int pageLength, int &count ) : TList |
||
transactionManager | 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 GetByBillOfMaterialsId ( TransactionManager transactionManager, System _billOfMaterialsId, int start, int pageLength, int &count ) : |
||
transactionManager | TransactionManager | |
_billOfMaterialsId | System | Primary key for BillOfMaterials records. |
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 GetByComponentId ( TransactionManager transactionManager, System _componentId, int start, int pageLength, int &count ) : TList |
||
transactionManager | TransactionManager | |
_componentId | System | Component identification number. Foreign key to Product.ProductID. |
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 GetByProductAssemblyId ( TransactionManager transactionManager, System _productAssemblyId, int start, int pageLength, int &count ) : TList |
||
transactionManager | TransactionManager | |
_productAssemblyId | System | Parent product identification number. Foreign key to Product.ProductID. |
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 GetByProductAssemblyIdComponentIdStartDate ( TransactionManager transactionManager, System _productAssemblyId, System _componentId, System _startDate, int start, int pageLength, int &count ) : |
||
transactionManager | TransactionManager | |
_productAssemblyId | System | Parent product identification number. Foreign key to Product.ProductID. |
_componentId | System | Component identification number. Foreign key to Product.ProductID. |
_startDate | System | Date the component started being used in the assembly item. |
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 GetByUnitMeasureCode ( TransactionManager transactionManager, System _unitMeasureCode, int start, int pageLength, int &count ) : TList |
||
transactionManager | TransactionManager | |
_unitMeasureCode | System | Standard code identifying the unit of measure for the quantity. |
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 GetPaged ( TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength, int &count ) : TList |
||
transactionManager | 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 transactionManager, Nettiers entity ) : bool | ||
transactionManager | TransactionManager | |
entity | Nettiers | Nettiers.AdventureWorks.Entities.BillOfMaterials object to insert. |
return | bool |
public SqlBillOfMaterialsProviderBase ( ) : System | ||
return | System |
public SqlBillOfMaterialsProviderBase ( 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 transactionManager, Nettiers entity ) : bool | ||
transactionManager | TransactionManager | |
entity | Nettiers | Nettiers.AdventureWorks.Entities.BillOfMaterials object to update. |
return | bool |