How deeply does ASP.NET Core in Action, 3e cover Microsoft.EntityFrameworkCore.SQLite?

Explains provider installation and in-memory configuration steps, but stops short of detailed SQLite-specific SQL behavior.

Microsoft.EntityFrameworkCore.SQLite

As explained in ASP.NET Core in Action, 3e

Microsoft.EntityFrameworkCore.SQLite is the NuGet package that supplies SQLite database-provider integration for Entity Framework Core.

Microsoft.EntityFrameworkCore.SQLite is the Entity Framework Core database-provider package for SQLite. It lets an application use EF Core’s common ORM API while the provider generates SQLite-specific implementation code and SQL. Add it as a NuGet PackageReference and restore the project before configuring the application’s DbContext. section 12.2.1

A typical EF Core SQLite setup includes:

Microsoft.EntityFrameworkCore.SQLite for runtime database-provider support; it also references the main EF Core package. section 12.2.1
Microsoft.EntityFrameworkCore.Design for shared build-time components used to build the application’s EF Core data model. section 12.2.1
PackageReference elements in the project file, followed by dotnet restore or automatic IDE restoration. section 12.2.1

Using SQLite as an isolated in-memory database

Tests can create a SqliteConnection with DataSource=:memory:, open it, pass it to DbContextOptionsBuilder<AppDbContext>().UseSqlite(connection), construct the DbContext, and call EnsureCreated(). The database remains available while the connection stays open, allowing multiple DbContext instances to share the same temporary database. This provides fast, isolated tests for services that depend on EF Core’s DbContext without requiring a real database. section 36.4 section 36.5

Listing 12.1 Installing EF Core in an ASP.NET Core application

<Project Sdk="Microsoft.NET.Sdk.Web">
 
  <PropertyGroup>
    <TargetFramework>net7.0</TargetFramework>                   #1
    <Nullable>enable</Nullable>
    <ImplicitUsings>enable</ImplicitUsings>
  </PropertyGroup>
 
  <ItemGroup>
    <PackageReference                                           #2
      Include="Microsoft.EntityFrameworkCore.SQLite"            #2
      Version="7.0.0" />                                        #2
    <PackageReference                                           #3
      Include="Microsoft.EntityFrameworkCore.Design"            #3
      Version="7.0.0" >                                         #3
        <IncludeAssets>runtime; build; native; contentfiles;    #4
          Analyzers; buildtransitive</IncludeAssets>            #4
        <PrivateAssets>all</PrivateAssets>                      #4
    </PackageReference>
  </ItemGroup>

See the project-file recipe with Microsoft.EntityFrameworkCore.SQLite and Microsoft.EntityFrameworkCore.Design PackageReference entries, including the .NET 7 target and version 7.0.0 packages. section 12.2.1

How ASP.NET Core in Action, 3e covers it

liveBook manning.com

Read ASP.NET Core in Action, 3e on liveBook Get the book at manning.com

Related concepts

in-memory databaseuses · An in-memory database is a database whose primary working data resides in main memory rather than primarily in persistent storage.
Entity Framework Coreuses · Entity Framework Core is a cross-platform object-relational mapping framework for .NET that enables applications to query and persist data through .NET objects and APIs.
SQLite-netalternative to · SQLite-net is a .NET library that provides SQLite database access and object-relational mapping for application types.
EF Core in-memory provideralternative to · The EF Core in-memory provider is an Entity Framework Core provider that stores data in application memory instead of a persistent database.
UseSqlite()used by · UseSqlite() is an Entity Framework Core configuration method that selects SQLite as the database provider for a context.
SqliteConnectionconfigured by · SqliteConnection is the Microsoft.Data.Sqlite connection type used to connect an application to a SQLite database.

This explainer was generated by Manning's knowledge graph from the text of ASP.NET Core in Action, 3e. The section links point to the parts of the book it draws on.