Concept

Concept

ODataDB allows getting and updating database table data via OData:

ODataDB is a regular ASP.NET application hosted under Internet Information Server (IIS).

ODataDB reads database metadata under user credentials and publishes user specific service and metadata documents.

Users may select and update data. ODataDB translates client queries to database CRUD operations.

To make a database available through OData, just add a connection string to the web.config file.

For example, the web.config file contains the following connection strings named as AzureDemo50 and NorthwindCE:

<connectionStrings>
  <add name="AzureDemo50" connectionString="Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;Initial Catalog=AzureDemo50;Integrated Security=SSPI"
    providerName="System.Data.OleDb" />
  <add name="NorthwindCE" connectionString="Data Source=C:\ODataDB\DB\Northwind.sdf"
    providerName="System.Data.SqlServerCe.4.0" />
</connectionStrings>

Also, for example, the ODataDB application is configured with the service URL http://localhost:40440/odatadb.svc/.

In this case, ODataDB creates two groups of OData services via URLs:

  • http://localhost:40440/odatadb.svc/v4/AzureDemo50/default/
  • http://localhost:40440/odatadb.svc/v3/AzureDemo50/default/
  • http://localhost:40440/odatadb.svc/v2/AzureDemo50/default/
  • http://localhost:40440/odatadb.svc/v1/AzureDemo50/default/
  • http://localhost:40440/odatadb.svc/v4/NorthwindCE/default/
  • http://localhost:40440/odatadb.svc/v3/NorthwindCE/default/
  • http://localhost:40440/odatadb.svc/v2/NorthwindCE/default/
  • http://localhost:40440/odatadb.svc/v1/NorthwindCE/default/

For example, you may use the following URL to get the service metadata:

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

and the following URL to get customers:

  • http://localhost:40440/odatadb.svc/v4/NorthwindCE/default/Customers

See the latest specifications of OData protocols at

https://docs.oasis-open.org/odata/odata/v4.0/odata-v4.0-part1-protocol.html

https://msdn.microsoft.com/en-us/library/dd541188.aspx

Service URLs

The formal service URL format is:

<service root>/<version>/<connection string name>/<service name>/ 

where <version> is v1, v2, v3, or v4, and <service name> must be "default" for the current ODataDB implementation. 

Connecting to Databases

ODataDB should connect to databases under user credentials. This ensures that users may get and update only permitted data.

If a database supports integrated security, you may configure a connection string with integrated security and turn on Windows authentication for the ODataDB application in IIS.

In this case, ODataDB impersonates connected users and connects to a database using the integrated security.

If the basic authentication is configured, ODataDB changes the connection string to the provided username and password, and connects under the user login instead of integrated security.

 

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.