Tekafe

Query: var itemlist = db.Items.Where(x =>  x.UserId == Id && DbFunctions.TruncateTime(x.LoanDueDate.Value) < DbFunctions.TruncateTime(DateTime.Now)).AsEnumerable().Select((r, i) => new { i=i+1, r }).ToList(); Try using this query, It'll help :)

If you encounter an error like 'App not installed' on Android Phone. It may happen when you uninstall the program and try to reinstall the .apk file. Here is what I tried to solve this problem