Using Entity Framework Core
Creating EF 6 Models from the Designer and Code
The CData ADO.NET Provider for Excel includes an Entity Framework (EF) Core provider. The following sections show how to build an EF data model that surfaces access to Excel 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.
EF Console Application
EFCore Console Application outlines how to register the EF Core provider in a console app.
ASP.NET ApplicationEFCore ASP.NET Application outlines how to register the EF Core provider in an ASP.NET app.
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.
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.