This .NET Framework Class Library is provided by Bendsoft.
The main functionality of the class library is contained in the file Camelot.SharePointConnector.dll.
Add a reference to the assembly Camelot.SharePointConnector and include the Camelot.SharePointConnector.Data namespace. Instantiate a new SharePointConnection connection object. Set the connection string and open the connection.
VB.NET code sample
Imports Camelot.SharePointConnector.Data Dim myConnection As SharePointConnection = New SharePointConnection() myConnection.ConnectionString = myConnectionString myConnection.Open() ' execute queries, etc myConnection.Close()
C# code sample
using Camelot.SharePointConnector.Data; SharePointConnection myConnection = new SharePointConnection(); myConnection.ConnectionString = myConnectionString; myConnection.Open(); // execute queries, etc myConnection.Close();
The Camelot .NET Connector lets you easily develop .NET applications that require secure, high-performance data connectivity with SharePoint using standard SQL language. It implements the required ADO.NET interfaces and integrates into ADO.NET aware tools. Developers can build applications using their choice of .NET languages. Besides standard CRUD operations, the Connector supports features that you will not find in any other tool, such as JOIN and UNION. The Connector can be used by any developer with basic SQL knowledge.
More info about this class library can be found at the Bendsoft product page.
This .NET Framework Class Library, Camelot .NET Connector for Microsoft SharePoint, can be downloaded here.
The Camelot .NET Connector for Microsoft SharePoint class library can be used to connect to the following data sources by using the following connection string references: