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

Video quality	The size	Download

Информация о How to Add a Database to Xamarin u0026 .NET MAUI apps with SQLite-net

Название	:	How to Add a Database to Xamarin u0026 .NET MAUI apps with SQLite-net
Продолжительность	:	23.13
Дата публикации	:
Просмотров	:	66 rb

James, great video!!! Thanks a lot! Could you do a video explaining how to use an external service to push notifications? Thank you again!!!
Comment from : Cristiano Salvatori

How to add sql dB yo netmaui
Comment from : Okt Jona

can you give us an example of a database with several tables?
Comment from : yasmina amroun

public AsyncCommand AddCommand { get; } does not work it can't find AsyncCommand How to I get this?
Comment from : Wuschel

Great video I'm curious if you are able to do this with dependency injection? If you are able to, what are the benefits of using a static class vs using DI?
Comment from : Harold MacDonald

Thank you for the video My question is:brbrSuppose I have already an SQLite DB that I want to use as embedded resource, how I open it instead of creating it please?
Comment from : brimbon

Thank you for this I can;t seem to locate the MyCoffeeStoredPage on your Github though
Comment from : Mozilla

Many many thanks very helpful for beginner like mebrbrGod bless!
Comment from : Boyings Place

please do mongodb or something simliar
Comment from : Stephen S

it doesn't work with MAUI does it?
Comment from : Name Last Name

Hi, James, very good Video, you have any video with de Maui and Firebase ? thanks very much
Comment from : Leonardo Yanez

My code is pretty much identical to yours the only difference is I hide my database inside a service (singleton) that gets injected
Comment from : David Jackson

Can you do a MAUI specific example please :)
Comment from : David Jackson

