Query expressions about dapper.fsharp

[Dzoukr]

I like it.

I was imagining that the expression based select CE could require opening a separate namespace.

Yup, that's the way IMO. I think a separate module would be great.

[Dzoukr]

Hmmmm. 🤔 Sounds interesting. Please, could you provide a short sample of how it would look like before I take a decision on this? I tend to have this library as simple as possible (for known reasons), but don't want to kill a good idea which could be a great "addon-to-an-addon" 😄

[JordanMarr]

Sure!

Given this example:

select {
    table "Persons"
    where (gt "Position" 5 + lt "Position" 10)
} |> conn.SelectAsync<Person>

I was imagining something like this:

select {
    for p in tbl<Persons>()
    where (p.Position > 5 && p.Position < 10)
    orderBy p.LName
} |> conn.SelectAsync<Persons>

SqlHydra names records after the table and properties after the columns, so they should already match.
(The tbl<Persons>() is off the top of my head. There may be a cleaner way to do that. In fact it could maybe even just be tbl since the entity type can be inferred via conn.SelectAsync<Persons>.)

I was imagining that the expression based select CE could require opening a separate namespace.

That's the idea at least.. Of course all of this would need to pass a proof of concept phase on a very simple query before tackling the full query expression tree.