Posted on: 4/22/2014 4:43:22 PM | Views : 424

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 ...