Silverlight for Windows phone application to connect with SQL Server 2008 RRS feed

  • Question

  • Hi, I'm a beginner developer please I need help

    I want to make a Silverlight for Windows phone application that will connect to my Database stored in my Server
    and i want my Computer to be a Server just for testing..

    I want somebody to give me some information about how to do that thing?
    How to make my computer server that every user who has that application can connect to my computer's database and retrieve some information

    By using these tools:
    Visual Studio 2010 Professional
    C# Language
    Silverlight for Windows Phone
    SQL Server 2008 Express

    or what else I will need for it??
    Monday, February 20, 2012 10:51 PM

All replies

  • The easiest way to do this is to create an OData service that uses Entity Framework to access your SQL Server database, and then consume this OData service by using the OData client library for Windows Phone (in the WP7.1 SDK).

    Here are links for quickstarts for both the service and an app:

    1. Define an OData service--in this case based on Northwind.
    2. Consume OData feeds in Windows Phone 7--this actually uses the Netflix service, but it's a more complete example that uses MVVM.
      How to: Consume an OData Service for Windows Phone--this consume Northwind, but is not really a great example of WP coding techniques

    You can also read more about OData and WP7 in my blog posts.


    Glenn Gailey

    Please visit my blog

    This posting is provided "AS IS" with no warranties, and confers no rights.

    • Proposed as answer by Marco Nuñez Sunday, January 20, 2013 6:08 PM
    Tuesday, February 21, 2012 12:12 AM