How to query SQLite for whether a record exists? How to query SQLite for whether a record exists? sqlite sqlite

How to query SQLite for whether a record exists?


I think what you're really looking for is something like

var queryResult = await conn.Table<PeopleRequested>()                            .Where(x => x.someField == someValue)                            .CountAsync();  

Your way is not going to work, since the last . operator is expecting a method call, not an opening parenthesis or lambda expression.