I’ve implemented a softdelete select filter as specified in your documentation, but when i do certain queries I get an error due to some issues with the sql statement that’s emitted. Example is below:
Error
“42601: syntax error at or near “:””
Sql Statement Emitted:
{SELECT "errortype", Count(*) AS "total" FROM "foo"WHERE (("importid" = $1) AND ("isprocessed" = $2)) AND ("deleted" <> :2)GROUP BY "errortype"}
SoftDelete Setup:
OrmLiteConfig.SqlExpressionSelectFilter = q =>
{
if (q.ModelDef.ModelType.HasInterface(typeof(IBaseModel)))
{
q.Where<IBaseModel>(x => x.Deleted != true);
}
};
Query:
var q = Db.From<Foo>()
.Where(x => x.ImportId == importId && x.IsProcessed == isProcessed)
.GroupBy(x => x.ErrorType)
.Select(x => new { x.ErrorType, Total = Sql.As(Sql.Count("*"), "Total") });
return Db.Dictionary<int, long>(q);