Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.
LinqToSQL Range variable name can be inferred only from a simple or qualified name with no arguments
I am trying combine two columns (latitude and longitude) into a new coordinate using linqToSQL, but I get the error..
Range variable name can be inferred only from a simple or qualified name with no arguments
Here is my code..
Range variable name can be inferred only from a simple or qualified name with no arguments
Here is my code..
Using dc = New Context(ConnectionString)
Dim data = From d In dc.Routes Where routeId = routeId Select d.PlaceName, New GeoCoordinate(d.Latitude, d.Longitude)
Return data.ToList
End Using
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi;
Try it like this.
Using dc = New Context(ConnectionString)
Dim data = From d In dc.Routes Where routeId = routeId Select d.PlaceName, LatLong = New GeoCoordinate(d.Latitude, d.Longitude)
Return data.ToList
End Using
Try it like this.
Using dc = New Context(ConnectionString)
Dim data = From d In dc.Routes Where routeId = routeId Select d.PlaceName, LatLong = New GeoCoordinate(d.Latitude, d.Longitude)
Return data.ToList
End Using
That fixes the query def but breaks data.ToList as it is returning an anonymouse type.
I had hoped that LatLong As GeoCoordinate might have helped, but no :(
I had hoped that LatLong As GeoCoordinate might have helped, but no :(
Ah sorry, I missed of the start..
Private Function getDbLocations(roundId As Integer) As Dictionary(Of String, GeoCoordinate)
Let me ask the question this way. After calling the query what do you what the variable data to contain? In the original query you had two values being returned in a List(Of , .. ) object but in your last post you are saying it is a Dictionary(Of String, GeoCoordinate). What does a GeoCoordinate object contain?
Premium Content
You need an Expert Office subscription to comment.Start Free Trial