ADO.NET Provider for BigCommerce

Build 23.0.8770

PriceLists

Returns a collection of price records.

Table Specific Information

Select

The 本製品 uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=' comparison.
  • DateCreated supports the '=' comparison.
  • DateModified supports the '=' comparison.
  • Name supports the '=,LIKE' comparison.

The rest of the filter is executed client-side within the 本製品.

For example, the following queries are processed server-side:

SELECT * FROM PriceLists WHERE Id = 1 

SELECT * FROM PriceLists WHERE DateCreated = '2021-05-26'

SELECT * FROM PriceLists WHERE DateModified = '2021-05-26'

SELECT * FROM PriceLists WHERE Name LIKE 'Wholesale group1'

Insert

To insert a new PriceList, you need to specify the following columns: Name and Active

INSERT INTO PriceLists (Name, Active) VALUES ('Wholesalegroup', false)

Update

To Update the PriceList, you need to specify the following columns: Name and ID

UPDATE PriceLists SET Name = 'Wholesalegroup' WHERE Id = '4'

Delete

To Delete the PriceList, you need to specify the following columns:ID

DELETE From PriceLists WHERE Id = '4'

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

ID of the PriceList.

Active Boolean False

The status of the PriceList.

DateCreated Datetime True

The date of creation for the PriceList.

DateModified Datetime True

The last modification date of the PriceList.

Name String False

The name of the PriceList.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8770