Bypass Soft delete Select Filter

Gianmaria · May 10, 2019, 9:02am

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

mythz · May 10, 2019, 9:09am

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

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

Gianmaria · May 10, 2019, 9:11am

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

mythz · May 10, 2019, 9:16am

Use Custom SQL, e.g:

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