Filling Label with Linq using Tolist()?

Question

I have a table with the following schematics:

GarantiaImovel | imovelID | GarantiasTipos
12             |    3     | Caução2
12             |    4     | Depósito
12             |    5     | Caução2
12             |    5     | Fiador
12             |    5     | Seguro Fiança

So I have the following Query:

var garantias = (from p in db.T_GarantiasLocaticias
                         where p.imovelID == 5
                         select p.GarantiasTipos).ToList();

My intention in this Query is to return the three rows in the table above with the column GaantiasTipo, but me using the foreach and it only returns me the last line as I can return in the following structure:

foreach (var garantia in garantias)
{
     lblGarantiaLocaticias.Text = garantia + ", ";
}

How to proceed?

Answer 1

If you don’t need to make one foreach just use String.Join with the return of that expression Linnum, example:

var garantias = (from p in db.T_GarantiasLocaticias
                  where p.imovelID == 5
                  select p.GarantiasTipos)
               .ToList();

lblGarantiaLocaticias.Text = String.Join(", ", garantias);

Online Example

Observing: can even use a for or foreach or even a while, but, there is no need already seen that String.Join already makes it so transparent. Another observing is about what was happening, because it lacked accumulate the values already obtained in the interactions and that in the foreach of your question did not, in case it would only put a sign of more (+) before the same (=) (representing an addition allocation operator) and an adjustment so that in the last element there was no comma (,) in this way:

lblGarantiaLocaticias.Text = "";
foreach (var garantia in garantias)
{
     if (lblGarantiaLocaticias.Text != "") 
         lblGarantiaLocaticias.Text += ", ";
     lblGarantiaLocaticias.Text += garantia;
}

_References:

• String.Join
• String.Join(String, Ienumerable)
• String.Join (String, String[])
• dotnetperls - string-Join
• Operator += (C reference#)

Answer 2

You can use the Aggregate(...) (alias reduce):

var garantias = (from p in db.T_GarantiasLocaticias
                 where p.imovelID == 5
                 select p.GarantiasTipos)
                .ToList()
                .Aggregate(string.Empty, (actual, novo) => 
                {
                    // caso a string concatenada nao esteja vazia,
                    // adiciona o separador
                    if(!string.IsNullOrEmpty(actual)) {
                        actual += ","
                    }

                    return actual + novo;
                });

You can see an example of Aggregate here.