Databases
StackOverflow2013
Postsdbo
POEntity Framework doesn't update value which is modified by a trigger
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEntity Framework doesn't update value which is modified by a trigger
    primarykey
    data
    text
    <p>My table <code>Sections</code> (SQL Server) has <code>ID</code> as a primary key <code>(int, identity)</code> and <code>SortIndex</code> column (int) for sorting purposes.</p> <p>The database has a trigger which sets <code>SortIndex := ID</code> at each <code>INSERT</code>. Obviously I want to change the sorting index later, by swapping the values for two rows.</p> <p>I access the data using Entity Framework, all with MVC3 web application.</p> <p>The problem is, Entity Framework doesn't update the value of <code>SortIndex</code> after I insert a new object into the table. It also caches all the data, so the following call to get all objects from this table will also give wrong <code>SortIndex</code> value for this object.</p> <p>I tried changing <code>StoreGeneratedPattern</code> for this column in <code>EDMX</code>. This seems to be great and elegant but doesn't solve the problem.</p> <p>If I set to <code>Identity</code>, it causes EF to properly update the value, but it becomes read only (exception thrown when trying to change). Setting it to <code>Computed</code> is similar, but instead of exception being thrown the values are just not written to the DB.</p> <p>I can recreate the EF object every time if I need to use it after inserting an object, just by doing:</p> <pre><code>DatabaseEntities db = new DatabaseEntities() </code></pre> <p>But it seems like ugly workaround for me.</p> <p>What's a solution to this problem?</p> <p>Obviously something, what doesn't require me to do some action after every <code>insert</code> (and take a risk that it's forgotten and unnoticed) is preferred. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USArek
    1. USArek
    plurals
    1. 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
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POEntity Framework doesn't update value which is modified by a trigger
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POEntity Framework doesn't update value which is modified by a trigger
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POEntity Framework doesn't update value which is modified by a trigger
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COPossible duplicate: http://stackoverflow.com/questions/5445243/reload-field-value-modified-in-db-by-trigger-after-insert-update
      singulars
      1. POEntity Framework doesn't update value which is modified by a trigger
      1. USGert Arnold
    2. COIt's similar, but he seems to have a field which he doesn't need to write to. "Computed" should be fine for him. It just doesn't work because of some bug.
      singulars
      1. POEntity Framework doesn't update value which is modified by a trigger
      1. USArek
 

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