Hello friends.

I am looking at an entity framework execute query code block that basically takes in a list of values, compares those to existing values using the sql command “in” and updates a field on the records that exist in the database and not in the provided list.

Basically if it’s not in the list, flag it as removed.

Only problem is this chokes up at around 1000 entries in the list and times sql out.

If there a better wya to do this using entity framework or should I move it over to a stored proc and just be done with it?

Thanks