SQL ‘IN’ clause when using Linq to Entities (use it the right way!)

We all know what ‘IN’ clause is about – we want records where a field value matches one of the specified variants. Let’s imagine the following model although it may seem artificial at first but it actually reflects a situation you can find in a goods tracking software: »

on SQL