Linq Insert with string variable column name

Question

I want to pass a column name and value to a function that will update a table using LINQ.

I have the code below but don't know how to implement the string variable column name

private static void update(string key, string value)
    {
        AccessToken accessToken = new AccessToken();

        accessToken.<key variable should go here> = value;

        QBAccessTokensDataContext db = new QBAccessTokensDataContext();
        db.AccessTokens.InsertOnSubmit(accessToken);
        db.SubmitChanges();

    }

See [here](https://stackoverflow.com/questions/1196991/get-property-value-from-string-using-reflection-in-c-sharp) for accessing a property in C# at runtime with reflection. — Ned Howley, Jul 28 '17 at 14:51
Is AccessToken a dictionary or dictionary like where you can do this `accessToken[key]=value;`? — Robert McKee, Jul 28 '17 at 15:11
@RobertMcKee yes, I'm updating the values of a dictionary to a db — Shazoo, Jul 28 '17 at 15:32

score 0 · Answer 1 · answered Jul 28 '17 at 14:55

0

Add one more property to your class AccessToken with Key name and store the value

answered Jul 28 '17 at 14:55

karthik kasubha

392
2
13

Linq Insert with string variable column name

1 Answers1