SQLProvider


SQL Provider for Oracle

Oracle is based on the current release (12.1.0.1.2) of the managed ODP.NET driver found here. However although the managed version is recommended it should also work with previous versions of the native driver.

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
#r "FSharp.Data.SqlProvider.dll"

open FSharp.Data.Sql

type sql = SqlDataProvider<Common.DatabaseProviderTypes.ORACLE, connectionString, ResolutionPath = resolutionPath>
let ctx = sql.GetDataContext()

let customers = ctx.Customers |> Seq.toArray

Because Oracle databases can be huge, there is an optional constructor parameter TableNames that can be used as a filter.

Fork me on GitHub