TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Jason Nesbitt
NA
13
13.3k
Download data onto Windows Phone 7 from a web service (SQL Server Database)
May 27 2011 8:58 AM
Hi.
I currently have a Windows Mobile 6/6.5 app that connects to a SQL Server and downloads a dataset from a webservice - This works fine because I add the reference of the class that contains the dataset/dataTable objects to the webservice and the project, so the data can be sent from the webservice and read on the phone.
I now need to make a lite version (using less of the database) on Windows Phone 7 but as I'm sure most are aware, the dataset object doesn't exist.
I've got SQLite working fine on Windows Phone 7 but I can't find a decent way of downloading the datasets/database tables from the webservice to put into the SQLite tables.
I've tried returning insert statements as string from the webservice so the phone can insert them straight into the SQLite database but it takes too long to loop through each row in the tables on the webservice.
I've also tried doing toXML() on all of the tables and sending it to the phone as a string but this also takes an extremely long time.
I can't think of any other ways to send the data - It would be brilliant if I could connect SQLite directly to the SQL Server Database and directly run statements to extract the data from it and populate the SQLite database.
Below gives an idea of the size of the database:
Table 1: 17,000 rows
Table 2: 9,000 rows
Table 3: 4,000 rows
The rest of the tables are < 4,000 rows
Any help would be greatly appreciated.
Kind regards,
Jason
Reply
Answers (
2
)
Strating with Silverlight
Scroll Content using Silverlight