entity framework 5 - EF 5 LINQ joining tables with multiple conditions in ON clause -
I am trying to get involved in the tables using two conditions in my rules, but I get an error < / P>
operator & amp; Amp; To join tables, type byte and byte
can not be applied to the operand. How can I use multiple conditions in the section?
using(above db = & amp;; New ReleaseInfo ()) {lvReleaseInfo = (db.ReleaseTranslationsR.C.R.SectionRelease.ReleaseCountryID on db.Countries to join C.CountryID & c.CultureID CultureID r.SectionRelease is equivalent to joining PF in db.Platforms & amp;; .PlatformID pf.PlatformID & amp; equals pf.PlatformID CultureID r. SectionRelease.PublisherID is equivalent to joining the pub in db.Publishers equals pub.PublisherID & amp; amp; pub.CultureID CultureID where r.ReleaseID == SectionID & amp; amp; r.CultureID == CultureID}
After
You can create an unknown type by each side of the joining:
lbReleaseInfo = (db.ReleaseTranslations in R db.Countries on new In joining C, {countryID = r.SectionRelease.ReleaseCountryID, CultureID} is equal to new {c.CountryID, C.CultureID} new {r.SectionRelease.PlatformID, CultureID} new equivalent but included in PF in db.Platforms New {pub.PublisherID, pub.CultureID} equals {pf.PlatformID, CultureID = pf.PlatformID} new {r.SectionRelease.PublisherID, r.CultureID at db.Publishers in the pub}. Where r.ReleaseID == SectionID & amp; Amp; R.CultureID == CultureID
Comments
Post a Comment