Getting Started
Connecting to Microsoft SharePoint
Establishing a Connection shows how to authenticate to Microsoft SharePoint and configure any necessary connection properties. You can also configure provider capabilities through the available Connection properties, from data modeling to firewall traversal. The Advanced Settings section shows how to set up more advanced configurations and troubleshoot connection errors.
Connecting from Visual Studio
The CData ADO.NET Provider for Microsoft SharePoint provides a seamless integration with Microsoft Visual Studio. The provider is registered as an ADO.NET provider with Visual Studio, allowing for integration with visual designer tools, Server Explorer, and ADO.NET data source configuration wizards.
Visual Studio Version Support
The CData ADO.NET Provider for Microsoft SharePoint supports Visual Studio versions 2012 and above.
.NET Version Support
The CData ADO.NET Provider for Microsoft SharePoint supports .NET Framework 4.0 and above as well as .NET Standard 2.0.
Microsoft SharePoint Version Support
The provider supports all versions of Microsoft SharePoint that support the SOAP API. This includes: Windows SharePoint Services 3.0, SharePoint Server 2007+ (2010, 2013, etc.), and SharePoint Online. The provider models the custom lists of your SharePoint site as bidirectional tables; when you connect, the provider retrieves the metadata for these tables by calling SharePoint Web services. Supported authentication schemes are NTLM, Basic, Digest, Forms, Kerberos, SSO, STS (security token services), and SharePoint authentication cookies.
See Also
See the following for information about creating connections, building models, and creating real-time reports:- See Using ADO.NET to create ADO.NET connection objects from code.
- See Using Entity Framework to build an EF model based on the Microsoft SharePoint connection.
- See Using SSRS to connect to Microsoft SharePoint and create real-time reports.
- See Using DbProviderFactory to connect to Microsoft SharePoint from generic ADO.NET code.