designer assembly 'FSharp.Data.SqlClient.DesignTime.dll' cannot be loaded or doesn't exist

Description

Attempting to compile with latest 2.0.1 release

Repro steps

Following code does not compile

open FSharp.Data

[<Literal>]
let connectionString = @"redacted"

type userProfileDb = SqlProgrammabilityProvider<connectionString>

Expected behavior

Type provider gives access to stored procs

Actual behavior

Compiler error

SC : error FS3031: The type provider 'C:\Users\richa\.nuget\packages\fsharp.data.sqlclient\2.0.1\lib\netstandard2.0\FSharp.Data.SqlClient.dll' reported an error: Assembly attribute 'TypeProviderAssemblyAttribute' refers to a designer assembly 'FSharp.Data.SqlClient.DesignTime.dll' which cannot be loaded or doesn't exist. Could not load file or assembly 'file:///C:\Users\richa\.nuget\packages\fsharp.data.sqlclient\2.0.1\lib\netstandard2.0\FSharp.Data.SqlClient.DesignTime.dll' or one of its dependencies. The system cannot find the file specified. [C:\repos\AuthenticationServer\src\Sse.Retail.AuthServer.Web\Sse.Retail.AuthServer.Web.fsproj]

The file mentioned is not at that location - but wasn't sure if that was expected?

Have tried with and without the workaround with fsc.props file - again unsure from recent issues whether that workaround is required or not

Related information

• Operating system Windows 10
• Branch
• Database versions and sample databases being used
• .NET Runtime, CoreCLR or Mono Version Core 2.1.403
• Editing Tools (e.g. Visual Studio Version) VsCode with Ionide

Start by reproducing the provided SqlProgrammabilityProvider example with FSharp.Data.SqlClient 2.0.1 on the stated .NET Core and Windows setup. Inspect the netstandard2.0 package contents and the fsc.props workaround in relation to the missing FSharp.Data.SqlClient.DesignTime.dll. Done means the type provider loads without FS3031 and exposes stored procedures.