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.microsoft.com/en-us/dot... Entity Framework - learn.microsoft.com/en-us/ef/...
Sample Repo: aka.ms/SampleRepo
Blog: aka.ms/dotnet/blog
Twitter: aka.ms/dotnet/twitter
TikTok: aka.ms/dotnet/tiktok
Mastodon: aka.ms/dotnet/mastodon
LinkedIn: aka.ms/dotnet/linkedin
Facebook: aka.ms/dotnet/facebook
Docs: learn.microsoft.com/dotnet
Forums: aka.ms/dotnet/forums
🙋‍♀️Q&A: aka.ms/dotnet-qa
👨‍🎓Microsoft Learn: 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

[@jalilseguel7]

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

[@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.

[@user-th6sk1ks2g]

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

[@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.

[@MihaiMoisei]

Thanks a lot.

[@olivier0003]

Quick and Useful

[@AdamsTaiwan]

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

[@ToddlersPreGra]

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

[@Yozik2]

is dapper more vulnerable to sql injection then?

[@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);

[@learnandsharel.a.s8126]

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.

[@nosolocodigos]

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

[@bricelam]

ua-cam.com/video/ZeJISZgy-FM/v-deo.html

[@user-mk5rs3hd7n]

알지오 강의 추천합니다

[@ranggapratama9273]

Can you share the code to me to learn it?

[@dotnet]

Here you go aka.ms/SampleRepo

[@ranggapratama9273]

@@dotnet thank you