Development in Visual Studio
To be able to query information from your SharePoint environment in Visual Studio, simply add a reference to the Camelot .NET Connector assembly. The code is very similar to what you would write with any other ADO.NET driver, such as the Connector/NET driver for the MySQL database. Because the connector uses standard SQL syntax to execute commands, developers typically don't need much prior experience of building SharePoint applications.
Using the connector with SAP Crystal Reports
Camelot .NET Connector can be used to generate ADO.NET (XML) data sources that can be selected in SAP Crystal Reports when designing reports. In Visual Studio 2010, reports can also be created using Crystal Reports IDE provided by SAP. Reports can then be displayed in your application providing up-to-date data from your SharePoint server using the connector.
Developing SharePoint Web Parts
Camelot .NET Connector can easily be used in SharePoint development such as in web parts to simplify access to data in lists and views. By doing so, developers can focus on building powerful SharePoint tools and utilities. The example below shows a web part that connects to a list called "MyWebPart List" and prints the ID and Title columns.
Public Class MyWebPart
Protected Overrides Sub CreateChildControls()
Dim conn As New Camelot.SharePointConnector.Data.SharePointConnection("Server =localhost;Authentication=Default;")
Dim adapter As New Camelot.SharePointConnector.Data.SharePointDataAdapter("SELECT ID, Title FROM `MyWebPart List`", conn)
Dim dtMyWebPartList As New DataTable()
For Each row As DataRow In dtMyWebPartList.Rows
Me.Controls.Add(New System.Web.UI.LiteralControl(row.Item("ID").ToString & ": " & row.Item("Title").ToString & "<br />"))
Catch ex As Exception
See our free and opensource Web Parts at the Web Part section on the download page.
Build rich external applications
Camelot .NET Connector can be used to build very rich and powerful applications that really extends the boundaries of your SharePoint interface. This example shows the Camelot Query Browser implementation. This web application is a great tool for experimenting with SQL commands and to learn how to use the connector in code.