Question

我愿利用人口学“Intersections”方法,在LINQ中撰写一份共同声明(我正在使用EF 2011年6月CTP)。问题是,如果我这样说:

var joinQuery = from spQ in spatialTableQuery
                    join mnQ in MainQuery
                    on spQ.Polygon.Intersects(mnQ.PointGeography) equals 1

I get the following error:

The name mnQ is not in scope on the left side of equals . Consider swapping the expressions on either side of equals .

联合国我已写出一个类似问题,如下:我知道它:

SELECT  * FROM   Address a 
INNER JOIN  SPATIALTABLE b
WITH(INDEX(geog_sidx))
ON b.geom.STIntersects(a.PointGeography) = 1

Answer 1

类似情况:

var joinQuery = 
   from spQ in spatialTableQuery
   from mnQ in MainQuery
   where spQ.Polygon.Intersects(mnQ.PointGeography) = 1

友情链接