Providing connection string to Linq-To-Sql data provider

dataprovider, f#, f#-3.0, linq-to-sql

Solution

The type provider itself requires a hard-coded connection string for generating the type (in your case `SqlConnection`) to develop against at compile time, but, you can configure the actual connection string used at runtime like so:

type SqlConnection = SqlDataConnection<"Data Source=PCSQLEXPRESS;Initial Catalog=NortwindDB;Integrated Security=True">
let runtimeConnStr = ...
type dataContext = SqlConnection.GetDataContext(runtimeConnStr)

Problem

Is there a way to provide a connection string to Linq-To-Sql data provider in F# from App.Config file. I have tried the following just for testing: ``` let mutable connString = @"Data Source=PCSQLEXPRESS;Initial Catalog=NortwindDB;Integrated Security=True" type SqlConnection = SqlDataConnection<ConnectionString = connString> ``` but I get an error message "This is not a constant expression or valid custom attribute value" Thanks

Original source