📙
Learn EF Core 9
  • Introduction of Entity Framework Core
  • EF Core - AI Tools
  • What's New in EF Core 5
    • Simple Logging
    • Filtered Included
    • Backing Fields
    • Keyless Entity Types
    • Configure Precision and Scale
    • Translation of Contains on byte arrays
    • Many-to-many Relationship
    • Table-per-type (TPT) mapping
    • Required one-to-one Dependents
    • Support for Fields using Lambda
    • Drop Column from SQLite Database
    • Index Attribute
  • BulkExtensions in EF Core
  • Connection Strings: Entity Framework Core
  • Entity Framework Core Model
  • DbContext
  • DbSet
  • Relationship in EF-Core
  • Lazy Loading in EF Core
  • Migrations in EF-Core
  • Handling Concurrency in EF-Core
  • Raw SQL Queries in EF-Core
  • Database Providers
    • SQL Server
    • SQLite
    • InMemory
    • Cosmos
    • PostgreSQL
  • Project Types
    • Console
    • MVC
    • WinForm
    • Xamarin
    • Blazor
Powered by GitBook
On this page
  • Database Providers
  • References

Database Providers

PreviousRaw SQL Queries in EF-CoreNextSQL Server

Last updated 1 year ago

Database Providers

Entity Framework Core can access many different databases through plug-in libraries called database providers.

  • Database providers can extend EF Core to enable functionality unique to specific databases.

  • Some concepts are common to most databases, and are included in the primary EF Core components.

  • Such concepts include expressing queries in LINQ, transactions, and tracking changes to objects once they are loaded from the database.

  • Some concepts are specific to a particular provider. For example, the SQL Server provider allows you to (a feature specific to SQL Server).

The following providers are supported in Entity Framework Core 5.

Name
NuGet Package

References

SQL Server
Microsoft.EntityFrameworkCore.SqlServer
SQLite
Microsoft.EntityFrameworkCore.Sqlite
InMemory
Microsoft.EntityFrameworkCore.InMemory
Cosmos
Microsoft.EntityFrameworkCore.Cosmos
PostgreSQL
Npgsql.EntityFrameworkCore.PostgreSQL
Improve EF Core performance with EF Extensions
configure memory-optimized tables
EF Core - Database Providers