LINQ C# select multiple columns by names in arrays

Question

Is it possible to select columns by names or indexes, which are stored in array?

String[] columnsWhichINeed = new String[] { "column1", "column2" };

DataColumn[] aCols = dataTable.Columns.Cast<DataColumn>()
          .Where(c => c.ColumnName.NEEDSOMEMAGICHERE;
          .Select(c => new DataColumn(c.ColumnName, c.DataType))
          .ToArray();

Rahul · Accepted Answer · 2016-09-02 21:53:53Z

3

You can probably use Contains() method like

.Where(c => columnsWhichINeed.Contains(c.ColumnName));

answered Sep 2, 2016 at 21:53

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

itsme86 · Accepted Answer · 2016-09-02 21:54:43Z

0

I think what you're looking for is Contains():

DataColumn[] aCols = dataTable.Columns.Cast<DataColumn>()
      .Where(c => columnsWhichINeed.Contains(c.ColumnName))
      .Select(c => new DataColumn(c.ColumnName, c.DataType))
      .ToArray();

unless you need to do case-insensitive string matching, in which case you'll need Any():

DataColumn[] aCols = dataTable.Columns.Cast<DataColumn>()
      .Where(c => columnsWhichINeed.Any(c2 => string.Compare(c.ColumnName, c2, true) == 0))
      .Select(c => new DataColumn(c.ColumnName, c.DataType))
      .ToArray();

answered Sep 2, 2016 at 21:54

itsme86

19.6k4 gold badges44 silver badges60 bronze badges

Collectives™ on Stack Overflow

LINQ C# select multiple columns by names in arrays

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related