public bool Login(string username, string password) { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { spDoLoginResult result = oDC.spDoLogin(username, password).FirstOrDefault(); if (result.Id != null) { tblUser user = (from u in oDC.tblUsers where u.Id == result.Id select u).FirstOrDefault(); Id = user.Id; Username = user.Username; FirstName = user.FirstName; MiddleInitial = user.MiddleInitial; LastName = user.LastName; Zip = user.Zip; Address = user.Address; IsAddressPrivate = user.IsAddressPrivate; Email = user.EmailAddress; UserImgId = user.UserImgId; return(true); } else { return(false); } } }