Can't query table with optional key about dapper.fsharp HOT 11 CLOSED

Incoming PR...

from dapper.fsharp.

It looks like you are joining on an Option property.
Try this:
on (Some ez.KstStelle = erz.USER_KstUebergeordnet)

from dapper.fsharp.

I now get following error message:

Could not get data "The method or operation is not implemented.

from dapper.fsharp.

I guess that error message comes from here:

from dapper.fsharp.

Ah ok, you found a bug then.
the bug is that Option types are only unwrapped in the where statement expressions.
It should be a pretty easy fix though.

from dapper.fsharp.

Fixed in v2.0.1 thanks to @JordanMarr 👏

from dapper.fsharp.

Ahh thanks. Just wanted to sent a PR in as well^^ But yours is even better

from dapper.fsharp.

Awesome works! Thanks for the help!

from dapper.fsharp.

Ahh thanks. Just wanted to sent a PR in as well^^ But yours is even better

Well it just occurred to me that group by probably has the same problem, so feel free to a unit test for groupBy and groupByMany that takes an Option type.

from dapper.fsharp.

Actually there is no groupByMany, just groupBy which can take a tuple, and it does indeed need the same fix if you’re up for it. (Let me know).

Also the xml doc comment for groupBy is wrong on the select builder.

from dapper.fsharp.

FYI, I just checked and groupBy worked fine with option types (I added a new unit test to make sure). So no other fix is needed.

from dapper.fsharp.