--- title: How to work with Dapper and SQLite in ASP.NET Core description: 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.... canonical: https://daily.dev/posts/how-to-work-with-dapper-and-sqlite-in-asp-net-core-kabp3r2gj twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: How to work with Dapper and SQLite in ASP.NET Core | daily.dev og:description: 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.... og:url: https://daily.dev/posts/how-to-work-with-dapper-and-sqlite-in-asp-net-core-kabp3r2gj og:image: https://api.daily.dev/og/posts/KaBp3R2gj.png og:image:alt: How to work with Dapper and SQLite in ASP.NET Core og:image:width: 1200 og:image:height: 630 og:locale: 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: --- 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) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"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","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/how-to-work-with-dapper-and-sqlite-in-asp-net-core-kabp3r2gj"},"datePublished":"2024-05-10T09:03:02.472Z","dateModified":"2024-05-10T09:03:01.423Z","description":"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....","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/b86ac00da04e9d578066fb18494c6f03?_a=AQAEuiZ","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/b86ac00da04e9d578066fb18494c6f03?_a=AQAEuiZ","isAccessibleForFree":true,"articleSection":"InfoWorld","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"InfoWorld","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/bf6d68a999064029b0bb09aa6268f1f3","url":"https://daily.dev/sources/infoworld"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/how-to-work-with-dapper-and-sqlite-in-asp-net-core-kabp3r2gj","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,.net,sqlite,aspnetcore","timeRequired":"PT7M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"InfoWorld","item":"https://daily.dev/sources/infoworld"},{"@type":"ListItem","position":3,"name":"How to work with Dapper and SQLite in ASP.NET Core"}]} ```