How the below code works

Ramco Ramco

How the below code works and what it will return

LMSDBDataContext context = new LMSDBDataContext();
var Result = (from t in context.UserLogins
              where t.LoginCode == Convert.ToInt32(AuthenticatedUser().Item3)
              select t).SingleOrDefault();
if (Result != null)
{

    var Result2 = (from t in context.View_UserLogins
                   where t.LoginCode == Result.LoginCode
                   select t).SingleOrDefault();
    return Tuple.Create(Result.LoginID, Result.UserRole, Result2.Name, Result.LoginCode.ToString(), Convert.ToBoolean(Result2.Active));
}
else
{
    return Tuple.Create("0", "User", "", "0", false);
}

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty2y ago
Accepted answer
The code first searches in the UserLogins table and then searches in View_UserLogins if a match is found.
The return value is a tuple that holds various user details if a user is found, or default values otherwise.

When a user is found it will returns a tuple containing LoginID, UserRole, Name, LoginCode, and Active status.
When no user is found it will returns a tuple with default values: ("0", "User", "", "0", false).
+1