ADO.NET Provider for Lohaco

Build 21.0.7930


Retrieve information related to item images.


The {i will use the Lohaco API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the {i. For example, the following query is processed server side:

SELECT * FROM ItemImages

SELECT * FROM ItemImages WHERE ItemCd='itemcd'
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.


To add an Item in an exsisting group ItemImages,ItemAttribute child tables are necessary. The insert is achived by using temp tables.

INSERT INTO ItemImages (itemcd,filename) values ('itemcd','img.jpg')


Lohaco allows updates.

UPDATE ItemImages SET FileName='newName' WHERE  ItemCd = '1231231123' 


ItemAttributes can be deleted by providing the ItemCd .

DELETE FROM ItemImages WHERE ItemCd='1231231123'


Name Type ReadOnly References Description
SellerId String False

The Id of the seller.

ItemCd [KEY] String False


The item code.

Path String True

Path of the file.

FileName String False

Name of the file.

SupplementHeight String True

Image Supplement (height).

SupplementThreeSizeB String True

Image supplement (three sizes B).

SupplementThreeSizeW String True

Image supplement (three sizes W).

SupplementThreeSizeH String True

Image supplement (three sizes H).

SupplementWearSize String True

Image supplement (wear size).

SupplementWeight String True

Image supplement (body weight).

SupplementOther String True

Image Supplement (Other).

FileNameNotExtension String True

File name (without the

Extension String True

Only the extension of the file name (without the '.').

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930