LINQ Dynamically Select Column From Column Name

Question

I made this query to get data from a table

List<MyTable> liDeatil = Db.Database.SqlQuery<MyTable>("SELECT * FROM [myDB].[dbo].[MyTable]").ToList();

From liDetail i want to select column dynamically such as

 liDeatil.Select(s => new myclass{ Id = s.Id ,Marks = ....}).Tolist();

Where MyClass is

 public class MyClass
 {
     public Nullable<decimal> Id { get; set; }
     public string Marks { get; set; }
     public string rank { get; set; }
 }

is there any way to get the column pls help me
I tried To do this by reflection But its not working

var ss = liDeatil.Select(s => new MyClass{ Id = s.Id ,Marks = s.GetType().GetProperties("ColumnMarks")}).Tolist();

EDITED

     public class MyTable
     {
         public Nullable<decimal> Id { get; set; }
         public string ColumnMarks{ get; set; }
         public string ColumnMarks1{ get; set; }
         public string ColumnMarks2{ get; set; }
     }

what do you mean by "From liDetail i want to select column dynamically"? — Victor Mukherjee
– Victor Mukherjee, Commented Oct 23, 2013 at 13:09
in Select statement i want to select ColumnMarks From liDetail — Amit Bisht
– Amit Bisht, Commented Oct 23, 2013 at 13:10

Victor Mukherjee · Accepted Answer · 2013-10-23 13:18:47Z

7

From what you are trying to achieve with reflection, below code should work:

var ss = liDeatil.Select(s => new MyClass{ Id = s.Id ,
Marks = (string)s.GetType().GetProperty("ColumnMarks").GetValue(s,null)}).Tolist();

edited Oct 23, 2013 at 13:18

answered Oct 23, 2013 at 13:13

Victor Mukherjee

11.3k20 gold badges61 silver badges104 bronze badges

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

1 Comment

Victor Mukherjee Over a year ago

I have edited my code, try with "GetProperty("ColumnMarks")" instead of "GetProperties("ColumnMarks")"

Dude0001 · Accepted Answer · 2013-10-23 13:21:53Z

3

What isn't working exactly? Are you getting an exception? I'm confused where you are getting "ColumnMarks" from. You didn't post the definition for MyTable, so maybe it is from there.

liDeatil.Select(s => new myclass{ Id = s.Id, Marks = (string)s.GetType().GetProperty("ColumnMarks").GetValue(s, null)}).Tolist();

edited Oct 23, 2013 at 13:21

answered Oct 23, 2013 at 13:15

Dude0001

3,4942 gold badges28 silver badges44 bronze badges

2 Comments

Amit Bisht Over a year ago

i HAD EDITED MY QUESTION

Dude0001 Over a year ago

This answer or Victor's below should work then. You need to call GetValue once you get the property via reflection.

Collectives™ on Stack Overflow

LINQ Dynamically Select Column From Column Name

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related