Entity Framework Core with SQLite for Xamarin Forms

[@ritchiefernandes4510]

Awesome! never thought we could use EF Core inside Xamarin Forms App. So that means we can use migrations too to update the database. Cool

[@Archfile375]

Very nice video! I do wish someone would make one where the CR portion is completed as well as the Create and Read. The Update is perhaps the more detailed oriented part that is missing. I'd like to see a Master/Detail navigation and Update and Delete implemented. Regardless, nice video!

[@oscarmoncayo9638]

Keep this kind of videos. You are a mosnter dude! TOP!

[@122raheem]

Hi, Could I just ask a quick question, When I was adding a project at the beginning and I do not have the .Net Standard, I have the .Net Core, but I do not know if that is the same thing? Help

[@howtoapply5170]

How are you inserting code snippets ? Can you guide about this ?

[@davidmorrow1393]

Very good starter, I noticed remove product is not implemented. Looking for the rest of this app.

[@Shogoeu]

There is a NUGET package SQLite.NET.Core-PCL to work with SQLite in PCL.

[@1cinisra1]

but it does not security, in my particular case, I will use EF core because I can put a password to the NAMEDB.DB3 . So if you have a better idea please do not doubt to let me know.

[@nickncik6864]

Wow. Just what i needed today. perfect timing! tnx Houssem!

[@AngeloValdezlovejesus]

Whatdo you think is the best approach to create an app that is connected to local database and could be able to sync to online database? Thanks!

[@Learn_with_cosmos]

Thanks for making this Video. I am working on new project and had some issues deciding where to add my SQLite. Thanks Again Houssem.

[@maceloo]

Hello Houssem! I have implemented this, but when I alter my class, I need alter my table on device. How I can alter my table when the app already installed in the device (without migrations...)?

[@pantelis90i]

Hi Houssem, How would one be able to alter their tables without affecting the data already stored? This is a common scenario because after a few months someone might want to update the application (adding more columns in tables/models). Thanks

[@changyeeheng3854]

Hello, since using CRUD, may i ask that can i able to do upload image by using this methods too since what i knew so far was have to convert to byte first, am i right?

[@adeelmalik6002]

Hello Houssem Dellai i am using latest xamarin version in which creating .Net Standard project option is already exist and PCL option is removed so i did not add seperate project of .net standard when i execute the project it gives me lots of error so of therse are given below Could not load assembly 'System.Runtime.CompilerServices.Unsafe' during startup registration. 02-07 00:01:45.379 F/monodroid-assembly( 3796): This might be due to an invalid debug installation. 02-07 00:01:45.379 F/monodroid-assembly( 3796): A common cause is to 'adb install' the app directly instead of doing from the IDE. can you plz help me for this issue . THANKS

[@frankietank8019]

Hi Houssem, thanks for this video, really helpful. One question: shouldn't the database context be short-lived? I.e. opening for a query, disposing straight after that? I was told creating one context on app startup would impact performance, and the docs say the same thing. Thanks!

[@dotnetdevni]

I am having real issues with data annotations not able to use the likes of key and identy how did yo get through this.

[@tonysabarez3790]

Thank you very much Houssem. I've been watching several of your tutorials for several days now and I am very much learning. Quick question regarding you code snippets, are those available somewhere? This would be a very good practice and exercise. Thanks much!

[@HoussemDellai]

Thank you Tony for your feedback. Glad to hear that. The code is on github.com/houssemdellai

[@tonysabarez3790]

Houssem Dellai, thank you very much!

[@andysonm]

@Houssem Dellai How can I use the Remove Product async

[@rgaikwad7354]

Thanks houssem, but i want to know one thing is, we have only one table(products repository) so we are passing through Efcore.android projet, so what if we have another table for example employee? How to pass that new repository (employeeRepository)? Or we should implement it in ProductsRepository? Please give solution or correct me if i wrong?

[@muhammadyaseen7022]

Hi sir how are you sir im working on xamarin forums with entityframwork core sqlite 2.0 with microsoft core sdk 2.0 it was working fine with my all projects but recently microsoft .net sdk core have been updated from 2.0 to 2.2. but my now my entityframwork did not working and displayiing error "could not link assemblies Reason: index is byount the type of array" kindly guide me plesase what i must do no ?

