Insert returns int type, but ROWID is always signed 64-bit integer in sqlite.

[Bart Z]

Let me understand, please.

Insert returns int type, but ROWID is always signed 64-bit integer in sqlite ( https://www.sqlite.org/rowidtable.html )

Does it mean SQLite-Net Extensions can’t operate fully on rowid ?

Can't insert more than 2 to 32 records in a table?

‌

[Guillermo Gutiérrez]

While your statement is true, this limitation is inherited from SQLite-Net and there’s nothing we can do about it. As you can see in their source code the Insert method returns an integer. SQLite-Net Extensions extends SQLite-Net adding some convenience methods for handling relationships, so we’re limited to the datatypes returned by SQLite-Net itself.

[Bart Z]

Thank you very much for your answer. I asked timidly, fearing that I might have missed something obvious. So this is quite a bug in SQLite-Net. I've always thought that type compatibility is essential in programming.