Link to home
Start Free TrialLog in
Avatar of jazzIIIlove
jazzIIIloveFlag for Sweden

asked on

How can I query to the database (entityframework, MSSQL), for iphone app?

I got an iphone app, that I am searching for the specific places from  google maps and the information of those places are coming from the database and it's merged with google maps information. Yet, the problem is I have to grab the information of those places in the given lattitude and longtitude.

How can I query to the database (entityframework, MSSQL), as draw a circle of 1 km in the given lattitude and longtitude and bring the results?

Regards.

P.S. To sum up, you can think this as google's maps service customization for my own database as I got the longtitude and lattitude.
Avatar of darbid73
darbid73
Flag of Germany image

I dont understand your question.  Can you rewrite it explaining step by step what you are trying to do, and then by highlighting exactly your problem.
Avatar of jazzIIIlove

ASKER

Hi there;

Sorry for that.

Ok, I got a iphone application that I am collecting lattitude and longtitude of specific places in the MSSQL database.

What I need is with this information, I want to pin the point in google maps.

How can i do this?

Kind regards.
The exact details including code of that is more than a question, it is a project and then some.  You have some work, googling and coding ahead of you.

1. You cannot "link" from your app to MSSQL like you do with Visual Basic projects.
2. You will have to create a WCF (Windows Communication Foundation) project on your MSSQL side, this is going to create web access to your data returning the information in XML or JSON format.
3. You app is going to need to call the WCF interface and then read the returned data (if you want you can save it in a file or Core Data)
4.  Then you can read the results into your Mapping view.
Thanks for the interest.

For the record, I am using json. Any code samples for my need?

Regards.
ASKER CERTIFIED SOLUTION
Avatar of darbid73
darbid73
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial