I'm trying to make login query in sqlite but can't convert AsyncTableQuery in boolean
public bool queryLogIn(string userNameLogIn,string passwordLogIn)
{
var query=database.Table<Users>().Where(i => i.UserName == userNameLogIn && i.Password == passwordLogIn);
if (query == true)//There is error
{
return true;
}
else
{
return false;
}
}
You can use FirstOrDefault function for login is success.
public bool queryLogIn(string userNameLogIn,string passwordLogIn)
{
var query=database.Table<Users>().FirstOrDefault(i => i.UserName == userNameLogIn && i.Password == passwordLogIn);
if (query == null)//There is error
{
return false;
}
else
{
return true;
}
}
Where returns an iqueryable of Users. You need Any instead which Determines whether any element of a sequence satisfies a condition and since it's return type is bool you can use it in your if statement:
var query=database.Table<Users>().Any(i => i.UserName == userNameLogIn
&& i.Password == passwordLogIn);
EDIT: Or use Any in your if:
var query=database.Table<Users>().Where(i => i.UserName == userNameLogIn
&& i.Password == passwordLogIn);
if (query.Any())
{
return true;
}
.toListAsync().Any() ?using System.Linq; to your using directives?