CODEWITHSUNDEEP
c#linqvisual-studio-2012dynamic-linq
Amit Bisht
Amit Bisht

Reputation: 5136

LINQ Dynamically Select Column From Column Name

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; }
     }

Upvotes: 2

Views: 13040

Answers (2)

Dude0001
Dude0001

Reputation: 3450

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();

Upvotes: 3

Victor Mukherjee
Victor Mukherjee

Reputation: 11065

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();

Upvotes: 7

Related Questions