Clever Geek Handbook

Any difference between QueryAsyc and querying a table using a lambda?

I am using SQLite on a Windows 8 application that I am running and was wondering if there is any performance issue between using the following two lines of code:

conn.Table<Chemistry>().Where(ch => ch.case_id == CaseId).ToListAsync();

against

conn.QueryAsync<Chemistry>("SELECT * FROM Chemistry WHERE Case_Id = ?", CaseId);

They work and I prefer to use a lambda expression as opposed to a string query. Just wondering if there are any implications for doing this.

+3


source to share


1 answer


See here and here . The bottom line is that, assuming equivalent statements, they produce the same IL, so the performance is identical. There are a few things that are easier to express in the form of a request.



0


source






More articles:


All Articles