Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Select Multiple elements in a row using Linq

Tags:

c#

.net

linq

My Code is as follows

var users = MyTable.AsEnumerable()
                      .Select(x => new { x.Field<string>("Col1"),x.Field<string>  
                       ("Col2")}).ToList();

On compiling I get

Invalid anonymous type member declarator. Anonymous type members must be declared with a member assignment, simple name or member access.

like image 680
Rohit Avatar asked Mar 08 '13 06:03

Rohit


2 Answers

You need to give a name to each of the fields in the anonymous type

var users = MyTable.AsEnumerable()
  .Select(x => 
     new { Col1 = x.Field<string>("Col1"), Col2 = x.Field<string>("Col2")})
  .ToList();

The only time the name of an anonymous type field can be omitted is when the expression itself is a simple name that the compiler can use. For example if the expression is a field or property then the name can be omitted. In this case the expression is a generic method call and has no name the compiler will use

like image 84
JaredPar Avatar answered Dec 16 '22 07:12

JaredPar


Try this:

var users = MyTable.AsEnumerable()
                      .Select(x => new
                      {
                        Col1 = x.Field<string>("Col1"),
                        Col2 = x.Field<string>("Col2")})
                        .ToList();
like image 28
Matt Avatar answered Dec 16 '22 07:12

Matt