How To Use an Existing SQLite Database with Xamarin and .NET MAUI
You might want to supply a prebuilt SQLite db file with your app but you’re wondering how to do that. Say no more! In this video we will learn how to add the SQLite database file to your app, copy it to the device and actually use it to query data.
💝 Join this channel to get access to perks:
https://www.youtube.com/channel/GeraldVersluis/join
Disclaimer: this channel is done on personal title, in my free time, and not officially affiliated with or endorsed by Microsoft (my employer) in any way. Opinions and views are my own.
🛑 Don’t forget to subscribe to my channel for more cool content: https://www.youtube.com/GeraldVersluis/?sub_confirmation=1
🐦 Follow me on Twitter: https://twitter.com/jfversluis
🤝 Join the Discord server: https://discord.gg/2cAyTGNHBD
🔗 Links
Sample App Repository: https://github.com/jfversluis/ExistingSQLiteDbSample
CRUD Actions With SQLite Video: https://www.youtube.com/watch?v=8_cqUvriwM8
Databinding Playlist: https://www.youtube.com/watch?v=Or_qn8i8jVM&list=PLfbOp004UaYWOuVUuEtGlpkDIC1houhn_
⏱ Timestamps
00:00 – Use Existing SQLite Database
00:18 – What We’ll Learn in This Video
00:39 – Also Works on .NET MAUI!
01:08 – Add Database File to Embedded Resources
02:02 – Install SQLite NuGet Package
02:23 – Inspect Existing Database Schema
04:31 – Copy Existing Database File to Filesystem
07:32 – Create Database Models
08:49 – Setup Database Connection
11:45 – Implement UI to Show Database Data
12:53 – Retrieve Data from Database
14:54 – Running the Sample App
16:16 – Learn More About SQLite or Databinding?
🎥 Video edited with Camtasia (ref): https://techsmith.z6rjha.net/AJoeD
🙋♂️ Also find my…
Blog: https://blog.verslu.is
Twitch: https://twitch.tv/jfversluis
All the rest: https://jfversluis.dev
#sqlite #xamarinforms #dotnetmaui #maui #dotnet6 #localdatabase
Comments are closed.