CData ADO.NET Provider for SharePoint

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();

Description

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.

Download

This .NET Framework Class Library, CData ADO.NET Provider for SharePoint, can be downloaded here.

Connection Strings

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:

SharePoint