SetValue on Linq2Sql Object
up vote
0
down vote
favorite
Is it possible to use reflection or expressions to modify a Linq2Sql object?
As a simple example that will not work:
MyDataClassDataContext db = new MyDataClassDataContext();
var actionData = (from ac in db.Actions where ac.ActionID == action.ActionID select ac).First();
var property = typeof(Action).GetProperty("ActionID");
property.SetValue(33, actionData);
...
db.SubmitChanges();
db.Dispose();
c# sql reflection setvalue
edited Nov 17 at 19:41
Community♦
11
asked Jan 21 '15 at 0:02
tic
1,009819
add a comment |
up vote
0
down vote
favorite
Is it possible to use reflection or expressions to modify a Linq2Sql object?
As a simple example that will not work:
MyDataClassDataContext db = new MyDataClassDataContext();
var actionData = (from ac in db.Actions where ac.ActionID == action.ActionID select ac).First();
var property = typeof(Action).GetProperty("ActionID");
property.SetValue(33, actionData);
...
db.SubmitChanges();
db.Dispose();
c# sql reflection setvalue
edited Nov 17 at 19:41
Community♦
11
asked Jan 21 '15 at 0:02
tic
1,009819
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Is it possible to use reflection or expressions to modify a Linq2Sql object?
As a simple example that will not work:
MyDataClassDataContext db = new MyDataClassDataContext();
var actionData = (from ac in db.Actions where ac.ActionID == action.ActionID select ac).First();
var property = typeof(Action).GetProperty("ActionID");
property.SetValue(33, actionData);
...
db.SubmitChanges();
db.Dispose();
c# sql reflection setvalue
edited Nov 17 at 19:41
Community♦
11
asked Jan 21 '15 at 0:02
tic
1,009819
Is it possible to use reflection or expressions to modify a Linq2Sql object?
As a simple example that will not work:
MyDataClassDataContext db = new MyDataClassDataContext();
var actionData = (from ac in db.Actions where ac.ActionID == action.ActionID select ac).First();
var property = typeof(Action).GetProperty("ActionID");
property.SetValue(33, actionData);
...
db.SubmitChanges();
db.Dispose();
c# sql reflection setvalue
c# sql reflection setvalue
edited Nov 17 at 19:41
Community♦
11
asked Jan 21 '15 at 0:02
tic
1,009819
edited Nov 17 at 19:41
Community♦
11
asked Jan 21 '15 at 0:02
tic
1,009819
edited Nov 17 at 19:41
Community♦
11
edited Nov 17 at 19:41
Community♦
11
edited Nov 17 at 19:41
Community♦
11
11
asked Jan 21 '15 at 0:02
tic
1,009819
asked Jan 21 '15 at 0:02
tic
1,009819
asked Jan 21 '15 at 0:02
tic
1,009819
1,009819
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
That should work, but you must call the Update method explicitly, not only SubmitChanges() since linq2db does not track changes
answered Jan 23 '15 at 0:22
OK HOSTING
406
Apologies, I should have written that it fails on theSetValue. It says that33is not the same type. This is just an example, but in this example, both33andActionIDare both int (Both non-nullable), andactionData.ActionID = 33;works fine
– tic
Jan 28 '15 at 17:48
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
That should work, but you must call the Update method explicitly, not only SubmitChanges() since linq2db does not track changes
answered Jan 23 '15 at 0:22
OK HOSTING
406
Apologies, I should have written that it fails on theSetValue. It says that33is not the same type. This is just an example, but in this example, both33andActionIDare both int (Both non-nullable), andactionData.ActionID = 33;works fine
– tic
Jan 28 '15 at 17:48
add a comment |
up vote
0
down vote
That should work, but you must call the Update method explicitly, not only SubmitChanges() since linq2db does not track changes
answered Jan 23 '15 at 0:22
OK HOSTING
406
Apologies, I should have written that it fails on theSetValue. It says that33is not the same type. This is just an example, but in this example, both33andActionIDare both int (Both non-nullable), andactionData.ActionID = 33;works fine
– tic
Jan 28 '15 at 17:48
add a comment |
up vote
0
down vote
up vote
0
down vote
That should work, but you must call the Update method explicitly, not only SubmitChanges() since linq2db does not track changes
answered Jan 23 '15 at 0:22
OK HOSTING
406
That should work, but you must call the Update method explicitly, not only SubmitChanges() since linq2db does not track changes
answered Jan 23 '15 at 0:22
OK HOSTING
406
answered Jan 23 '15 at 0:22
OK HOSTING
406
answered Jan 23 '15 at 0:22
OK HOSTING
406
answered Jan 23 '15 at 0:22
OK HOSTING
406
406
Apologies, I should have written that it fails on theSetValue. It says that33is not the same type. This is just an example, but in this example, both33andActionIDare both int (Both non-nullable), andactionData.ActionID = 33;works fine
– tic
Jan 28 '15 at 17:48
add a comment |
Apologies, I should have written that it fails on theSetValue. It says that33is not the same type. This is just an example, but in this example, both33andActionIDare both int (Both non-nullable), andactionData.ActionID = 33;works fine
– tic
Jan 28 '15 at 17:48
Apologies, I should have written that it fails on the
SetValue. It says that 33 is not the same type. This is just an example, but in this example, both 33 and ActionID are both int (Both non-nullable), and actionData.ActionID = 33; works fine– tic
Jan 28 '15 at 17:48
Apologies, I should have written that it fails on the
SetValue. It says that 33 is not the same type. This is just an example, but in this example, both 33 and ActionID are both int (Both non-nullable), and actionData.ActionID = 33; works fine– tic
Jan 28 '15 at 17:48
add a comment |
draft saved
draft discarded
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f28057427%2fsetvalue-on-linq2sql-object%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
