Creating EF 6 Models from the Designer and Code

The CData ADO.NET Provider for Microsoft SharePoint Excel includes an Entity Framework (EF) Core provider. The following sections show how to build an EF data model that surfaces access to Excel Services tables.

Register the EF Core Provider

Before a data model can be defined, it is necessary to first register the EF Core provider in the target application. Getting Started with EFCore describes this process.

Scaffolding

The data model can be inferred automatically (scaffolded) via Package Manager Console commands. Reverse Engineering (Scaffolding) shows how to reverse engineer a data model using scaffolding. Before a data model can be defined, it is necessary to first register the EF Core provider in the target application.

Code-First

The code-first approach gives developers granular control over the data exposed in the data model. Code-First Approach shows how to manually define the entity definitions.

EF Console Application

EFCore Console Application outlines how to register the EF Core provider in a console app.

ASP.NET Application

EFCore ASP.NET Application outlines how to register the EF Core provider in an ASP.NET app.