Performing Bulk Queries using ADO.NET with the CSOLEDB Provider
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
Commerce Server includes an OLE DB provider, known as the CSOLEDB provider. The CSOLEDB provider enables you to write SQL Server-like queries to perform operations in the Profiles System.
The CSOLEDB provider is very useful for performing bulk operations because you can update one or more properties by using a single statement that is executed using ADO.NET. However, depending on the complexity of your bulk operations, you may have to execute multiple queries. For example, if you create or delete multiple profiles using the CSOLEDB provider, each profile query must execute individually.
See Also
Other Resources
SQL Queries Supported by the OLE DB Provider for Commerce Server
How to Retrieve a List of Profiles Using the CSOLEDB Provider