How to Add a Database to Xamarin & .NET MAUI apps with SQLite-net

Every app needs to store data and it couldn't be easier than with SQLite-net for your mobile applications build with C#, .NET, and Xamarin! In today's video we take a look of how to get started with storing data in a SQLite database and how to perform CRUD operations.

Time Codes:
00:00 - Intro
01:23 - Database Options & Installing SQLite-net
04:53 - Database Service & SQLite Setup
11:26 - Basic CRUD operations
16:25 - Database with MVVM
21:30 - Wrap-up

Links:

Disclaimer: This channel, videos, and streams are created in my spare time and are a product of me... James Montemagno! They are NOT officially affiliated or endorsed by Microsoft (my employer) in any way. Opinions and views are my own.

Follow:

My Setup:

#SQLite #Database #Xamarin #Mobile

[betteaage]

For those wondering why the "id" at 20:10 is 1 when it should be 2, it is because it is not the id that is returned - it is the number of rows affected, which is 1.

[samosimo]

Nice video but we need tutorial of sync local database and database "sync sqlite and mysql" with xamarin forms

[johnolawale]

I can't believe I've been sleeping on this channel. So many good contents here

[drivetrainerYT]

Can’t stop likes and comments, thanks James, crispy clear and helpful.

[matejlaskomulej]

First time trying to store data from app into device and you made it a breeze. Been using some of your packages before, but just found this channel for the first time. Subscribed! Thank you!!

[radoslavatanasov]

James so much thanks about your videos you help us a lot! I have a suggestion, can you do a second part of some of your lessons with things for advanced. Here, for example, you can make an advanced video to show how to create a database with a script, how to update the tables with a script and some more complex queries.

[jennifermckeithen]

This is so helpful! Really appreciate that you walk us through the documentation as well. Thanks so much!

[hanh.trinh.yeu.thuong]

You are the best teacher on youtube I've ever seen!!!

[yasminaamroun]

can you give us an example of a database with several tables?

[blinkskaterkc]

Extremely helpful video, thank you. I have some reworking to do :)

[cristisandu]

Wow, you can make a integration with a Azure DB ? I have 150$ on Azure monthly and I try to use it in a application but documentation is a little bit too complicated. Thank you very much! You are a legend 🎉

[MukelabaiMukelabai]

You made this look so simple--another mountain laid low for me!

[kennethguerrero]

Great video as always! Please make one using online db - Azure Table Storage and Functions.

[MehStang]

Awesome video! Can you also show how to now change databases using mvvm and similar services? Maybe discuss more on attributes? I was watching a mongodb c# video and attributes were used everywhere. (Maybe discuss entity framework) I love also how you are maintaining mvvm! I’m jumping into xamarin and your videos along with your other Best friends in the entire world have been illuminating!

[DifferentTurn]

James, you're the man! Can't describe how much I appreciate absolutely amazing job you've done for Xamarin Community with a such great detailed videos. 🙃

p.s. Am I the only one who can't help himself but always shaking with head & shoulders to the rhytm of JM's intro music?😅

[AMIRKHAN-dmfm]

Thank you so much but if we want to make offline and online sync with local sqlite database then how we can achieve that?

[stephanraab]

Just the video I was hoping you'd post soon!

[rickfuzzy]

Hey James, tip for you in VS: If you press ctrl-c without selecting anything it copies the line, you can then paste the full line with the line break exactly where you want it. This seems to be fairly unknown, but saves a mountain of time for me. For example to duplicate a line just press ctrl-c and ctrl-v without selecting anything
Thanks for the video.

[boyingsplace]

Many many thanks... very helpful for beginner like me.

God bless!

[jalemanyr]

Great tutorial, One question, why need to add a Delay(2000) in the refresh? thanks