Microsoft.Data.Sqlite 2.0 to target .NET Standard 2.0

[divega]

(Posting specifically about Microsoft.Data.Sqlite for visibility. This followed the same decision process as #246, so excuse the repetition.)

We have the intention to make Microsoft.Data.Sqlite 2.0 target .NET Standard 2.0 only. This means you will be able to use it on:

• .NET Framework 4.6.1 and up
• .NET Core 2.x
• Mono 5.x

There will be a period of time during which other .NET platforms will need to catch up to .NET Standard 2.0, e.g. an UWP version with support for .NET Standard 2.0 will arrive later this year, as announced at Build.

Microsoft.Data.Sqlite 1.x versions target .NET Framework 4.5.1 and .NET Standard 1.2 and can still be used in older platforms. The documentation on .NET Standard contains a full matrix of .NET platform support.

The change is already in the code and happened in two stages:

• PR Target .NET Standard 1.4 & 2.0 Microsoft.Data.Sqlite#370 made the Microsoft.Data.Sqlite 2.0 codebase cross-compile for .NET Standard 1.4 and 2.0 (.NET Standard 1.4 also maps to .NET Framework 4.6.1 but contains a much narrower set of APIs).
• PR Only target .NET Standard 2.0 Microsoft.Data.Sqlite#372 removed .NET Standard 1.4 and all the conditional compilation we had for it.

Why do we want to do this?

Because

• it simplifies our compatibility story for the long term,
• improves the maintainability of our codebase,
• reduces the size of the our packages
• and prevents Microsoft.Data.Sqlite from falsely appearing to be compatible with platforms on which we are not doing any testing.

Please post any questions, feedback or concerns on the following discussion thread:
aspnet/Microsoft.Data.Sqlite#373