Dear all,
i have one Repository class(Repository.cs) with some methods for getting the data, methods are
1)
- public async Task
- {
- return await _db.Table
().ToListAsync(); - }
- public async Task
Get(Expression - {
- return await _db.FindAsync
(predicate); - }
- public async Task
Get( int id) - {
- return await _db.FindAsync
(id); - }
- public class Expence : EntityClass
- {
- public string Date { get; set; }
- public decimal Amount { get; set; }
- public string Purpose_Of_Spending { get; set; }
- public string Type { get; set; }
- }
i have tried like that
- public async void queryvals()
- {
- Repository
repo = new Repository (); - SQLiteAsyncConnection con = DatabaseAccess.GetConnection();
- var DateData = con.QueryAsync
("SELECT * FROM Expence WHERE Date between '" + FrmDate.Text + "' AND '" + ToDate.Text + "'"); - var DatesData2 = await repo.Get(x => (x.Date == ToDate.Text) && (x.Date == FrmDate.Text));
- }
but i'm not getting the data, how should i do that can anyone suggest me.Thank you
3 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Raja TPosted Jun 27, 2016, 7:45 AM
Arvind ChourasiyaPosted Jun 27, 2016, 9:21 AM
Vinay SinghPosted Jun 27, 2016, 8:00 AM