[@raycarlbrown-amory3509]

you have to upgrade

[@thecouple2023]

Hi, Houssem. Will realm db be good and compatible with Xamarin.Forms mobile app as compared to SQLite?

[@HoussemDellai]

Harsh Kumar the advantage of Realm is Data Synchronisation between local and remote database. If you need only local database, then go for SQLite

[@aslleal]

Thank so much Mr. Houssem! Very good explanation. How we use more than one repository?

[@Learn_with_cosmos]

I don't see anything like SQLite. I see only EF framework could you explain how you used the SQLite so that it is clear? Thanks

[@DhirenNaik]

nice video . Can I sync this to my remote db ?

[@thomasnielsen7466]

Wasted 3 hours looking for code snippets, please share

[@shandeepkumar3127]

Hi Houssem Dellai, I need to know refresh to load automatically while Product page view page is loaded as initially... can you please help me... ???

[@BlalKhalidTech]

hi i have no option my code snippets how can i find?

[@anatoliytkachenko1498]

Thnx a lot for great explanation!!! Is it possible to sync data between Ms SQL Server on Azure and SQLite local DB in Xamarin.Forms using .NET Standard proxy project?

[@radhikakurre7393]

i am not able to use interface from portable project in standard project

[@Dr..Math5]

Dear Mr. Houssem, Can you send the name of the software for the video lecture (Share screen and video cam but windows 10)?

[@nickncik6864]

another thing houssem, im sorry if this is a bit irelevant but can i make a platform using xamarin forms in mobile and wordpress in web? can they share the same API? thanks!

[@ahmadchishti8848]

nick ncik you may use any api for the backend

[@nickncik6864]

what do you mean by use any?

[@ahmadchishti8848]

nick ncik i mean, whether it is in custom php, laravel, wordpress etc. As long as it is working, it should work fine

[@Learn_with_cosmos]

A backend is just a backend no matter what language or framework you use. If you have endPoints then that works anywhere unless you mean something different. If your wordPress is using PHP API, then the API should be standard to be used anywhere.

[@lombertiniabdoul8934]

hi houssem ! I'm very happy to following you. you are a big mentor for me. But I have a question....Do you know , how to use entityFrameWorkCore to connect an existent bd with your project ( Use the bd with sqlite

[@makavanavishal]

Thank you, For Share Knowledge to us

[@doyin_dimeji]

Houssem Delai, how do you add SQLite connection to UWP project? You only treated iOS and Android

[@pantelis90i]

Same idea with the other 2 projects. Inside the UWP project > MainPage.xaml.cs add this: var dbPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.LocalApplicationData), "dbname.db"); var myRepository = new MyRepository(dbPath); LoadApplication( new MyProject.App(myRepository));

[@sokheang-khun]

After I add one more DbSet Customers and run there's an error when I access to my new table. The error said there's no such Customers table. How can I fix this?

[@pantelis90i]

It needs some kind of migrations to update the database. I have the same issue and unfortunately i don't know how to go around it other than deleting the DB and creating it again. On a .net core application (website) you could set up a separate migrations project to update your DB schema but don't know how to do that on this scenario.

[@cbmehta1038]

Hi, I just started Xamarin form development with VStudio 2017. however i found "code sharing strategy as .Net Standard instead of PCL. so when i download SqLite.net.standard, it is not working as soon as i add using SqLite and showing old version error. Kindly help

[@Sparrow420]

Hey, this video is outdated as PCL are "no longer used", you can still make one under the 'legacy' tab, but you're better off finding a recent tutorial.

[@cbmehta1038]

Thanks will chk your recent tutorial as suggested.

[@neisercp]

Very good video friend, but I have a question I hope you can help me how would you do that you show the data in a ListView I want you to generate me a text file with the data I am showing in the ListView the data saved in the ListView to be able to differentiate them I want to show me separated by a (palote |) and that the file is saved in a directory of the SD card or internal memory of the phone I urge you to do that, my friend, if you can help me with that ... I would appreciate it very much

[@sharmafamilykvideos]

Hi, Please make a video on joins with multiple tables in sqlite in xamarin.Forms app

