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
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...)?
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
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!
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!
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
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.
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 ?
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?
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?
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?
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.
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));
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!
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.
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
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.
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?
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!
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
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
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 ^_^
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
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)
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
Thanks for making this Video. I am working on new project and had some issues deciding where to add my SQLite. Thanks Again Houssem.
How are you inserting code snippets ? Can you guide about this ?
Very good starter, I noticed remove product is not implemented. Looking for the rest of this app.
Wow. Just what i needed today. perfect timing! tnx Houssem!
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
Keep this kind of videos. You are a mosnter dude! TOP!
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...)?
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
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!
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!
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!
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
There is a NUGET package SQLite.NET.Core-PCL to work with SQLite in PCL.
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.
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 ?
you have to upgrade
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?
I am having real issues with data annotations not able to use the likes of key and identy how did yo get through this.
nice video . Can I sync this to my remote db ?
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
Wasted 3 hours looking for code snippets, please share
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?
@Houssem Dellai How can I use the Remove Product async
Hi, Houssem. Will realm db be good and compatible with Xamarin.Forms mobile app as compared to SQLite?
Harsh Kumar the advantage of Realm is Data Synchronisation between local and remote database. If you need only local database, then go for SQLite
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?
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.
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... ???
Houssem Delai, how do you add SQLite connection to UWP project? You only treated iOS and Android
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));
hi i have no option my code snippets how can i find?
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!
nick ncik you may use any api for the backend
what do you mean by use any?
nick ncik i mean, whether it is in custom php, laravel, wordpress etc. As long as it is working, it should work fine
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.
i am not able to use interface from portable project in standard project
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
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.
Thanks will chk your recent tutorial as suggested.
Hi, it is possible to create relationship tables? if yes can you link me to the tutorial. thanks
Quiero lo mismo, tengo probleam al ingresar la llave foranea
what if the products page is not the first page of our application? how will we pass the repository than from App.cs?
You can create and Instance of it in your App.cs and then you can use it through out.
kamta nath when you say an instance of it, you mean the ProductsViewModel?
No, the instance of your database class/sqlite
Dear Mr. Houssem,
Can you send the name of the software for the video lecture (Share screen and video cam but windows 10)?
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?
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!
Thank you Tony for your feedback. Glad to hear that. The code is on github.com/houssemdellai
Houssem Dellai, thank you very much!
Please share code so I can test what you are trying to say
Thank so much Mr. Houssem! Very good explanation. How we use more than one repository?
Hi Mr Houssem Dellai, you used only a object, How to app with multi objects(multi tables)?
May i use that entity framework in Offline sync concepts (Microsoft.WindowsAzure.MobileServices.SQLiteStore).
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
It says : "Could not load assembly 'System.Memory' during startup registration" while running on android device... please help if anyone knows..
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
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 ^_^
how do I add the code fragment
For me DbContext doesn't exist. I installed the EFC nuget package correctly. Can anyone help?
Tienes que crear la clase DBContext y hererdar de DbContext
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?
Any access to github or something?
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
Thank you, For Share Knowledge to us
Its not showing this rare format inside the Class.cs
Insert Snippet
Can you pl create the sqlite migration tutorials.
Thanks Hussain can you make videos of Bluetooth scanning and data transfer through Bluetooth using Xamarin form
I'll consider that with no promises on short term :)
+Houssem Dellai even i need an help for bluetooh scanning app in xamarin form
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)
+Rebaï Hamida don't know how to use it
I want to use database first
Hi, Please make a video on joins with multiple tables in sqlite in xamarin.Forms app
Excelent work almost i found a video like this
did you use dependency injection in this video?
How to save this json :
{
"status": "success",
"data": {
"name": "Ashish",
"salary": "1",
"age": null,
"id": 85
}
}
share your snippet? it looks very good =)
For everyone looking for the link to the source code/snippets etc.
github.com/HoussemDellai/EFCore-SQLite-XamarinForms
Perfect explanatons thanks !
Congratulations teacher! Can you publish the project in github?
Демон, как ты это делаешь? Объясни по русски ничего де не понятно. Что ты нажимал когда создавал контекст базы данных?
Thanks a lot...
tank you very very very much
please share the source, it's impossible to follow what you are doing with your face covering the solution view
Nice
Try to make it simpler i watch another videos with better explanation for the same topic.
Which one? please share the link