darking050
darking050

Reputation: 637

Windows phone mango with SQL Server

I have a WP7 app idea that requires a connection to a server database (running SQL Server 2008 R2). I checked online and accordingly it is usually done by using WCF that expose the database for the phone to be used.

I would like to know if the new mango update provide anything new to the process I already mentioned. I am aware of the local database, but in my case I need the SQL Server database for the bigger size.

Thanks,

Upvotes: 1

Views: 265

Answers (2)

Dave Bost - MSFT
Dave Bost - MSFT

Reputation: 517

The easiest way is to use oData to expose your database on the wire. The oData client library is built into the Mango APIs under System.Data.Services.Client.

However, be aware of the requirements of your application and architect approrpriately. There may be a need to provide some sort of caching plan as network connectivity is never guaranteed on a mobile device.

Upvotes: 1

Matt Lacey
Matt Lacey

Reputation: 65586

(Even in mango) there is no way to directly connect to a SQL Server database.

Upvotes: 1

Related Questions