Xamarin Tutorial Episode 4 - Local Database

Cross platform implementation of local database for Xamarin

[CarlosSosa-qfnl]

I've see 3 tutorial of the lists and they are excellent, Thanks.

[mayank.saxena]

Awesome !! Configured my app from static collection to a SQLite database one in 10 minutes. Thanks.

[MaxuelAguiar]

Very good, thank you for your shared the information, not find in other videos information complete.

I am from Brazil, excuse for bad english.

[kazmirci]

Thank u so much great tutorial for beginners but can u explain dependency service?

[omidzargar]

Beautiful demo! it has worked perfectly for me. Tks a lot

[DonBarracuda]

Anybody getting reference errors for SQLite, make sure you also install it on the Portable project.

[mrrcomp]

Hi 👋
Thanks for these tutorials . How can I delete the database from the device? I want to change the db table definitions.

[kokugan]

Thank for this tuto but where should put the getuser fonction? And it miss an fonction that compare the stored value with the one in DB.

[vitaliehanganu]

Hello Bert Bosh, i am doing the same steps are you doing in this tutorial and i do not know if it is a mistake but i just made some modifications in UserDatabaseController.cs. I instead of SaveUser Method i have splitted it in two method. SaveUser and UpdateUser. I did this becouse i expected that this Application can have only one User, and the Id of User will be always 0, so in Login.Xaml.cs i checked User returned via RestService and if it exist do update if not insert (this case is executed once on firs run app.). Are you agreee with me? So now you do not have errors by Getting User from Database. you could have Username of Logged user in all Pages by doing executing this line: lbl_username.Text = . You are doing great JOB by making this tutorial, i have learned a lot of this tutorials. Thankyou a lot. Regards Vito.

The thing to look for in the nuget manager is: "sqlite-net-pcl". I installed it to all projects, using Visual Studio 2019, from the nuget manager of the Solution.

[alanlevy]

SQLite-PCL do not work with the latest update of VS2017, what SQLite can i use instead?

[aichingerandreas]

Great Tutorial, but i got 2 Errors in my Controller classes:
ist "Methode" und im angegebenen Kontext nicht gültig.
SQLiteConnection.Table<T>()" ist "Methode" und im angegebenen Kontext nicht gültig.

any ideas?

[manuhurm]

Nice Video.
How could I connect my login page with an external database? Thanks

[monsieurmark]

Hi Bert, thank you very much for these tutorials. I saw in your Github repoistory there is no ISQL.cs file in the IOS project, but in the video there is. can you confirm it is not necessary in the IOS file? The app is crashing upon login and I just want to confrim it is not this point. Thanks!

[FalcoAcePilot]

the squlite package is not needed for the windows project?

[reikiwitherin]

4 errors being thrown for Ambiguity between 'Token.Id' and 'Token.Id' Any advice?

[batigol]

dears,
how can I use external sqlite3 database without create it

[Moreno]

I get an error namespace ISQLite not found

[Tyler-hfuc]

If I already have a service based server, which part is the most relevant in this tutorial?

[swnsn]

Is this saving the database to local storage?