Does your CoffeeService have to be s "static" class? I have a dynamic class (that gets injected) with a static DB instance (I couldn't figure out how to DI it, I kept getting errors) But now to a Windows target, it works fine but to an Android target I get SQLiteException, have you seen this behaviour before? Its a Xamarn App that was working fine, that I'm trying to move to MAUI
Comment from : David Jackson

Obvious question When the app starts up again wont it recreate the database, ie wipe out any data that's already there ?
Comment from : David Jackson

Hello James, I copied your code almost one to one and my app just crashes whenever I refresh can you help me?
Comment from : PuineaGip

James, you're are a legend mate, I missed the U in your CRUD example, I followed along nicely but not sure how to change on of the values in a record, does SQLite even allow that?
Comment from : Mathew Bowden

What im i doing wrong? i get SystemTypeInitializationException: 'The type initializer for 'SQLiteSQLiteConnection' threw an exception' ?
Comment from : Lars Larsson

I was hoping to follow along from the last video (trying to code it from scratch with you) but it seems you made a bunch of changes to the app in another video? I guess this playlist is not in the correct order? Going to try and piece this together from the github
Comment from : GuildOfCalamity

James, when I install the SQLite-net it downgrades the essentials and forms, is this going to be a problem?
Comment from : Star VR

Can’t stop likes and comments, thanks James, crispy clear and helpful
Comment from : Drive Trainer

Hello, your videos are great Can you do an example on how to get the sum of a total from sqlite and show it in a label?
Comment from : Diores Lora

Hi brhow can I deal with sql server by xamarin using Entity Framework CorebrOr which ORM to use with sql server in xamarin
Comment from : Mohammed

The same way we use sqlite in blazor hybrid?
Comment from : TomA

How to store this in cloud so that it data is recovered on logon?
Comment from : Gary Smith

Just a question, can I injection the Database manager into the Dependency service? Or is there a good reason not to do so?
Comment from : Max Almonte

how to build xamarin sqlite crud app ( with images - exp : like photo app gallery )
Comment from : YaserDotNet

How could you use an sqlite tool to view the contents of the database either directly on the emulator or by somehow copying it to the development computer?
Comment from : Doug Maurer

Super interesting how easy it is to create a simple db app Thx
Comment from : CS_Minasmins

Hi Netmaui application connect with local or remote server (mssql,mysql,postgresql) connect success on windows, macos and ios but android , it is not successfull Please remote server connect with netmaui example video Thanks
Comment from : özkan kara

Awesome video like everyone! Could you create one to show us how to sync this sqliteDB with an webdav drive that the app on an other device can use the same data as well br brso like some way how to sync the entries over the different devices in that app
Comment from : Tino K

how to autorefresh?
Comment from : Max

Another great video James !!!! Aren't we supposed to find a MyDatadb file in the app folder ??? Because i can't find one
Comment from : RedSama

Thanks for the video, James! I have been following your tutorial and at the point were I add a coffee to the data base it doesn’t appear after the refresh, the main page is just blank, any suggestions? Thanks! (timing of the problem 19:44)
Comment from : Artur

Dear James , I want to know if it possible to exchange data between xamarin form and desktop app using ms-access db thanks in advance
Comment from : abdo aly

How to Save Database on the Card?
Comment from : Dmitriy Konopinskiy

You made this look so simple--another mountain laid low for me!
Comment from : Mukelabai Mukelabai

Thanks, this is so helpful Please can you host the same database online instead of offline Please can you also help me with that Thank you
Comment from : Gideon Owusu

This man is doing god's work
Comment from : Ruslan H

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 🙃brbrps Am I the only one who can't help himself but always shaking with head & shoulders to the rhytm of JM's intro music?😅
Comment from : Aliaksei Mazhuts

how can I model relationships using this library?
Comment from : Jethro Djan

hey James, great video thanks for putting it out there You did not mention the reason for the TaskDelay(2000) call in the Refresh() method What is the benefit of having that call in there? Or, what would happen if there was no forced delay ?
Comment from : jboys

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!!
Comment from : matejlaskomulej

How would you do full text search with fts5?
Comment from : Hideki Matsuura

can you also save an image ?
Comment from : HK G

How to fill a database with data that are required in the app, and not coming from the user by using the app?
Comment from : A S

Could you please make a tutorial about Firestore ?
Comment from : Matteo C

Show us your "service approach" with the database please
Comment from : Divan Gerber

Great tutorials and very helpful for beginners Thank you very much James
Comment from : rcm

Excellent work Thank you!
Comment from : Moussa Babaousmail

Why doesn't it have an audio file option?
Comment from : Jake Thompson

Thank you so much for all this brilliant content! Is there any chance you can do a tutorial for SQLite relational databases? I'm trying to add a ForeignKey attribute to a prop but can't find anything solid via Google
Comment from : JC van der Merwe

I still can't figure this out, HELP T_T brCannot implicitly convert type 'SystemThreadingTasksTask>' to 'SystemCollectionsIEnumerable'
Comment from : OlCAtGaming

Simple and thorough Thanks again, JamesbrCould you please include how to connect your Xamarin App to an API server (JSON) in your upcoming videos?brI need to share data from a SQL server used in house with the outside mobile app users
Comment from : Micro Lar

Any recommendations on how to deploy a Xamarin app with a prepopulated SQLite database?
Comment from : Brutakk

Awesome!
Comment from : LifeOfLee

Great video Have to ask as I’m coming from another dev env: wouldn’t GUID be safer than an int id when many devices are sync’ing with one centralized server?
Comment from : Ryan Smith

You are the best teacher on youtube I've ever seen!!!
Comment from : Hành trình yêu thương

Nice tutorial! How can you automatically display the data upon going into the MyCofffee page (@21:10) from the database without pulling to refresh the page?
Comment from : John H2

So generally we would create a separate api and connect to that to do the CRUD part?
Comment from : lardosian

This is so helpful! Really appreciate that you walk us through the documentation as well Thanks so much!
Comment from : Jennifer McKeithen

How is the simplest way to backup my local db on cloud? 🤔
Comment from : Dev Superman

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
Comment from : Betteaage

I am using this tutorial but I have noticed that when the application is launched with data in the SQLite DB you have to refresh I have been tinkering with this and cannot seem to find what looks like the "proper" way you would have this DB data shown without the refresh on launch
Comment from : Pj H

Is it better to use sqlite or firebase ?
Comment from : Matteo C

How can I use foreign key on Sqlite-net-pcl?
Comment from : SUPER MARIO

Great video as usual! Regarding performance, how does SQLite-net compare to EF Core? I use EF Core in my Xamarin apps and have some performance issues (mostly on Android)
Comment from : Drossoft Apps

Thank you Sir for your Tutorials are helpful and easy explanation way Really you are a good TeacherbrI have a request, can you please make a tutorial About WPF with MVVM Design to build a App like in real life when creating a project?? And sure we would like you add your touch what best ways, and framework and deal with Database
Comment from : Azzeddine Dia

Can you do a navigation video?
Comment from : CraxGaming

Thanks James! Awesome video Can you show how to use NOSQL database with Xamarin?
Comment from : Aggie S

Awesome Video! Interesting to see you using a lazy loading technique for initializing your services In my next application I will give that approach a try :)
Comment from : Chase Roth

Hey James! Thanks for that great content Do you have any tips for integrating with an existing azure SQL db? I’ve designed my db using ssms but I’m unsure on what’s the best way to integrate it to my app Thanks!
Comment from : Matheus Zanola

Great video as alwaysbrWant to see how to do migrations in SQLite
Comment from : Rajnikant Patel

Great to see how easy this is Would be interested to see a comparison with setup of Realm DB - and pro/con vs SQLite
Comment from : Obliterator Obliterator

Another great video James! ThanksbrbrA few questions are there any significant advantages of dealing with SQLite on such a low level?brI have a production app with a fairly complex data model To store the data offline I de/serialize the entire thing using Akavache (which uses SQLite under the hood)brbrEverything works great, no issues at all Akavache encapsulates all the wiring of tables internally brbrSame with your MonkeyCache, it's also awesome too I'm starting to use it as wellbrQuestion #2 - I'm curious why do you say MonkeyCache/Akavache et al are "caches" only? Why can't they be persistent data stores?
Comment from : Bob