Linq - Updating dynamic column

Question

I want to update a column which is dynamic. In my employee table I have various columns, which column to update depends on selection so it is dynamic.

In employee table, I have 5 columns - Id, name, desig, depart, Sal

So in case I have to update desig column :-

string columnName = "desig"; // This comes as a parameter. This is a dynamic Value. This is just an example.

var data = ctx.tblEmp.Where(e => e.Id == model.Id).Select(e => e).SingleOrDefault();

data.desig = 'NewValue';

ctx.tblEmp.Attach(data);
...
ctx.SaveChanges();

Is there a problem you're experiencing? Aside from the single quotes around `'NewValue';` likely failing to compile I'm not sure what you're asking. — clarkitect, Oct 07 '14 at 05:47
Also I'd like to suggest that you could greatly simplify your data access to this: `var data = ctx.tblEmp.SingleOrDefault(e => e.Id == model.Id);` — clarkitect, Oct 07 '14 at 05:48

Ofiris · Accepted Answer · 2014-10-07T05:59:53.133

1

Since there are only 5 constant columns, I would go with the simple solution:

var data = ctx.tblEmp.SingleOrDefault(e => e.Id == model.Id);
switch (columnName)
{
    case "Id":
       data.id = newValue; //newValue should have a correct type.
       break;
    case "name": 
       data.name = newValue; 
       break;
    case "desig":
       data.desig = newValue; 
       break;
    case "depart":
       data.depart = newValue; 
       break;
    case "Sal":
       data.Sal = newValue; 
       break;
}

edited Oct 07 '14 at 05:59

answered Oct 07 '14 at 05:52

Ofiris

6,047
6
35
58

Indeed there are more columns in my table...But i will go with this strategy..! – Anup Oct 07 '14 at 06:02
Ok, note that if you had many columns or many tables, Reflection could help: http://stackoverflow.com/questions/1196991/get-property-value-from-string-using-reflection-in-c-sharp – Ofiris Oct 07 '14 at 06:12

Linq - Updating dynamic column

1 Answers1