Overall plan for 3.x docs

[ajcvickers]

• Update banner/readme to reflect the present
  • EF Core
  • EF6
• Ensure dependencies are correct and consistent
  • .NET versions supported - consider consolidating into a single page Update description of what targets EF Core supports #1635
• Move wiki information into repo markdown files
• Update issue templates
• Cleanup table of contents Reorganize ToC for new pattern with expandable nodes #1517
• Initial issue scrub (@ajcvickers)
• Samples:
  • Move all samples to docs repo Move all samples to docs repo and improve code directory layout #487
  • Update for 3.0 Consider changing samples to use .NET Core 3.0 by default #1074
• Create a first-class story for Microsoft.Data.Sqlite docs (@bricelam)
• Update "data access technology for Visual Studio" docs - moved to Ensure Visual Studio docs/references align with runtime docs #2053

[bricelam]

I think the Microsoft.Data.Sqlite docs would be most discoverable if they went next to the ADO.NET and SqlClient docs: https://docs.microsoft.com/dotnet/framework/data/adonet/ (https://github.com/dotnet/docs/tree/master/docs/framework/data/adonet)

[roji]

@bricelam agree, and on a totally unrelated note the ADO.NET and SqlClient docs should also move out of .NET Framework (or be duplicated into .NET Core or something...). I'll try to see with @mairaw what the plans are after we stop doing bug fixes on 3.1.

[mairaw]

I’ll forward you a thread that we had with Diego where we started discussing this. The SQL team (@stevestein) owns that section of the content.
Usually, content that applies to both Core and Framework lives in the .NET Guide.

[bricelam]

Here is a list of topics for Microsoft.Data.Sqlite:

• Overview
• Connection strings
  • (Link to https://docs.microsoft.com/dotnet/framework/data/adonet/connection-strings)
  • (Update https://github.com/aspnet/Microsoft.Data.Sqlite/wiki/Connection-Strings)
• Data type mappings
  • (Like https://docs.microsoft.com/dotnet/framework/data/adonet/sql-server-data-type-mappings)
  • (Update https://github.com/aspnet/Microsoft.Data.Sqlite/wiki/Data-Type-Mappings)
• Parameters
  • (Adapt DateAndTimeSample)
• Command timeouts/busy retries
• Transactions
  • (Adapt DirtyReadSample)
• Batching
  • (Adapt BatchingSample)
  • (Mention DbDataReader.NextResult())
• Result metadata
  • (Adapt ResultMetadataSample)
• SQLite features
  • In-memory databases
    • (Adapt InMemorySample)
    • (Port https://www.bricelam.net/2015/12/10/shareable-in-memory-databases.html)
  • User-defined functions
    • (Adapt AggregateFunctionSample)
    • (Adapt RegularExpressionSample)
    • (Adapt ScalarFunctionSample)
  • Collation
    • (Adapt CollationSample)
  • Encryption
    • (Adapt EncryptionSample)
    • (Port https://www.bricelam.net/2016/06/13/sqlite-encryption.html)
  • BLOB I/O streams
    • (Adapt StreamingSample)
  • Using a custom version of SQLite
  • Interop/SQLitePCL.raw/handles
    • (Adapt InteropSample)
• Limitations
  • Async
    • (Adapt AsyncSample)
  • Bulk insert
    • (Adapt BulkInsertSample)
    • (Port https://www.bricelam.net/2017/07/20/sqlite-bulk-insert.html)
  • Xamarin.iOS Workarounds for Xamarin.iOS app with EFCore 2.0 #597
    • (Mention SQLitePCL.Batteries_V2.Init())
  • ADO.NET features
    • (Mention DbConnection.GetSchema())
    • (Mention System.Transactions) Microsoft.Data.Sqlite: Virtual table modules efcore#13823
    • (Mention DataAdapter) Microsoft.Data.Sqlite: No SqliteDataAdapter efcore#13838
• Comparison to System.Data.SQLite
  • (Adapt https://www.bricelam.net/2018/05/24/microsoft-data-sqlite-2-1.html#comment-3980643870)
  • (Mention less connection string keywords and no connection flags)
  • (No authorization) Microsoft.Data.Sqlite: Authorization Callbacks efcore#13835
  • (No data change notifications) Microsoft.Data.Sqlite: Implement Data Change Notifications Callback efcore#13827
  • (No virtual table modules) Microsoft.Data.Sqlite: Virtual table modules efcore#13823