Wednesday, March 11, 2015

Linq where clause for SQL Lite

I was trying to get the syntax for a SQL Lite query. Passing in the id of an record for a standard CRUD operation. 

public Report GetReport(int itemId)
{
return _connection
.Table<Report>()
.Where(x => x.Id == itemId)  
.FirstOrDefault();
}

Source
http://stackoverflow.com/questions/6359980/proper-linq-where-clauses

No comments:

Post a Comment