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
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
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!
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!
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!
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.
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?
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 ?
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?
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.
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?
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
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));
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 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.
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 ^_^
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)
Wow. Just what i needed today. perfect timing! tnx Houssem!
Keep this kind of videos. You are a mosnter dude! TOP!
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.
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
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!
Perfect explanatons thanks !
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
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
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!
Thank you, For Share Knowledge to us
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!
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!
nice video . Can I sync this to my remote db ?
hi i have no option my code snippets how can i find?
Excelent work almost i found a video like this
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.
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?
Wasted 3 hours looking for code snippets, please share
I am having real issues with data annotations not able to use the likes of key and identy how did yo get through this.
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
Please share code so I can test what you are trying to say
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
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
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?
Thank so much Mr. Houssem! Very good explanation. How we use more than one repository?
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.
@Houssem Dellai How can I use the Remove Product async
i am not able to use interface from portable project in standard project
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... ???
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?
Thanks a lot...
Dear Mr. Houssem,
Can you send the name of the software for the video lecture (Share screen and video cam but windows 10)?
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
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.
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));
how do I add the code fragment
Hi Mr Houssem Dellai, you used only a object, How to app with multi objects(multi tables)?
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
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
tank you very very very much
Can you pl create the sqlite migration tutorials.
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.
Any access to github or something?
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
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?
May i use that entity framework in Offline sync concepts (Microsoft.WindowsAzure.MobileServices.SQLiteStore).
Hi, Please make a video on joins with multiple tables in sqlite in xamarin.Forms app
Its not showing this rare format inside the Class.cs
Insert Snippet
I want to use database first
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
share your snippet? it looks very good =)
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 ^_^
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
Nice
Congratulations teacher! Can you publish the project in github?
How to save this json :
{
"status": "success",
"data": {
"name": "Ashish",
"salary": "1",
"age": null,
"id": 85
}
}
For everyone looking for the link to the source code/snippets etc.
github.com/HoussemDellai/EFCore-SQLite-XamarinForms
did you use dependency injection in this video?
Демон, как ты это делаешь? Объясни по русски ничего де не понятно. Что ты нажимал когда создавал контекст базы данных?
Try to make it simpler i watch another videos with better explanation for the same topic.
Which one? please share the link
please share the source, it's impossible to follow what you are doing with your face covering the solution view