How do I use C# and .NET with SQLite?

Jiachen Jiang (PM, Data Access) will walk us through how to work with SQLite using C# and .NET and decide which approach works best for your scenario. They explain the differences between the solutions and demo how to connect to and query a database for each one.

ADO.NET – https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/?tabs=netcore-cli Entity Framework – https://learn.microsoft.com/en-us/ef/core/get-started/overview/first-app?tabs=netcore-cli

Blog: https://aka.ms/dotnet/blog
Twitter: https://aka.ms/dotnet/twitter
TikTok: https://aka.ms/dotnet/tiktok
Mastodon: https://aka.ms/dotnet/mastodon
LinkedIn: https://aka.ms/dotnet/linkedin
Facebook: https://aka.ms/dotnet/facebook
Docs: https://learn.microsoft.com/dotnet
Forums: https://aka.ms/dotnet/forums
🙋‍♀️Q&A: https://aka.ms/dotnet-qa
👨‍🎓Microsoft Learn: https://aka.ms/learndotnet

00:05 Welcome
00:18 Today’s Topics
00:42 SQLite 101
1:03 Four different use scenarios for SQLite databases using C#
02:07 Demo Entity Framework Core
03:06 Demo SQLite -.NET
03:54 Demo Dapper
04:51 Demo ADO.NET
05:38 Summary
06:32 Connect and Contribute

#dotnet #efcore #sqlite