SQLite | Know Your Toolset

Integration Testing for ASP.NET APIs (2/3) - Data

Jan 23, 2024 · 11 min read · C# API ASP.NET Testing XUnit Bogus TestContainers FluentValidation SQLite Postgres ·
Share on:

Where's the code? Fully working examples for this code are in the 02-api-with-sqlite and 03-api-with-postgres folder of the GitHub repo with the examples for this series of posts: 02-api-with-sqlite 03-api-with-postgres In the previous post we got started with some basic integration tests. In this one we'll use a …

Read More
Using Tuples with Dapper

Apr 16, 2023 · 3 min read · C# ASP.NET Dapper SQLite ·
Share on:

Summary Using tuples with Dapper for simple query results can avoid the need to create classes or records that might otherwise bloat your code-base. Here's a sample repo: https://github.com/dahlsailrunner/tuple-with-dapper Background When you have an existing database or management practices that don't involve Entity …

Read More