If the download doesn't start automatically, please click here to access the download URL directly.

Installation Steps

  1. Unzip the downloaded package to a local folder.
  2. Download and install IIS Express 8.0 or 7.5:
    https://www.microsoft.com/en-us/download/details.aspx?id=34679
    https://www.microsoft.com/en-us/download/details.aspx?id=1038

First Steps

  1. Run start-under-iis-express.cmd in the odatadb folder.

  1. Open the following URL in a browser
    http://localhost:40440/odatadb.svc/v4/NorthwindCE/default/$metadata
    You will see a metadata document.

  1. Open the following URL in a browser
    http://localhost:40440/odatadb.svc/v4/NorthwindCE/default/Customers
    You will see generated JSON for customer entities.

  1. Open the following URL in a browser
    http://localhost:40440/examples/table.htm?url=http%3A%2F%2Flocalhost%3A40440%2Fodatadb.svc%2Fv4%2FNorthwindCE%2Fdefault%2FCustomers
    You will see the customer table in a test web client.

  1. If you have the SaveToDB add-in installed, open Data Connection Wizard, select Web Data Provider, and paste the following URL into the URL field
    http://localhost:40440/odatadb.svc/v4/NorthwindCE/default/Customers

  1. The SaveToDB wizard suggests to select an entity. Select Customers.

  1. Insert a query to cell B2.
    You will see the customer table. Moreover, you may edit and save data!

  1. Furthermore, try to change queries using the Query List

Next Steps

This example works with the local SQL Server Compact Northwind database.

This is ODataDB configuration for this database:

That's all!

ODataDB reads the database metadata and does the rest!

Just add a connection string to your database to the Web.config config file and connect.

Use URLs like this:

http://localhost:40440/odatadb.svc/v4/NorthwindCE/default/$metadata

Just change NorthwindCE to your connection string name.

You may install ODataDB under IIS. Read this article.

ODataDB is free for up to five users. You may purchase licences for the required number of users.

Feel free to contact us at or .

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.