[@rajeshangappan7849]

May i use that entity framework in Offline sync concepts (Microsoft.WindowsAzure.MobileServices.SQLiteStore).

[@AizaNews]

Hi Mr Houssem Dellai, you used only a object, How to app with multi objects(multi tables)?

[@SA-mh7uy]

Please share code so I can test what you are trying to say

[@juantaday]

how do I add the code fragment

[@aljonsindanum37]

Hi, it is possible to create relationship tables? if yes can you link me to the tutorial. thanks

[@encisolunagenaroyair3542]

Quiero lo mismo, tengo probleam al ingresar la llave foranea

[@stanisawgolinski3244]

Any access to github or something?

[@mandardesai3841]

Thanks Hussain can you make videos of Bluetooth scanning and data transfer through Bluetooth using Xamarin form

[@HoussemDellai]

I'll consider that with no promises on short term :)

[@mohanlalsudharsan8904]

+Houssem Dellai even i need an help for bluetooh scanning app in xamarin form

[@RebaïHamidaMVP]

You can use BLE (developer.xamarin.com/samples/mobile/BluetoothLEExplorer) and you can take a look to this project on github (github.com/xabre/xamarin-bluetooth-le)

[@mohanlalsudharsan8904]

+Rebaï Hamida don't know how to use it

[@DipenHansawala]

Can you pl create the sqlite migration tutorials.

[@ahmadchishti8848]

what if the products page is not the first page of our application? how will we pass the repository than from App.cs?

[@kamtanath4494]

You can create and Instance of it in your App.cs and then you can use it through out.

[@ahmadchishti8848]

kamta nath when you say an instance of it, you mean the ProductsViewModel?

[@kamtanath4494]

No, the instance of your database class/sqlite

[@AhmedShamel]

I want to add password to file. I search on the Internet to find how to do that, but I can't find a way. Can you help me?

[@luiss9897]

share your snippet? it looks very good =)

[@antonitescaro2728]

For me DbContext doesn't exist. I installed the EFC nuget package correctly. Can anyone help?

[@encisolunagenaroyair3542]

Tienes que crear la clase DBContext y hererdar de DbContext

[@mcaves___1441]

It says : "Could not load assembly 'System.Memory' during startup registration" while running on android device... please help if anyone knows..

[@licentiavelnex3500]

Hi, I run into the same problem, the fix is to downgrade the ef core version to 2.0.3 from the nuget manager, this is a bug by the way, they will probably fix it with the next version

[@mcaves___1441]

oks ... but i want to ask one things if you know, what is the difference between using entityframeworkcore.sqlite and sql-net-pcl?? last time i had worked well in sql-net-pcl in xamarin android but here i see efcore.sqlite in xamarin forms(now i want to work in xamarin forms) ... can we use sql net pcl in xamarin forms?? or are they same or what is the key difference?? thanks in advance ^_^

[@thierryjrparis2414]

Perfect explanatons thanks !

[@yt12356]

For everyone looking for the link to the source code/snippets etc. github.com/HoussemDellai/EFCore-SQLite-XamarinForms

[@flaviobarbosax]

Congratulations teacher! Can you publish the project in github?

[@opendatopendat6273]

Its not showing this rare format inside the Class.cs Insert Snippet

[@jonatanbuitrago4505]

Excelent work almost i found a video like this

[@rahmatabadi3839]

did you use dependency injection in this video?

[@dilhaitumhara691]

Thanks a lot...

[@amjadaslam5270]

I want to use database first

[@HamzehArkia]

tank you very very very much

[@ashishgarggarg5379]

How to save this json : { "status": "success", "data": { "name": "Ashish", "salary": "1", "age": null, "id": 85 } }

[@Виталий-ь9о4ц]

Демон, как ты это делаешь? Объясни по русски ничего де не понятно. Что ты нажимал когда создавал контекст базы данных?

[@Rynas]

Nice

[@juanpablotorres2143]

Try to make it simpler i watch another videos with better explanation for the same topic.

[@Chalbuilder2012]

Which one? please share the link

[@thomasnielsen7466]

please share the source, it's impossible to follow what you are doing with your face covering the solution view