---
title: "How to work with Dapper and SQLite in ASP.NET Core"
url: https://daily.dev/posts/how-to-work-with-dapper-and-sqlite-in-asp-net-core-kabp3r2gj
source_url: https://www.infoworld.com/article/3715446/how-to-work-with-dapper-and-sqlite-in-asp-net-core.html
type: article
source: "InfoWorld"
published: 2024-05-10T09:03:02.472Z
updated: 2024-05-10T09:03:01.423Z
tags: ["database", ".net", "sqlite", "aspnetcore"]
reading_time: 7
upvotes: 0
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# How to work with Dapper and SQLite in ASP.NET Core

**[InfoWorld](https://daily.dev/sources/infoworld)** · 7 min read · 0 upvotes · 0 comments

## Summary

Learn how to work with Dapper and SQLite in ASP.NET Core. Use SQLite for faster data access and smaller footprint. Install Dapper and SQLite NuGet packages. Create an ASP.NET Core Web API project in Visual Studio 2022. Create a new DbContext in EF Core. Create a SQLite database and tables. Create an Author repository and interface. Register dependencies in ASP.NET Core. Create HTTP endpoints for CRUD operations.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.infoworld.com/article/3715446/how-to-work-with-dapper-and-sqlite-in-asp-net-core.html>

## Similar posts on daily.dev

- [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments
- [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments
- [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments

---

Tags: [#database](https://daily.dev/tags/database), [#.net](https://daily.dev/tags/.net), [#sqlite](https://daily.dev/tags/sqlite), [#aspnetcore](https://daily.dev/tags/aspnetcore)

[View this post on daily.dev](https://daily.dev/posts/how-to-work-with-dapper-and-sqlite-in-asp-net-core-kabp3r2gj)