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.VendorAddress object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns) |
|
Delete ( TransactionManager transactionManager, System _vendorId, System _addressId ) : 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.
|
|
GetByAddressId ( TransactionManager transactionManager, System _addressId, int start, int pageLength, int &count ) : TList |
Gets rows from the datasource based on the IX_VendorAddress_AddressID index.
|
|
GetByAddressTypeId ( TransactionManager transactionManager, System _addressTypeId, int start, int pageLength, int &count ) : TList |
Gets rows from the datasource based on the FK_VendorAddress_AddressType_AddressTypeID key. FK_VendorAddress_AddressType_AddressTypeID Description: Foreign key constraint referencing AddressType.AddressTypeID.
|
|
GetByVendorId ( TransactionManager transactionManager, System _vendorId, int start, int pageLength, int &count ) : TList |
Gets rows from the datasource based on the FK_VendorAddress_Vendor_VendorID key. FK_VendorAddress_Vendor_VendorID Description: Foreign key constraint referencing Vendor.VendorID.
|
|
GetByVendorIdAddressId ( TransactionManager transactionManager, System _vendorId, System _addressId, int start, int pageLength, int &count ) : |
Gets rows from the datasource based on the PK_VendorAddress_VendorID_AddressID 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.VendorAddress object into the datasource using a transaction. After inserting into the datasource, the Nettiers.AdventureWorks.Entities.VendorAddress object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns) |
|
SqlVendorAddressProviderBase ( ) : System |
Creates a new SqlVendorAddressProviderBase instance.
|
|
SqlVendorAddressProviderBase ( string connectionString, bool useStoredProcedure, string providerInvariantName ) : System |
Creates a new SqlVendorAddressProviderBase 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.VendorAddress 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 _vendorId, System _addressId ) : bool | ||
transactionManager | TransactionManager | |
_vendorId | System | Primary key. Foreign key to Vendor.VendorID.. Primary Key. |
_addressId | System | Primary key. Foreign key to Address.AddressID.. 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 GetByAddressId ( TransactionManager transactionManager, System _addressId, int start, int pageLength, int &count ) : TList |
||
transactionManager | TransactionManager | |
_addressId | System | Primary key. Foreign key to Address.AddressID. |
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 GetByAddressTypeId ( TransactionManager transactionManager, System _addressTypeId, int start, int pageLength, int &count ) : TList |
||
transactionManager | TransactionManager | |
_addressTypeId | System | Address type. Foreign key to AddressType.AddressTypeID. |
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 GetByVendorId ( TransactionManager transactionManager, System _vendorId, int start, int pageLength, int &count ) : TList |
||
transactionManager | TransactionManager | |
_vendorId | System | Primary key. Foreign key to Vendor.VendorID. |
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 GetByVendorIdAddressId ( TransactionManager transactionManager, System _vendorId, System _addressId, int start, int pageLength, int &count ) : |
||
transactionManager | TransactionManager | |
_vendorId | System | Primary key. Foreign key to Vendor.VendorID. |
_addressId | System | Primary key. Foreign key to Address.AddressID. |
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 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.VendorAddress object to insert. |
return | bool |
public SqlVendorAddressProviderBase ( ) : System | ||
return | System |
public SqlVendorAddressProviderBase ( 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.VendorAddress object to update. |
return | bool |