npgsql
Translate range operators
How would I make use of the range operators in PostgreSQL when querying using Entity Framework? The closest I've seen are the static functions of NsgsqlTextFunctions (e.g. QueryContains), but these seem to only apply the operators to strings, not to ranges (or any other type than might using these operators for that matter)
Entity Framework 6 is very limited with respect to exotic features that only exist in some particular databases. If you use that framework you need to stick to the basic comparison operators.
It may be possible to create static functions (such as the ones in NpgsqlTextFunctions) which would be translated to the appropriate PostgreSQL operators. While this is definitely possible in EF Core, I'm not sure if EF6 allows function->operator translation. In any case this isn't implemented at the moment.
