Databases
StackOverflow2013
Postsdbo
POUpdating a record using Entity Framework context without manually setting properties
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUpdating a record using Entity Framework context without manually setting properties
    primarykey
    data
    text
    <p>I am trying to update a record using Entity Framework but want to avoid manually setting each property and then calling save changes. I have an instance of this class bound to a dataform that updates all its properties as a user changes them. The nicest way I can see using this would be to set the object in the context equal to the object bound to my dataform but this does not work. I tried removing the object from the context then adding the dataform bound object but it creates a completely new record (I expected this but decided it was worth a shot to try it out). I assume there is some type of flag with in the context that is used to detect if a record is a new row or not considering the fact that replacing the context object with the databound object (which has the same pk value) does not work.</p> <pre><code>using (var scope = new TransactionScope()) { try { using (var context = new CIS_DEVEntities()) { GangMemberBio bio = context.GangMemberBios.First(P =&gt; P.id == this.id); bio = this; //this does not work. context.SaveChanges(); } //If the top code is successfully completed then the transaction will be commited //if not this line will be skipped and execution will be given to the catch block scope.Complete(); } catch { } } </code></pre> <p><strong>Edit Idea 1</strong> I was thinking I could create a context object on my wpf window itself and then bind the dataform to my gangmemberbio object retrieved from this context. Then when I call save changes nothing else needs to be done. I heard that having a datacontext in memory is bad though.. Or is it just bad if I use it outside the context of a using statement?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAdrian
    1. USAdrian
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUpdating a record using Entity Framework context without manually setting properties
      1. USAdrian
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload