How can I display the result of the queries from this video inside a console app in Visual Studio?

I got your request.

I'm used to using Entity Framework where you deal with the database in a way where results come back in an object which has properties that represent the various columns returned by the query.. There are several courses here covering the use of EF.

But you can also make queries using a more fundamental mechanism involving a Command Object. Then you can retrieve the results with an Execution Reader or Table Adapter. See this MSDN page on How to Create and Execute an SQL Statement that Returns Rows.

https://docs.microsoft.com/es-es/aspnet/core/data/ef-mvc/ Is a good page to look!

All I want is to print to Console Window this query:

var groupedBirds = birds.GroupBy(b => b.Color);

But if I try to print it with the foreach loop I get this result:

System.Linq.Lookup'2+Grouping[System.String,Aggregates.Bird] System.Linq.Lookup'2+Grouping[System.String,Aggregates.Bird] System.Linq.Lookup'2+Grouping[System.String,Aggregates.Bird] System.Linq.Lookup'2+Grouping[System.String,Aggregates.Bird] System.Linq.Lookup'2+Grouping[System.String,Aggregates.Bird]

I want to get the same result (or at least similar) in the Console Window as Carling gets in the Aggregates tutorial in REPL.

Any ideeas?

Thanks in advance.

Hi Radu !!! Version English --> https://docs.microsoft.com/en-us/aspnet/core/data/ef-mvc/ Cheers!

Found my solution. I just needed two foreach, one inside the other:

foreach (var g in groupedBirds) { Console.WriteLine(g.Key); foreach (var ge in g) { Console.WriteLine(ge); }

        }

My question was related on the Aggregates tutorial from Linq Queries. I wanted to display the results for those specific queries from the Aggregates tutorial. I apologize if my original question seemed ambiguous, but English is not my first language. Many thanks for your replies.