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.CustomerAddress object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns) |
|
Delete ( TransactionManager transactionManager, System _customerId, 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 FK_CustomerAddress_Address_AddressID key. FK_CustomerAddress_Address_AddressID Description: Foreign key constraint referencing Address.AddressID.
|
|
GetByAddressTypeId ( TransactionManager transactionManager, System _addressTypeId, int start, int pageLength, int &count ) : TList |
Gets rows from the datasource based on the FK_CustomerAddress_AddressType_AddressTypeID key. FK_CustomerAddress_AddressType_AddressTypeID Description: Foreign key constraint referencing AddressType.AddressTypeID.
|
|
GetByCustomerId ( TransactionManager transactionManager, System _customerId, int start, int pageLength, int &count ) : TList |
Gets rows from the datasource based on the FK_CustomerAddress_Customer_CustomerID key. FK_CustomerAddress_Customer_CustomerID Description: Foreign key constraint referencing Customer.CustomerID.
|
|
GetByCustomerIdAddressId ( TransactionManager transactionManager, System _customerId, System _addressId, int start, int pageLength, int &count ) : |
Gets rows from the datasource based on the PK_CustomerAddress_CustomerID_AddressID index.
|
|
GetByRowguid ( TransactionManager transactionManager, System _rowguid, int start, int pageLength, int &count ) : |
Gets rows from the datasource based on the AK_CustomerAddress_rowguid 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.CustomerAddress object into the datasource using a transaction. After inserting into the datasource, the Nettiers.AdventureWorks.Entities.CustomerAddress object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns) |
|
SqlCustomerAddressProviderBase ( ) : System |
Creates a new SqlCustomerAddressProviderBase instance.
|
|
SqlCustomerAddressProviderBase ( string connectionString, bool useStoredProcedure, string providerInvariantName ) : System |
Creates a new SqlCustomerAddressProviderBase 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.CustomerAddress 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 _customerId, System _addressId ) : bool | ||
transactionManager | TransactionManager | |
_customerId | System | Primary key. Foreign key to Customer.CustomerID.. 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 GetByCustomerId ( TransactionManager transactionManager, System _customerId, int start, int pageLength, int &count ) : TList |
||
transactionManager | TransactionManager | |
_customerId | System | Primary key. Foreign key to Customer.CustomerID. |
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 GetByCustomerIdAddressId ( TransactionManager transactionManager, System _customerId, System _addressId, int start, int pageLength, int &count ) : |
||
transactionManager | TransactionManager | |
_customerId | System | Primary key. Foreign key to Customer.CustomerID. |
_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 GetByRowguid ( TransactionManager transactionManager, System _rowguid, int start, int pageLength, int &count ) : |
||
transactionManager | TransactionManager | |
_rowguid | System | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
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.CustomerAddress object to insert. |
return | bool |
public SqlCustomerAddressProviderBase ( ) : System | ||
return | System |
public SqlCustomerAddressProviderBase ( 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.CustomerAddress object to update. |
return | bool |