This .NET Framework Class Library is provided by CData.
The main functionality of the class library is contained in the file System.Data.CData.SharePoint.dll.
Add a reference to the assembly System.Data.CData.SharePoint and include the System.Data.CData.SharePoint namespace. Instantiate a new SharePointConnection connection object. Set the connection string and open the connection.
VB.NET code sample
Imports System.Data.CData.SharePoint Dim myConnection As SharePointConnection = New SharePointConnection() myConnection.ConnectionString = myConnectionString myConnection.Open() ' execute queries, etc myConnection.Close()
C# code sample
using System.Data.CData.SharePoint; SharePointConnection myConnection = new SharePointConnection(); myConnection.ConnectionString = myConnectionString; myConnection.Open(); // execute queries, etc myConnection.Close();
The CData ADO.NET Provider for SharePoint 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 SharePoint is the ability to easily cache data locally. This allows the CData ADO.NET Provider for SharePoint to be used in an offline mode when access to the data source is not possible. It also enables complex SQL queries that are otherwise not supported by the underlying data source itself.
This provider was formerly named "RSSBus ADO.NET Provider for SharePoint"
More info about this class library can be found at the CData product page.
This .NET Framework Class Library, CData ADO.NET Provider for SharePoint, can be downloaded here.
The CData ADO.NET Provider for SharePoint class library can be used to connect to the following data sources by using the following connection string references: