Could this be combined to one LINQ statement? private string GetUserNameByID( string id) { Guid guid = new Guid (id); UICDataContext db = new UICDataContext (); IEnumerable aspnet_Application > query = from app in db.aspnet_Applications where app.ApplicationName == Request.ApplicationPath select app; aspnet_Application temp = query.First aspnet_Application >(); IEnumerable aspnet_User > query2 = from users in db.aspnet_Users where users.UserId == guid && users.ApplicationId == temp.ApplicationId
Read More...