Hi,

For a SQLCE application i need to delete all records in a table. i'm using adapter scenario and use DeleteEntityCollection(). This works quite slow because i first have to fetch the collection and delete it.

Is there a faster possibility to accomplish this.

I also have this problem importing bulk csv data in database but i think i will start using SSCEDirect(http://www.fitiri.com/SSCEDirect.html) as it just ADO.net on CF making it too slow.

Thanks in advance.

Regards,

Jan

jspruit wrote:

Hi,

For a SQLCE application i need to delete all records in a table. i'm using adapter scenario and use DeleteEntityCollection(). This works quite slow because i first have to fetch the collection and delete it.

Is there a faster possibility to accomplish this.

I also have this problem importing bulk csv data in database but i think i will start using SSCEDirect(http://www.fitiri.com/SSCEDirect.html) as it just ADO.net on CF making it too slow.

Thanks in advance.

Regards,

Jan

Will DeleteMulti in the collection do what you want?

BOb

Try Adapter.DeleteEntitiesDirectly. Which should generate a DELETE FROM table WHERE... query.

Hi

Thanx this works much faster! Delete and load together with SSCEDirect of 350 records now only takes a second where it used to do it in more then a minute.

Regards,

Jan