C# Web API and SQL server global where clause

Question

So i'm trying to implement a soft delete feature, and I have a DeletedAt field in almost all of my tables. My problem now is since this feature is not native to Web API, I would have to put a where clause of DeletedAt == null in all of my queries. My question would be, is there a way to put this where clause globally either in Web API or maybe if it's also possible from SQL Server?

Are you using EF?

Mihail Stancescu
– Mihail Stancescu

2017-11-25 08:00:11 +00:00
Commented Nov 25, 2017 at 8:00 — Mihail Stancescu
– Mihail Stancescu, Commented Nov 25, 2017 at 8:00
Yes I am using EF.

Jed
– Jed

2017-11-26 06:29:41 +00:00
Commented Nov 26, 2017 at 6:29 — Jed
– Jed, Commented Nov 26, 2017 at 6:29

Prateek Pandey · Accepted Answer · 2017-11-25 08:08:52Z

2

I hope you are using Entity Framework. You can add a global filter at OnModelCreating event by adding a discriminator like:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
   modelBuilder.Entity<Foo>().Map(m => m.Requires("DeletedAt").HasValue(false));
   modelBuilder.Entity<Bar>().Map(m => m.Requires("DeletedAt").HasValue(false)); 
}

OR

You can use this package: https://github.com/zzzprojects/EntityFramework.DynamicFilters

answered Nov 25, 2017 at 8:08

Prateek Pandey

8636 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jed Over a year ago

Yes I am using EF, will try that later.

Jed Over a year ago

Tried your answer. Do I need to update migrations or anything? Cause I get the following error:

Schema specified is not valid. Errors: error 2019: Member Mapping specified is not valid. The type 'Edm.DateTime[Nullable=True,DefaultValue=,Precision=]' of member 'DeletedAt' in type 'MyModel' is not compatible with 'SqlServer.bit[Nullable=True,DefaultValue=]' of member 'DeletedAt' in type 'CodeFirstDatabaseSchema.MyModel'.

Collectives™ on Stack Overflow

C# Web API and SQL server global where clause

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related