I'm writing an app for a friend who does some charity work. I'm not an experienced Xamarin, c# or .Net developer. And I learn by seeing some working code, breaking it and then understanding what the docs are telling me.
Given that haphazard approach, surprisingly I've got 95% of the app working. But I'm completely stuck on populating an ObservableCollection from SQLite. I'm doing this because of the way they want to represent the data they're recording and the SyncFusion SFChart does what they want.
I can populate the charts using OberservableColections of data hard coded in a class. I can populate ListView's from the SQLite database using LINQ and SQLiteAsyncConnection . For those parts I think I've got a decent understanding of what I'm doing (and I've bought a set of courses from Udemy to learn it properly). However I'm really struggling to populate the Observable Collections the Syncfusion charts need when I try pull the data from SQLite.
After lots of searching and trial and error, I'm coming across both very little in the way of worked examples of ObservableCollections and SQLite. But also comments to other peoples questions on StackExchange effectively saying "it's easy, stop asking basic questions". Which leads me to think that I'm approaching the problem in the wrong way.
All of that pre-amble is effectively me saying I've done lots of research, I've got a lot of the way on my own, and I'm not asking for someone to write my code for me. But I think my lack of knowledge in Xamarin / C# / .NET means I'm trying to solve the problem in the wrong way. So given the same problem, how would you approach it? Just trying to get a feel as to whether I should keep banging my head against this brick wall or I should try a different approach that is obvious to more experienced developers