blocks|key|44497|text|我检查了一下，id运行得很好：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|44498|//Search
Box+box+=+dbContext.Boxes.FirstOrDefault(x+=>+x.BoxId+==+45);

//breakpoint+here,+change+Name+of+Box+by+sql+management+studio

//Refresh
var+context+=+((IObjectContextAdapter)dbContext).ObjectContext;
context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins,+box);

//Check+refresh+and+if+it+is+in+context
box+=+dbContext.Boxes.FirstOrDefault(x+=>+x.BoxId+==+45);|code-block|syntax|javascript|44499|您确定它是相同的db-context吗？|44500|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I checked this and id works fine: 

<pre><code>//Search
Box box = dbContext.Boxes.FirstOrDefault(x =&gt; x.BoxId == 45);

//breakpoint here, change Name of Box by sql management studio

//Refresh
var context = ((IObjectContextAdapter)dbContext).ObjectContext;
context.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, box);

//Check refresh and if it is in context
box = dbContext.Boxes.FirstOrDefault(x =&gt; x.BoxId == 45);
</code></pre>

Are you sure it is the same db-context?

blocks|key|261248|text|using+System.Data.Entity.Core.Objects;
using+System.Data.Entity.Infrastructure;
using+System.Linq;

namespace+System.Data.Entity
{
++++public+static+class+DbContextExtensions
++++{
++++++++///+<summary>
++++++++///+Refresh+non-detached+entities
++++++++///+</summary>
++++++++///+<param+name="dbContext">context+of+the+entities</param>
++++++++///+<param+name="refreshMode">store+or+client+wins</param>
++++++++///+<param+name="entityType">when+specified+only+entities+of+that+type+are+refreshed.+when+null+all+non-detached+entities+are+modified</param>
++++++++///+<returns></returns>
++++++++public+static+DbContext+RefreshEntites(this+DbContext+dbContext,+RefreshMode+refreshMode,+Type+entityType)
++++++++{
++++++++++++//https://christianarg.wordpress.com/2013/06/13/entityframework-refreshall-loaded-entities-from-database/
++++++++++++var+objectContext+=+((IObjectContextAdapter)dbContext).ObjectContext;
++++++++++++var+refreshableObjects+=+objectContext.ObjectStateManager
++++++++++++++++.GetObjectStateEntries(EntityState.Added+%7C+EntityState.Deleted+%7C+EntityState.Modified+%7C+EntityState.Unchanged)
++++++++++++++++.Where(x+=>+entityType+==+null+%7C%7C+x.Entity.GetType()+==+entityType)
++++++++++++++++.Where(entry+=>+entry.EntityKey+!=+null)
++++++++++++++++.Select(e+=>+e.Entity)
++++++++++++++++.ToArray();

++++++++++++objectContext.Refresh(RefreshMode.StoreWins,+refreshableObjects);

++++++++++++return+dbContext;
++++++++}

++++++++public+static+DbContext+RefreshAllEntites(this+DbContext+dbContext,+RefreshMode+refreshMode)
++++++++{
++++++++++++return+RefreshEntites(dbContext:+dbContext,+refreshMode:+refreshMode,+entityType:+null);+//null+entityType+is+a+wild+card
++++++++}

++++++++public+static+DbContext+RefreshEntites<TEntity>(this+DbContext+dbContext,+RefreshMode+refreshMode)
++++++++{
++++++++++++return+RefreshEntites(dbContext:+dbContext,+refreshMode:+refreshMode,+entityType:+typeof(TEntity));
++++++++}
++++}
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|261249|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>using System.Data.Entity.Core.Objects;
using System.Data.Entity.Infrastructure;
using System.Linq;

namespace System.Data.Entity
{
 public static class DbContextExtensions
 {
 /// &lt;summary&gt;
 /// Refresh non-detached entities
 /// &lt;/summary&gt;
 /// &lt;param name="dbContext"&gt;context of the entities&lt;/param&gt;
 /// &lt;param name="refreshMode"&gt;store or client wins&lt;/param&gt;
 /// &lt;param name="entityType"&gt;when specified only entities of that type are refreshed. when null all non-detached entities are modified&lt;/param&gt;
 /// &lt;returns&gt;&lt;/returns&gt;
 public static DbContext RefreshEntites(this DbContext dbContext, RefreshMode refreshMode, Type entityType)
 {
 //https://christianarg.wordpress.com/2013/06/13/entityframework-refreshall-loaded-entities-from-database/
 var objectContext = ((IObjectContextAdapter)dbContext).ObjectContext;
 var refreshableObjects = objectContext.ObjectStateManager
 .GetObjectStateEntries(EntityState.Added | EntityState.Deleted | EntityState.Modified | EntityState.Unchanged)
 .Where(x =&gt; entityType == null || x.Entity.GetType() == entityType)
 .Where(entry =&gt; entry.EntityKey != null)
 .Select(e =&gt; e.Entity)
 .ToArray();

 objectContext.Refresh(RefreshMode.StoreWins, refreshableObjects);

 return dbContext;
 }

 public static DbContext RefreshAllEntites(this DbContext dbContext, RefreshMode refreshMode)
 {
 return RefreshEntites(dbContext: dbContext, refreshMode: refreshMode, entityType: null); //null entityType is a wild card
 }

