"too many SQL variables" on delete all recursive

[Dennis Melanson]

Should this method be executed in groups of < 1000 to avoid limitations?

private static void DeleteAllIds(this SQLiteConnection conn, object[] primaryKeyValues, string entityName, string primaryKeyName)

[Guillermo Gutiérrez]

Didn't know about this limitation. All elements of the same type are deleted in a single query. It should be easy to fix.

Thanks for reporting it.

[Dennis Melanson]

According to #9 at https://www.sqlite.org/limits.html This limit would be set at 999. Thanks, Dennis

[Guillermo Gutiérrez]

I just created a test for deleting 10.000 objects in the same statement and worked as expected on iOS. Which platform is giving you this error?

[Guillermo Gutiérrez]

DeleteAllByIds will now split the list of primary keys in groups of 999 elements to avoid maximum number of variables errors in some platforms. Fixes #54

→ <<cset c6cf912657bf>>