does not find Azure connection string when in library of Web API app

[jackfoxy]

Using Web API app derived from Dan Mohl's F# MVC5 template.

When SqlCommand compiled in main application (using App.config for connection string for local execution), it works locally and it works on an Azure website.

When SqlCommand compiled in a library project in the Solution (using App.config in the library project for connection string for local execution), it works locally, but on Azure it throws the following exception:

An exception of type 'System.Exception' occurred in FSharp.Data.Experimental.SqlCommandProvider.dll but was not handled in user code

Additional information: Connection string [connection string name] is not found.

[dmitry-a-morozov]

I think you need to use web.config both compile and run time.
SqlCommand<..., ConfigFile = "web.config">

[dmitry-a-morozov]

@jackfoxy Did you resolve the issue?

[jackfoxy]

Yep

[dmitry-a-morozov]

@jackfoxy @vasily-kirichenko I just pushed an update to nuget. I've heard complains that it's bit inconvenient to specify connection string on each SqlCommand instantiation. Now "SqlCommandProvider" is default for ConnectionStringName parameter. If combined with either App.Config or Web.Config file in design type it's enough to specify something like:

type MyQuery= SqlCommand<"SELECT * FROM MyTable">

Of course it expects following in config file

Enjoy.

[jackfoxy]

I assume the old format still works...multiple connection strings is a possible scenario.

[dmitry-a-morozov]

Correct. Should work.