Limiting Factors of the OLE DB Provider for Commerce Server

  • Article

The following are the current key limitations of the OLE DB Provider for Commerce Server:

  • The schema objects (for example, class and data member) can be created but they cannot be deleted.
  • The schema objects (for example, class and data member) can be created but they cannot be modified. For example, renaming a schema object or changing its data type is not supported.
  • Instance selection is not supported for fastload mode. For example, syntax such as Select * from Content cannot be used to browse the data. The only way to browse the data is by using the physically persisted tables in the SQL Server database. Single instance mode does allow Select *.
  • Referential integrity is maintained by the OLE DB Provider for Commerce Server.
  • Multi-valued data members and many-to-many relationships extend the schema automatically by adding relevant tables. The addition of the new tables has no effect, but the maintenance of the associated link tables can significantly degrade performance.

It is expected that there will be an effort to eliminate these limitations to make the OLE DB Provider for Commerce Server more robust and versatile in future releases of Commerce Server.

See Also

OLE DB Provider for Commerce Server

Copyright © 2005 Microsoft Corporation.
All rights reserved.