CData ADO.NET Provider for Office365 2015

Overview

The CData ADO.NET Provider for Office365 2015 allows developers to build .NET applications with connectivity to Office 365 using the familiar ADO.NET interfaces. The provider abstracts the underlying data source into tables, views, and stored procedures that can be used to both retrieve and update data.

The Getting Started section explains how the provider integrates with Visual Studio. It covers connecting to a live data source and interacting with data through Server Explorer.

The Using ADO.NET section shows some common programming idioms that will give you a quick preview of the ADO.NET API. The provider also supports LINQ and Entity Framework, as introduced in .NET 3.5. LINQ and Entity Framework covers creating entity models with Entity Framework and performing queries with LINQ.

The Supported SQL section shows the SQL syntax supported by the provider and points out any limitations.

An important feature of the provider is the ability to easily cache data locally. This allows the provider 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. See the section Caching Data for more details on this feature.

The Data Model details the tables, views, and stored procedures available for the provider.