EF Core

Entity Framework is a modern object-relation mapper that lets you build a clean, portable, and high-level data access layer with .NET (C#) across a variety of databases, including SQL Database (on-premises and Azure), SQLite, MySQL, PostgreSQL, and Azure Cosmos DB. It supports LINQ queries, change tracking, updates, and schema migrations.

• SQLite
  A C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine
• Getting started
  Entity Framework (EF) Core overview and first examples
• DbContext
  A session with the database that can be used to query and save instances of your entities
• Modeling
  Creazione del modello dei dati
• Migrations
  Generazione e aggiornamento dello schema di un database - Migrations
• Data Types
  Tipi di dato nei database: come avviene il mapping dei tipi del C# in tipi del database sottostante
• Type Conversion
  Conversioni dai tipi .NET ai tipi del database utilizzato
• Data Seeding
  The process of populating a database with an initial set of data
• Esercizi
  Esercitazioni guidate sulla creazione di database e sull'esecuzione di query da programma C#, mediante LINQ