c# - login using ADO.NET Entity Data Model -

net entity data model data form users table has foreign key usertypeid table usertypes

the code works fine want code data form tow tables tow tables have foreign key called usertypeid

ex table1(foreign key usertypeid) table2((foreign key usertypeid))

    var result = _datamoel.users.firstordefault(i => i.username.equals(txtuser.text) && i.password.equals(txtpass.text));      if (result != null )     {          result.usertypereference.load();         session["username"] = txtuser.text;         if (result.usertype.typename.equals("admin"))             response.redirect("admin/adminhomepage.aspx");         else if (result.usertype.typename.equals("clerk"))             response.redirect("clerk/clerkpage.aspx");       }      else          lblmsgw.text = "username/passsword not correct! please change username/passsword , try again";