Create Object and its Properties at Run-time from List

Question

I need to create dynamic object and its properties at run-time then create instance of this object to store values.

why I want above logic!

I am reading excel file in C# and first line of code is header which is actually properties and followed by each rows are record which is instance of dynamic object.

 List<string> ExcelDataHeader = new List<string>();
         for (int y = 2; y <= colCount; y++)
           {
             ExcelDataHeader.Add(xlRange.Cells[headerRow, y].Value2.ToString());
           }

  dynamic MyDynamic = new System.Dynamic.ExpandoObject();
    ??????????

I need to return excel read data in object

Usually you set the proerties by using MyDynamic.PropertyName = value. In your case value probably comes from the sheet, so it´s rather something like MyDynamic.PropertyName = ExcelDataHeader[3]. I don´t understand what your question is. — MakePeaceGreatAgain
– MakePeaceGreatAgain, Commented Apr 7, 2017 at 10:52
Possible duplicate of Dynamically Add C# Properties at Runtime — Clint
– Clint, Commented Apr 7, 2017 at 10:54
Why create a dynamic object? Just store your values in a Dictionary. Seems a lot simpler to me. — DavidG
– DavidG, Commented Apr 7, 2017 at 10:55

Marc Gravell · Accepted Answer · 2017-04-07 11:14:54Z

2

You could use ExpandoObject here - it'll work, but you need to use the dictionary API:

IDictionary<string, object> obj = new ExpandoObject();
obj["id"] = 123;
obj["name"] = "Fred";

// this is the "dynamic" bit:
dynamic dyn = obj;
int id = dyn.id; // 123
string name = dyn.name; // "Fred"

However, I fail to see the point. Since you won't be referring to the object in C# code by things like obj.PropertyName, dynamic has very little purpose. You might as well just store each record in a Dictionary<string,object> or similar. Given what you describe, there are no places where you would actually use MyDynamic as a dynamic object.

answered Apr 7, 2017 at 11:14

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

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

Collectives™ on Stack Overflow

Create Object and its Properties at Run-time from List

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related