 public static DbContext RefreshEntites&lt;TEntity&gt;(this DbContext dbContext, RefreshMode refreshMode)
 {
 return RefreshEntites(dbContext: dbContext, refreshMode: refreshMode, entityType: typeof(TEntity));
 }
 }
}
</code></pre>

blocks|key|44535|text|在某些情况下，如果集合已由第三方应用程序更新，则在刷新集合的对象时可能不会重新加载该集合。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|44536|在这种情况下，我有一个对象A，它与对象B有一对多的关系。|44537|应用程序1加载一个A.ListB为空的对象A。应用程序2填充A.ListB集合。应用程序1重新加载对象A。|44538|使用上面的解决方案，A.ListB仍然是空的。我必须显式地重新加载集合A.ListB。|44539|下面是重新加载所有集合的通用方法：|44540|var+context+=+((IObjectContextAdapter)this).ObjectContext;

//+detach+all+added+entities
ChangeTracker.Entries().Where(e+=>+e.State+==+EntityState.Added).ToList().ForEach(e+=>+e.State+=+EntityState.Detached);

//+select+entities
var+refreshableObjects+=+ChangeTracker.Entries().Select(e+=>+e.Entity).ToList();

//+refresh+each+refreshable+object
foreach+(var+@object+in+refreshableObjects)
{
++++//+refresh+each+collection+of+the+object
++++context.ObjectStateManager.GetRelationshipManager(@object).GetAllRelatedEnds().Where(+r+=>+r.IsLoaded).ToList().ForEach(+c+=>+c.Load()+);

++++//+refresh+the+object
++++context.Refresh(RefreshMode.StoreWins,+@object);
}|code-block|syntax|javascript|44541|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|U|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|V|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

In some cases, if a collection has been updated by a third party app, the collection may not be reloaded when refreshing the collection's object.

I had the case where I had an object A with a one to many relashionship to an object B.

Application 1 loads an object A with A.ListB empty.
Application 2 fills the A.ListB collection.
Application 1 reloads the object A.

With the solution above, A.ListB remains empty. I had to reload the collection A.ListB explicitly.

Here is a generic way to have all collections reloaded:

<pre><code>var context = ((IObjectContextAdapter)this).ObjectContext;

// detach all added entities
ChangeTracker.Entries().Where(e =&gt; e.State == EntityState.Added).ToList().ForEach(e =&gt; e.State = EntityState.Detached);

// select entities
var refreshableObjects = ChangeTracker.Entries().Select(e =&gt; e.Entity).ToList();

// refresh each refreshable object
foreach (var @object in refreshableObjects)
{
 // refresh each collection of the object
 context.ObjectStateManager.GetRelationshipManager(@object).GetAllRelatedEnds().Where( r =&gt; r.IsLoaded).ToList().ForEach( c =&gt; c.Load() );

 // refresh the object
 context.Refresh(RefreshMode.StoreWins, @object);
}
</code></pre>

blocks|key|44594|text|我在数据库中有一个触发器after+insert，并且我在事务内部工作，所以我需要在相同的上下文中获取触发器生成的新值。这对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|44595|using+(var+ctx+=+new+context())
{
++++ctx.Connection.Open();
++++ctx.Transaction+=+ctx.Connection.BeginTransaction();

++++ctx.Entities.InsertOnSubmit(itemDB);
++++ctx.SubmitChanges();
++++ctx.Refresh(RefreshMode.OverwriteCurrentValues,+itemDB);

++++Model+newModel+=+itemDB.ToModel();

++++ctx.Transaction.Commit();
++++return+newModel;
}
catch+(Exception+ex)
{
++++ctx.Transaction.Rollback();
}|code-block|syntax|javascript|44596|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I had a trigger after insert in the database and I was working inside a transaction, so I needed to get the new values generated by the trigger in the same context. This worked for me:

<pre><code>using (var ctx = new context())
{
 ctx.Connection.Open();
 ctx.Transaction = ctx.Connection.BeginTransaction();

 ctx.Entities.InsertOnSubmit(itemDB);
 ctx.SubmitChanges();
 ctx.Refresh(RefreshMode.OverwriteCurrentValues, itemDB);

 Model newModel = itemDB.ToModel();

 ctx.Transaction.Commit();
 return newModel;
}
catch (Exception ex)
{
 ctx.Transaction.Rollback();
}

</code></pre>

I want to refresh all entities of my <code>DbContext</code> without recreating it, I tried the following and none of them make sense:

<pre><code>var context = ((IObjectContextAdapter)myDbContext).ObjectContext;

var refreshableObjects = (from entry in context.ObjectStateManager.GetObjectStateEntries(
 EntityState.Added
 | EntityState.Deleted
 | EntityState.Modified
 | EntityState.Unchanged)
 where entry.EntityKey != null
 select entry.Entity);

context.Refresh(RefreshMode.StoreWins, refreshableObjects);
//.......................................................................
foreach (var entry in this.Orm.ChangeTracker.Entries())
{
 entry.State = EntityState.Unchanged;
}
this.Orm.ChangeTracker.DetectChanges();
</code></pre>

And the only one which refreshes my <code>DbContext</code>:

<pre><code>foreach (var i in this.Orm.ChangeTracker.Entries())
 i.Reload();
</code></pre>

But it's too slow. Can you help me choosing the right way?

How to Refresh DbContext

数据库

我想刷新我的DbContext的所有实体而不重新创建它，我尝试了以下方法，但没有一个有意义：var context = ((IObjectContextAdapter)myDbContext).ObjectContext;var refreshableObjects = (from entry in context.O...

问如何刷新DbContext
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何刷新DbContextEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何刷新DbContext
EN