Entity Framework Core PostgreSQL EF.Functions.JsonTypeof

Question

.Where(e => EF.Functions.JsonTypeof(e.Customer.GetProperty("Age")))

This syntax in https://www.npgsql.org/efcore/mapping/json.html?tabs=data-annotations%2Cjsondocument not works!! show this error: cannot implicitly convert "string" to "bool"

Ivan Stoev · Accepted Answer · 2020-05-25 16:17:15Z

1

The sample syntax from the link is simply incomplete. JsonTypeof returns string an according to the link is mapped to jsonb_typeof which

Returns the type of the outermost JSON value as a text string. Possible types are object, array, string, number, boolean, and null.

So the correct sample usage in Where clause would compare the return value of the method to a string containing one of the aforementioned values, for instance

.Where(e => EF.Functions.JsonTypeof(e.Customer.GetProperty("Age")) == "number")

answered May 25, 2020 at 16:17

Ivan Stoev

208k17 gold badges356 silver badges376 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shay Rojansky Over a year ago

Thanks @ivan-stoev, I've pushed a fix to the doc sample.

Ivan Stoev Over a year ago

@jrocha76 Then you simply need different function - EF.Functions.JsonExists, with sample usage from the link .Where(e => EF.Functions.JsonExists(e.Customer, "Age")

Collectives™ on Stack Overflow

Entity Framework Core PostgreSQL EF.Functions.JsonTypeof

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related