SqlFile type provider

[dmitry-a-morozov]

Description

There are numerous issues associated with built-in ability to pass *.sql file name as command text to SqlCommandProvider and SqlProgrammabilityProvider.CreateCommand
See
#163
#123

I propose to introduce dedicated SqlFile generative type provider that will return content of sql file as literal string. It is related to fsprojects/FSharp.Management#71 but there are benefits having our own version of it for several reasons:

• It has't not been implemented in FSharp.Management lib yet
• We have a reason (see below) to implement it as generative not erased. On other side erased implementation probably makes more sense for FSharp.Management
• extra dependency might not be justifiable in this case

Expected behavior

type MyQuery = SqlFile<"myfile.sql">
do
    use cmd = SqlCommandProvider<MyQuery.Text, "Server=.;Database=AdventureWorks2012;Trusted_Connection=yes">
    cmd.Execute ...
    ...

• Text is literal property on type generated by SqlFile type provider
• By making SqlFile generative type provider I hope to address External SQL files in referenced libraries does not work if not copied to the referencing library #123

Related information

[smoothdeveloper]

👍

Can we close this, this is implemented in recent versions and is working great!