Problem using Dapper.SimpleSave to update complex object
I have the following two classes as part of a larger WinForms project.
[Table("Project")]
public class Project
{
[PrimaryKey]
public int? Id { get; set; }
public string Name { get; set; }
public int CustomerId { get; set; }
public string Description { get; set; }
public string Reference { get; set; }
[OneToMany]
[Column("Id")]
public List<DocumentControl> DocumentControl { get; set; }
}
and
[Table("DocumentControl")]
public class DocumentControl
{
[PrimaryKey]
public int? Id { get; set; }
public string Editor { get; set; }
public string Comment { get; set; }
public DateTime Date { get; set; }
public string Version { get; set; }
}
After retrieving an instance from my database of Project (which has NO DocumentControl entries and is returned as null), I am creating two new DocumentControl entries and adding to the object. I am then passing the object back in to Update the DB entries. However, changes made to the Project model are fine and are saved back to the DB; but the List does not contain my new entries in the database; in the POCO it is no longer null when debugging, but has a count of 0.
I use the following method to update the database
public bool UpdateProject(Project project)
{
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["Adagnitio"].ConnectionString))
{
db.Open();
var originalProject = db.AutoQuery<Project>(new { Id = project.Id }).FirstOrDefault();
db.Update<Project>(originalProject, project);
db.Close();
return true;
}
}
Why is my updated Customer object missing the DocumentControl object entries ? Been banging my head against the desk on this one. I am sure I must be missing something simple!
c# winforms orm dapper
edited Nov 21 at 6:06
JohnB
1,7271117
asked Nov 21 at 1:20
Paul Davey
528
add a comment |
I have the following two classes as part of a larger WinForms project.
[Table("Project")]
public class Project
{
[PrimaryKey]
public int? Id { get; set; }
public string Name { get; set; }
public int CustomerId { get; set; }
public string Description { get; set; }
public string Reference { get; set; }
[OneToMany]
[Column("Id")]
public List<DocumentControl> DocumentControl { get; set; }
}
and
[Table("DocumentControl")]
public class DocumentControl
{
[PrimaryKey]
public int? Id { get; set; }
public string Editor { get; set; }
public string Comment { get; set; }
public DateTime Date { get; set; }
public string Version { get; set; }
}
After retrieving an instance from my database of Project (which has NO DocumentControl entries and is returned as null), I am creating two new DocumentControl entries and adding to the object. I am then passing the object back in to Update the DB entries. However, changes made to the Project model are fine and are saved back to the DB; but the List does not contain my new entries in the database; in the POCO it is no longer null when debugging, but has a count of 0.
I use the following method to update the database
public bool UpdateProject(Project project)
{
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["Adagnitio"].ConnectionString))
{
db.Open();
var originalProject = db.AutoQuery<Project>(new { Id = project.Id }).FirstOrDefault();
db.Update<Project>(originalProject, project);
db.Close();
return true;
}
}
Why is my updated Customer object missing the DocumentControl object entries ? Been banging my head against the desk on this one. I am sure I must be missing something simple!
c# winforms orm dapper
edited Nov 21 at 6:06
JohnB
1,7271117
asked Nov 21 at 1:20
Paul Davey
528
add a comment |
I have the following two classes as part of a larger WinForms project.
[Table("Project")]
public class Project
{
[PrimaryKey]
public int? Id { get; set; }
public string Name { get; set; }
public int CustomerId { get; set; }
public string Description { get; set; }
public string Reference { get; set; }
[OneToMany]
[Column("Id")]
public List<DocumentControl> DocumentControl { get; set; }
}
and
[Table("DocumentControl")]
public class DocumentControl
{
[PrimaryKey]
public int? Id { get; set; }
public string Editor { get; set; }
public string Comment { get; set; }
public DateTime Date { get; set; }
public string Version { get; set; }
}
After retrieving an instance from my database of Project (which has NO DocumentControl entries and is returned as null), I am creating two new DocumentControl entries and adding to the object. I am then passing the object back in to Update the DB entries. However, changes made to the Project model are fine and are saved back to the DB; but the List does not contain my new entries in the database; in the POCO it is no longer null when debugging, but has a count of 0.
I use the following method to update the database
public bool UpdateProject(Project project)
{
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["Adagnitio"].ConnectionString))
{
db.Open();
var originalProject = db.AutoQuery<Project>(new { Id = project.Id }).FirstOrDefault();
db.Update<Project>(originalProject, project);
db.Close();
return true;
}
}
Why is my updated Customer object missing the DocumentControl object entries ? Been banging my head against the desk on this one. I am sure I must be missing something simple!
c# winforms orm dapper
edited Nov 21 at 6:06
JohnB
1,7271117
asked Nov 21 at 1:20
Paul Davey
528
I have the following two classes as part of a larger WinForms project.
[Table("Project")]
public class Project
{
[PrimaryKey]
public int? Id { get; set; }
public string Name { get; set; }
public int CustomerId { get; set; }
public string Description { get; set; }
public string Reference { get; set; }
[OneToMany]
[Column("Id")]
public List<DocumentControl> DocumentControl { get; set; }
}
and
[Table("DocumentControl")]
public class DocumentControl
{
[PrimaryKey]
public int? Id { get; set; }
public string Editor { get; set; }
public string Comment { get; set; }
public DateTime Date { get; set; }
public string Version { get; set; }
}
After retrieving an instance from my database of Project (which has NO DocumentControl entries and is returned as null), I am creating two new DocumentControl entries and adding to the object. I am then passing the object back in to Update the DB entries. However, changes made to the Project model are fine and are saved back to the DB; but the List does not contain my new entries in the database; in the POCO it is no longer null when debugging, but has a count of 0.
I use the following method to update the database
public bool UpdateProject(Project project)
{
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["Adagnitio"].ConnectionString))
{
db.Open();
var originalProject = db.AutoQuery<Project>(new { Id = project.Id }).FirstOrDefault();
db.Update<Project>(originalProject, project);
db.Close();
return true;
}
}
Why is my updated Customer object missing the DocumentControl object entries ? Been banging my head against the desk on this one. I am sure I must be missing something simple!
c# winforms orm dapper
c# winforms orm dapper
edited Nov 21 at 6:06
JohnB
1,7271117
asked Nov 21 at 1:20
Paul Davey
528
edited Nov 21 at 6:06
JohnB
1,7271117
asked Nov 21 at 1:20
Paul Davey
528
edited Nov 21 at 6:06
JohnB
1,7271117
edited Nov 21 at 6:06
JohnB
1,7271117
edited Nov 21 at 6:06
JohnB
1,7271117
1,7271117
asked Nov 21 at 1:20
Paul Davey
528
asked Nov 21 at 1:20
Paul Davey
528
asked Nov 21 at 1:20
Paul Davey
528
528
add a comment |
add a comment |
active
oldest
votes
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%2f53403997%2fproblem-using-dapper-simplesave-to-update-complex-object%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53403997%2fproblem-using-dapper-simplesave-to-update-complex-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
