Databases
StackOverflow2013
Postsdbo
POUpdate object in Entity Framework 4.Do you need to fetch first all the time?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUpdate object in Entity Framework 4.Do you need to fetch first all the time?
    primarykey
    data
    text
    <p>I might be totally wrong but a simple insert and update using EF4 is driving me insane.(Novice in EF)</p> <p>I have created a noddy project and uploaded here</p> <p><a href="http://cid-9db5ae91a2948485.office.live.com/browse.aspx/PublicFolder?uc=1http://cid-9db5ae91a2948485.office.live.com/browse.aspx/PublicFolder?uc=1" rel="nofollow">http://cid-9db5ae91a2948485.office.live.com/browse.aspx/PublicFolder?uc=1http://cid-9db5ae91a2948485.office.live.com/browse.aspx/PublicFolder?uc=1</a></p> <p>Feel free to download if you like and fix the issue.THAT WOULD BE FANTASTIC.</p> <p>In a nutshell I would like somebody to tell me that what I suspect is not the case.</p> <p>Suppose you have a customer object. Do you need to fetch it first before updating like you do for delete?That seems insane to me.</p> <p>Given that you have a save method(both insert and update are done here)and you pass you customer to it.You already have all the details .How would you modify to make it work? I get all sorts of errors. do I need to go to the db each time I need to modify a child of my customer?</p> <pre><code> public void Save(CustomerDTO customerDTO) { //convert dto to EF entity var entityCustomer=ToEntityCustomer(customerDTO) using(ctx=new CustomerContext()) { if(efCustomer.CustomerId &gt; 0) { //UPDATE //DO I NEED TO FETCH MY CUSTOMER AGAIN FROM THE DB EVEN THOUGH I ALREADY HAVE //HAVE ALL THE DETAILS? I have not done it here.????? ctx.Customers.Attach(entityCustomer); ctx.ApplyCurrentValues(entityCustomer); //Also Customer has addresses so foreach(var address in entityCustomer.Addresses) { //some may be new addresses some might be modified one ?????? lost } } else { ///INSERT ctx.Customers.AddObject(entityCustomer); ctx.ObjectStateManager.ChangeObjectState(entityCustomer,EntityState.Added); foreach(var address in entityCustomer.Addresses) { ctx.ObjectStateManager.ChangeObjectState(address ,EntityState.Added); } } ctx.SaveChanges(); } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USLadislav Mrnka
    1. USuser9969
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    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. POUpdate object in Entity Framework 4.Do you need to fetch first all the time?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POUpdate object in Entity Framework 4.Do you need to fetch first all the time?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POUpdate object in Entity Framework 4.Do you need to fetch first all the time?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COPossible duplicate of http://stackoverflow.com/questions/4218566/c-entity-framework-can-i-update-a-record-without-querying-first ?
      singulars
      1. POUpdate object in Entity Framework 4.Do you need to fetch first all the time?
      1. USPero P.
    2. COhi,looked at the one the title is exactly what I am looking for too but there is no answer
      singulars
      1. POUpdate object in Entity Framework 4.Do you need to fetch first all the time?
      1. USuser9969
 

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