public static CustomUserInfoForFP GetUserInfoForFPCustomSP(string username) { CustomUserInfoForFP result = new CustomUserInfoForFP(); using (UsersDataContext dc = new UsersDataContext()) { var dbresult = dc.aspnet_GetUserInfoForFPCustomSP(username).FirstOrDefault(); if (dbresult != null) { result.Email = dbresult.Email; result.UserId = dbresult.UserId; result.HasRecord = true; } else { result.HasRecord = false; } } return(result); }