Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If I am reading this right, then you are thinking about this wrong. The flow should go something like this (pseudo code)</p> <p>User requests data:</p> <pre><code>Open a context Retrieve data Close the context </code></pre> <p>User saves data:</p> <pre><code>Open a context Save the data Close the context </code></pre> <p>Print work entries:</p> <pre><code>Open a context Retrieve the data Close the context Print the data </code></pre> <p>Notice that in all of these, the context is only open as long as it is needed to perform the appropriate database action. If the print occurs before the user saves their changes, then the changes will not be printed since they have not been persisted by the user anyway.</p> <p><strong>NOW</strong>, sometimes there is a valid approach to keeping the context open throughout the lifetime of the application. However, the same rule should still apply. If the user saves the data, then the other context will become aware of it immediately anyway, as it will pull fresh data from the database when asked to print. Again, if the user does not save their changes, then it is not in the database, so it will not be printed. What if we print it and the user decides to discard the changes? If you want to avoid that situation, then you should probably prompt the user that printing will not pick up the unsaved data and allow them to choose if they still want to print or save the data. If you want to allow them to print saved AND unsaved data, then that is a different problem than EF contexts</p>
    singulars
    1. This table or related slice is empty.
    1. POEntity Framework - One application/One user/One simple use case ... seem simple but is not
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJustin Pihony
    1. USJustin Pihony
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POEntity Framework - One application/One user/One simple use case ... seem simple but is not
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COIf I understand the pseudo code, if the user want to print all the data, including its 2 new WorkEntries, he has to save it before doing so?
      singulars
      1. PO
      1. USNicolas
    2. CO@Nicolas yes, in fact, I just added a couple of lines at the end of my answer to cover that. Basically, if you want an "if I save" type of print, then that is a different design and not an EF problem. EF is just an ORM to talk to the DB, not to DB AND in-memory.
      singulars
      1. PO
      1. USJustin Pihony
    3. COI understand, but ... what if my application presents the data in a grid, like excel. In excel, I can add a row, print and save later or event delete the row I added and it's ok. The user prints what he is seeing, not matter if its persisted or not
      singulars
      1. PO
      1. USNicolas
 

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