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.

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.

[simont]

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

[jalilseguel]

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

[fuzzy-]

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.

[KvapuJanjalia]

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

[thskksg]

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

[KengSouth]

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

[AdamsTaiwan]

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

[Yozik]

is dapper more vulnerable to sql injection then?

[nosolocodigos]

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

[ranggapratama]

Can you share the code to me to learn it?