Jason Nesbitt

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

Answers (2)