How to make raw query to a Sqlite DB in Xamarin XAML

Question

I need make raw queries to an sqlite db in Xamarin for Android and iOS. I can't use object oriented queries (conn.Insert<Object>, conn.CreateTable<Object>, conn.Table<Object>, etc).

Which library is the best to make full raw queries? Thanks!

Answer 1

conn.Execute("Your query");

Make sure you read their documentation as SQLite doesn't support all SQL queries.

https://www.sqlite.org/lang.html