CData ADO.NET Provider for OData
This .NET Framework Class Library is provided by CData.
The main functionality of the class library is contained in the file System.Data.CData.OData.dll.
Add a reference to the assembly System.Data.CData.OData and include the System.Data.CData.OData namespace. Instantiate a new ODataConnection connection object. Set the connection string and open the connection.
VB.NET code sample
Imports System.Data.CData.OData
Dim myConnection As ODataConnection = New ODataConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()C# code sample
using System.Data.CData.OData;
ODataConnection myConnection = new ODataConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();Description
The CData ADO.NET Provider for OData abstracts the underlying data source into tables, views, and stored procedures that can be used to both retrieve and update data.
An important feature of the CData ADO.NET Provider for OData is the ability to easily cache data locally. This allows the CData ADO.NET Provider for OData to be used in an offline mode when access to the data source is not possible. It also enables complex SQL queries which otherwise are not supported by the underlying data source itself.
This provider was formerly named "RSSBus ADO.NET Provider for OData"
More info about this class library can be found at the CData product page.
Download
This .NET Framework Class Library, CData ADO.NET Provider for OData, can be downloaded here.
Connection Strings
The CData ADO.NET Provider for OData class library can be used to connect to the following data sources by using the following connection string references: