Adding more than one column to a C# list from MySQL Select

Question

I am trying to put a MySQL select into a List. I found one piece of code that works, however I need to add more than one column. I want to return an array of all the data in the select.

List<string> list = (from IDataRecord r in dataReader
                     select (string)r["FieldName"]
                    ).ToList();

Code was found here: Fill an array (or arraylist) from SqlDataReader

Becuzz · Accepted Answer · 2013-03-08 21:36:19Z

2

This should do it:

var list = (from IDataRecord r in dataReader
            select new 
                   {
                        Field1 = (string)r["Field1"],
                        Field2 = (int)r["Field2"],
                         ...
                   }
            ).ToList();

Just add fields as needed.

answered Mar 8, 2013 at 21:36

Becuzz

6,86728 silver badges39 bronze badges

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

2 Comments

jason Over a year ago

It seems I have having an issue with that, I was unable to use var list, so I tried List<String> and sense the data types are not all String it throws a fit. Im guessing i need to do something such as IEnumerable, but im not sure how.. The exactly error I get with the List<String> is Cannot implicitly convert type 'System.Collections.Generic.List<AnonymousType#1>' to 'System.Collections.Generic.List<string>' it doesn't like the .ToList()

jason Over a year ago

I got it figured out now.. Thanks!

Collectives™ on Stack Overflow

Adding more than one column to a C# list from MySQL Select

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related