Entity framework core attach/update for child objects
I'm using entity framework core 2.1 and my database context contains of the follwing classes
public class MultiStringSetting
{
public int Id { get; set; }
public virtual IEnumerable<MultiString> Values { get; set; }
}
public class MultiString
{
public int Id { get; set; }
public string Value { get; set; }
}
Consider the following: I have 3 MultiString objects in my database with id's 1, 2 and 3. My current MultiStringSetting has MultiString 1 in its Values. What i would like to do now is set the Values of my MultiStringSetting to 2 and 3, without removing MultiString 1 from my database. How can i achieve this? I tried some things like attach and update but both had no success for me.
Bonus question: What if i have the same scenario as above however i now have a list of MultiStringSetting and i want to update them all.
.net-core entity-framework-core
asked Nov 21 '18 at 16:10
GilianGilian
3211217
add a comment |
I'm using entity framework core 2.1 and my database context contains of the follwing classes
public class MultiStringSetting
{
public int Id { get; set; }
public virtual IEnumerable<MultiString> Values { get; set; }
}
public class MultiString
{
public int Id { get; set; }
public string Value { get; set; }
}
Consider the following: I have 3 MultiString objects in my database with id's 1, 2 and 3. My current MultiStringSetting has MultiString 1 in its Values. What i would like to do now is set the Values of my MultiStringSetting to 2 and 3, without removing MultiString 1 from my database. How can i achieve this? I tried some things like attach and update but both had no success for me.
Bonus question: What if i have the same scenario as above however i now have a list of MultiStringSetting and i want to update them all.
.net-core entity-framework-core
asked Nov 21 '18 at 16:10
GilianGilian
3211217
add a comment |
I'm using entity framework core 2.1 and my database context contains of the follwing classes
public class MultiStringSetting
{
public int Id { get; set; }
public virtual IEnumerable<MultiString> Values { get; set; }
}
public class MultiString
{
public int Id { get; set; }
public string Value { get; set; }
}
Consider the following: I have 3 MultiString objects in my database with id's 1, 2 and 3. My current MultiStringSetting has MultiString 1 in its Values. What i would like to do now is set the Values of my MultiStringSetting to 2 and 3, without removing MultiString 1 from my database. How can i achieve this? I tried some things like attach and update but both had no success for me.
Bonus question: What if i have the same scenario as above however i now have a list of MultiStringSetting and i want to update them all.
.net-core entity-framework-core
asked Nov 21 '18 at 16:10
GilianGilian
3211217
I'm using entity framework core 2.1 and my database context contains of the follwing classes
public class MultiStringSetting
{
public int Id { get; set; }
public virtual IEnumerable<MultiString> Values { get; set; }
}
public class MultiString
{
public int Id { get; set; }
public string Value { get; set; }
}
Consider the following: I have 3 MultiString objects in my database with id's 1, 2 and 3. My current MultiStringSetting has MultiString 1 in its Values. What i would like to do now is set the Values of my MultiStringSetting to 2 and 3, without removing MultiString 1 from my database. How can i achieve this? I tried some things like attach and update but both had no success for me.
Bonus question: What if i have the same scenario as above however i now have a list of MultiStringSetting and i want to update them all.
.net-core entity-framework-core
.net-core entity-framework-core
asked Nov 21 '18 at 16:10
GilianGilian
3211217
asked Nov 21 '18 at 16:10
GilianGilian
3211217
asked Nov 21 '18 at 16:10
GilianGilian
3211217
asked Nov 21 '18 at 16:10
GilianGilian
3211217
asked Nov 21 '18 at 16:10
GilianGilian
3211217
3211217
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I solved this problem by first getting all the objects from the database and then manually removing the objects using .Remove(). When all references are removed I then added them back with the new objects using .Add().
answered Nov 29 '18 at 11:55
GilianGilian
3211217
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2f53416147%2fentity-framework-core-attach-update-for-child-objects%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I solved this problem by first getting all the objects from the database and then manually removing the objects using .Remove(). When all references are removed I then added them back with the new objects using .Add().
answered Nov 29 '18 at 11:55
GilianGilian
3211217
add a comment |
I solved this problem by first getting all the objects from the database and then manually removing the objects using .Remove(). When all references are removed I then added them back with the new objects using .Add().
answered Nov 29 '18 at 11:55
GilianGilian
3211217
add a comment |
I solved this problem by first getting all the objects from the database and then manually removing the objects using .Remove(). When all references are removed I then added them back with the new objects using .Add().
answered Nov 29 '18 at 11:55
GilianGilian
3211217
I solved this problem by first getting all the objects from the database and then manually removing the objects using .Remove(). When all references are removed I then added them back with the new objects using .Add().
answered Nov 29 '18 at 11:55
GilianGilian
3211217
answered Nov 29 '18 at 11:55
GilianGilian
3211217
answered Nov 29 '18 at 11:55
GilianGilian
3211217
answered Nov 29 '18 at 11:55
GilianGilian
3211217
3211217
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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%2f53416147%2fentity-framework-core-attach-update-for-child-objects%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
