gistfile1.cs

from xy in Pois
where xy.Primarytype == "museen"
from xz in PoiDetails
where xz.PoiId == xy.Id && xz.Lang == "de"
from xw in InfoBoards
where xw.PoiDetailsId == xz.Id
select new
{
	SMGId = xy.Id,
	SMGPoiname = xy.Nodename,
	Poityp = xy.Primarytype,
	Region = (from xz in Locations where xz.MagnoliaID == xy.RegionId && xz.Type == "Region" select xz).FirstOrDefault().Name,
	Ort = (from xz in Locations where xz.MagnoliaID == xy.OrtId && xz.Type == "Ort" select xz).FirstOrDefault().Name,
	GPSEast = xy.PoiGps.Where(x => x.Type == "position" || x.Type == "ownerposition").FirstOrDefault().Gps.East,
	GPSNorth = xy.PoiGps.Where(x => x.Type == "position" || x.Type == "ownerposition").FirstOrDefault().Gps.North,
	Sprache = xz.Lang,
  	Ueberschrift = xz.BasisInfoes.FirstOrDefault().Siteheader,
	Intro = xz.BasisInfoes.FirstOrDefault().Intro,                                            
	Text = xz.BasisInfoes.FirstOrDefault().Beschreibung1,
	Name = xw.Name1,
	Cap = xw.Cap1,
	EMail = xw.Email1,                                                           
	Strasse = xw.Street1,
	Tel = xw.Tel1,
	Weburl = xw.Website1,
}