Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- let myQuery =
- query{
- for row in db.StuffTable do
- select row
- }
- let result =
- myQuery
- |> Seq.filter (fun x -> x.fkTable.contains( y.IsComplete = false ) // this obviously doesn't work
- let reuslt =
- query{
- for pkRow in pkTable do
- for fkRow in fkTable do
- where (fkRow.IsComplete = false)
- select pkRow
- }
- let result = query {
- for fkRow in db.FkTable do
- join pkRow in db.PkTable on (fkRow.FkColumn = pkRow.PkColumn)
- where (pkRow.IsComplete = false)
- select fkRow
- }
- let result = query {
- for fkRow in db.FkTable do
- join pkRow in db.PkTable on (1 = 1)
- where (pkRow.IsComplete = false)
- select fkRow
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement