title: Best way to join list with DbSet Under Different Circumstances
body: <p>maybe this is a duplicate but basically I want to know what is the best way to join a in memory list/ienumerable to a dbset under different circumstances.</p>
  
  <p>The circumstances are:</p>
  
  <ol>
  <li><p>List/Ienumerable is small, dbset is small</p></li>
  <li><p>List/Ienumerable is small, dbset is big</p></li>
  <li><p>List/Ienumerable is big, dbset is small</p></li>
  <li><p>List/Ienumerable is big, dbset is big</p></li>
  </ol>