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.

Multiple items
type LiteralAttribute =
  inherit Attribute
  new : unit -> LiteralAttribute

Full name: Microsoft.FSharp.Core.LiteralAttribute

--------------------
new : unit -> LiteralAttribute
val connectionString : string

Full name: Oracle.connectionString
val resolutionPath : string

Full name: Oracle.resolutionPath
namespace Microsoft.FSharp
namespace Microsoft.FSharp.Data
type sql = obj

Full name: Oracle.sql
val ctx : obj

Full name: Oracle.ctx
val customers : obj []

Full name: Oracle.customers
module Seq

from Microsoft.FSharp.Collections
val toArray : source:seq<'T> -> 'T []

Full name: Microsoft.FSharp.Collections.Seq.toArray
Fork me on GitHub