jwood803
2/10/2015 - 1:33 PM

Sql Provider

Sql Provider

#I "../packages/SQLProvider.0.0.9-alpha/lib/net40"
#r "FSharp.Data.SqlProvider.dll"

open FSharp.Data.Sql

type sql = SqlDataProvider<ConnectionString = @"Server=JONWOOD4DDE\SQLEXPRESS;Database=northwind;Trusted_Connection=True",
                           DatabaseVendor = Common.DatabaseProviderTypes.MSSQLSERVER,
                           UseOptionTypes = true>

let context = sql.GetDataContext()

context.``[dbo].[Categories]``.Individuals.``As CategoryName``.``1, Beverages``.Table