score:2

Accepted answer
private static void getuserdata(string username, usersession usersession)
{
    using (entities ctx = commonsert.getcontext())
    {
        var result = (from ur in ctx.datuserroles
                      where ur.accountname.equals(username, stringcomparison.currentcultureignorecase)
                      select new
                      {
                          useractive = ur.active,
                          userrob = ur.rob,
                          userid = ur.id
                      }).firstordefault();


    }

    if (result != null) {
        usersession.useractive = result.useractive;
        usersession.userrob  = result.userrob;
        usersession.userid = result.userid;
    }

}

score:2

private static void getuserdata(string username, usersession user)
    {
        using (entities ctx = commonsert.getcontext())
        {
            var result = (from ur in ctx.datuserroles
                          where ur.accountname.equals(username, stringcomparison.currentcultureignorecase)
                          select new
                          {
                              active = ur.active,
                              id = ur.id,
                              //...select all properties from the db
                          }).firstordefault();

            if (result != null)
                user.useractive = result.active;
                user.userid = result.id;
                //..set all properties of "user" object
        }
    }

Related Query