Click here to Skip to main content
15,851,902 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Can this be done in linq?
Its a very useful, needle haystack geo problem that people need!
Any leads appreciated!
Jim


VB
Structure place
    Public lat As Double
End Structure

Dim a(0), b(0) As place
    a(0).lat = 35
    b(0).lat = 35.1

    select * from a join b where abs(a.lat-b.lat)< 0.1
Posted
Updated 23-Oct-13 7:42am
v3

1 solution

You possibly could with devart extensions: http://forums.devart.com/viewtopic.php?f=30&t=27561[^]
 
Share this answer
 
Comments
cellurl 23-Oct-13 13:03pm    
I assume you mean I can solve it in mysql? I really want to do it in linq. Thanks
Zoltán Zörgő 23-Oct-13 13:12pm    
The link is about MySQL and Linq, but Linq to EF over MySQL. Check it out.
But the basic idea is that in linq to any sql the engine needs to map the function you use to a function existing in that sql implementation. So everything depends on your linq provider.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900