Bypass Soft delete Select Filter

Is it possible to bypass the softdeleted filter and retrieve only the deleted record?

Don’t use a Typed SqlExpression so the SqlExpression filters doesn’t apply, e.g:

var record = db.SingleById<Table>(id);

Ok, but if for example I need to retrieve all record soft deleted?

Use Custom SQL, e.g:

var rows = db.Select<Table>("IsDeleted = true");
1 Like