SQLProvider


Individuals

Find individual rows in tables with code completion in the editor.

 1: 
 2: 
 3: 
 4: 
 5: 
 6: 
 7: 
 8: 
 9: 
10: 
11: 
open System
open FSharp.Data.Sql

type sql = SqlDataProvider<Common.DatabaseProviderTypes.SQLITE,
                           connectionString,
                           ResolutionPath = resolutionPath,
                           CaseSensitivityChange = Common.CaseSensitivityChange.ORIGINAL>

let ctx = sql.GetDataContext()

let customers = ctx.Main.Customers

Get individual customer row by primary key value

1: 
customers.Individuals.COMMI

Get individual customer row using address

1: 
customers.Individuals.``As ContactName``.``COMMI, Pedro Afonso``

Get individual customer row using address

1: 
customers.Individuals.``As Address``.``CONSH, Berkeley Gardens 12  Brewery``
Fork me on GitHub