asp.net mvc - Is my IQueryable syntax correct? -

Generated SQL does a cross job, but as the ID ID matches, it works like an internal investment, But is this a better display way to actually do this by using keywords included in C #?

Item is a page class

PageRoles is an IQueryable property in one page. What is a way where you do not include attributes to specify

class < / P>

aspnet_roles is an IQueryable property in a square class class

  var item = _repository.GetByKey (999); Var f = (FD in item FD.aspnet_roles from k in pagerails where roles are. Gatorolfoyer user (). It contains (K.RellName) & amp; amp; k.RoleId == fd.RoleId k.RoleName Select.);  

Edit:

Here is an example of an IQueryable property in my classes comes from the example pageroll class below

  Public IQueryable & lt; Aspnet_role & gt; Aspnet_roles {get {var repo = NorthCadburyWebsite.Models.aspnet_Role.GetRepo (); Return from item in repo. GetAll () where the item RELEASE == _ Choose the rolled item; }}  

Does it compile, or do you get an error?

In this case, as you mentioned, you do not have to join one. I have not used this syntax, but it seems that you use Kashmir as a referendum (like the nickname in SQL syntax)

it should get the same result (without Use of Kashmir also):

  var f = (In the item FD from pagedrails where roles are Gatorolforus user.) It includes (FD.spain_roll.release) and FD.ASPnet_Roll ROID == FD. RollID FD.Spnet_Roll, name of role). Calculation ();  

Note: Not tested, just an estimate.