Hi,
I have two queries in my respository class and each of them call different group of users. I would like to call the two queries in my authentication method below, but I am little unsure, how would I go about doing this so? I currently have one query calling
authentication method below but I would like to know, how can I call both of the queries. Would I need to group my queries together, if so, how?
Repository class:
public Cust trial_test(string username, string password)
{
var query = from s in db.Subscriptions
join u in db.UserDetails on s.sUID equals u.uID
where s.ExpiryDate >= DateTime.Now &&
s.sPID.Value == 163 &&
s.All.Value != true &&
u.uUsername == username &&
u.uPassword == pass ...
Go to the complete details ...