I feel like I've missed something quite important in my education here. Whenever I start a new project I'm spending a lot of time finding out which versions of Sqlite play nice with my current .NET Core version.

Attempting to install each version, reading the discrepancy with my current version of Core, restoring and searching again is a little tedious and I'm sure that's not supposed to be what I'm doing. Is there a chart that shows what versions of MS packages work well together? Some way I never read about to figure it out? Is it trial and error? Reading some set of documents I haven't seen every time?

If anyone can point me to where I can learn more about versioning and solving discrepancies I'd greatly appreciate it!