How to foreach in each select using EF6?

Question

Follows the code:

var list = new List<String>();
list.Add("Casa");
list.Add("Apartamento");

var connection = ctx.Table.Where(x => x.Tipo== list).ToList();

My database:

+=============================================+
|      Tipo     |    TBName   |    Número     |
+=============================================+
| Sandwich Type | Turkey Club |            10 |
| Casa          | Italian     |             5 |
| Casa          | Garlic      |             8 |
+---------------------------------------------+

Answer 1

The solution I found was:

First you list everything and then you apply the filter.

var list = new List<String>();
list.Add("Casa");
list.Add("Apartamento");

var connection = ctx.Table.ToList().Where(x =>list.Contains(x.Tipo)).ToList();