Keith
February 23, 2021, 9:07pm
2
I noticed the solution to another question, and also making my RequestDto’s closed property nullable solved my problem: false and true values are handled correctly
public bool? Closed { get; init; }
We do face a problem using the implicit AutoQuery poco declaration with boolean values. SQlite is used as DBMS. We know, that this DBMS does not support a native boolean type (INTEGER is used instead).
If we us following Autoquery poco the query does only retrieve valid results in the ‘true’ or ‘1’ assignement case.
Filtering for 'false" or ‘0’ values, it does fail. Debug log shows, that no query is processed in the service stack service.
public partial class QueryXrays
: QueryDb, IMeta
{
…
2 Likes