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 - learn.microsof... Entity Framework - learn.microsof...
Sample Repo: aka.ms/SampleRepo
Blog: aka.ms/dotnet/...
Twitter: aka.ms/dotnet/...
TikTok: aka.ms/dotnet/...
Mastodon: aka.ms/dotnet/...
LinkedIn: aka.ms/dotnet/...
Facebook: aka.ms/dotnet/...
Docs: learn.microsof...
Forums: aka.ms/dotnet/...
🙋‍♀️Q&A: aka.ms/dotnet-qa
👨‍🎓Microsoft Learn: aka.ms/learndo...
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

[@KennethTrelfa]

Thank you for presenting multiple abstractions. This information is critical and often is overlooked.

[@simont6439]

Excellent, concise and shows clearly the main differences of four common access methods.

[@fuzzy-02]

To provide feedback, as a beginner with theoretical but no practical knowledge, this was hard to follow. Especially since the lady talks while her cursor is always elsewhere instead of pointing to what she is talking about. Most of the time I was rewinding just to read and understand the code and try to figure out where is what she's talking about.

[@jalilseguel7]

Thnaks, 降价陈. This is a really helpful and compact video for begginers (and not so) students like me.

[@kanhuang1321]

赞翻译名字

[@KvapuJanjalia]

Why would I choose Microsoft.Data.Sqlite over System.Data.SQLite?

[@AdamsTaiwan]

I think it is so you can also run your code on Linux, Raspberry PI, etc.

[@user-th6sk1ks2g]

Wow that cleared a lot up for me. Thank you!

[@ToddlersPreGra]

What about using mysql and entity framewor?, there are not enough resources regarding this.
Thank you

[@LoveAndFun-y5c]

Hi,I'm tryna use c# winform with sqlite database file.without encryption it works perfectly but when encrypted Nothing works.Could you help me.using system.data.sqlite packages.

[@AdamsTaiwan]

I still prefer to use Generic DataSet and works with Oracle, MSSQL, SQLite and Xml Diffgram.
Just set data adaptor: SELECT anything.... then
Get data is: records = dda.Fill(ds, start, max, table); //does paging
update data is: records = dda.Update(ds, table);

[@Yozik2]

is dapper more vulnerable to sql injection then?

[@AdamsTaiwan]

I wonder if this is capable enough to work in multi-user situation like with web server.

[@MihaiMoisei]

Thanks a lot.

[@nosolocodigos]

Could you make a video on how to add sqlite in blazor webassembly to work on the browser?

[@bricelam]

ruclips.net/video/ZeJISZgy-FM/видео.html

[@olivier0003]

Quick and Useful

[@user-mk5rs3hd7n]

알지오 강의 추천합니다

[@ranggapratama9273]

Can you share the code to me to learn it?

[@dotnet]

Here you go aka.ms/SampleRepo

[@ranggapratama9273]

@@dotnet thank you