CreatedDate and IsDeleted columns not accessible in Contact table

[arkajzerek]

Hi,

For some reason columns IsDeleted and CreatedDate in Contact table cannot be accesses using your product, however they exists when investigating table structure using different products.

How can I access data in them?

[Shalex]

Please add the "System Objects=true;" entry to your connection string and call connection.Cache.RefreshMetadata().

[arkajzerek]

Further to the post above (thanks for the hint!) - how can I query deleted rows?

See my simple query:

select * from contact where isdeleted = true

Technically it works however no results are returned. The sandbox Recycle bin shows a deleted contact.

[Shalex]

When retrieving data, we use Salesforce Web Service API's query call which does not return records from Recycle bin. We will investigate the possibility to query Recycle bin as well.

[Shalex]

The SalesforceCommand.QueryAll property for retrieving deleted records as well is implemented (by default, false). We will post here when the corresponding build of dotConnect for Salesforce is available for download.

[Shalex]

New build of dotConnect for Salesforce 1.2.171 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/salesf ... nload.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=38&t=24675 .