Using Entity Framework Core
Creating EF 6 Models from the Designer and Code
The CData ADO.NET Provider for Google Sheets includes an Entity Framework (EF) Core provider. The following sections show how to build an EF data model that surfaces access to Google Sheets 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.