blocks|key|592324|text|我最近也被这件事惹恼了。我通过在种子方法的Configuration类中放置一个包装器函数来修复它，并将对SaveChanges的调用替换为对我的函数的调用。此函数将简单地枚举EntityValidationErrors集合中的错误，并在异常消息列出各个问题的情况下重新抛出异常。这会使输出显示在NuGet包管理器控制台中。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|592325|代码如下：|592326|///+<summary>
///+Wrapper+for+SaveChanges+adding+the+Validation+Messages+to+the+generated+exception
///+</summary>
///+<param+name="context">The+context.</param>
private+void+SaveChanges(DbContext+context)+{
++++try+{
++++++++context.SaveChanges();
++++}+catch+(DbEntityValidationException+ex)+{
++++++++StringBuilder+sb+=+new+StringBuilder();

++++++++foreach+(var+failure+in+ex.EntityValidationErrors)+{
++++++++++++sb.AppendFormat("{0}+failed+validation\n",+failure.Entry.Entity.GetType());
++++++++++++foreach+(var+error+in+failure.ValidationErrors)+{
++++++++++++++++sb.AppendFormat("-+{0}+:+{1}",+error.PropertyName,+error.ErrorMessage);
++++++++++++++++sb.AppendLine();
++++++++++++}
++++++++}

++++++++throw+new+DbEntityValidationException(
++++++++++++"Entity+Validation+Failed+-+errors+follow:\n"+%2B+
++++++++++++sb.ToString(),+ex
++++++++);+//+Add+the+original+exception+as+the+innerException
++++}
}|code-block|syntax|javascript|592327|只需在种子方法中将对context.SaveChanges()的调用替换为SaveChanges(context)即可。|592328|entityMap^0|1H|B|2G|M|0|0|0|A|L|11|K|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|X|8|@$9|Y|A|Z|B|C]|$9|10|A|11|B|C]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|P|$]]

I got annoyed by this recently too. I fixed it by putting a wrapper function in the Configuration class in the Seed method, and replaced calls to <code>SaveChanges</code> with calls to my function instead. This function would simply enumerate the errors within the <code>EntityValidationErrors</code> collection, and rethrow an exception where the Exception message lists the individual problems. This makes the output show up in the NuGet package manager console.

Code follows:

<pre><code>/// &lt;summary&gt;
/// Wrapper for SaveChanges adding the Validation Messages to the generated exception
/// &lt;/summary&gt;
/// &lt;param name="context"&gt;The context.&lt;/param&gt;
private void SaveChanges(DbContext context) {
 try {
 context.SaveChanges();
 } catch (DbEntityValidationException ex) {
 StringBuilder sb = new StringBuilder();

 foreach (var failure in ex.EntityValidationErrors) {
 sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType());
 foreach (var error in failure.ValidationErrors) {
 sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
 sb.AppendLine();
 }
 }

 throw new DbEntityValidationException(
 "Entity Validation Failed - errors follow:\n" + 
 sb.ToString(), ex
 ); // Add the original exception as the innerException
 }
}
</code></pre>

Just replace calls to <code>context.SaveChanges()</code> with <code>SaveChanges(context)</code> in your seed method.

blocks|key|376536|text|Richard感谢你让我走上了正确的道路(有同样的问题)，下面是一个没有包装器的替代方案，它适用于我在迁移配置种子方法中的工作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|376537|+Protected+Overrides+Sub+Seed(context+As+NotificationContext)

++++++++Try
++++++++++++context.System.AddOrUpdate(
+++++++++++++++Function(c)+c.SystemName,
++++++++++++++++New+E_NotificationSystem()+With+{.SystemName+=+"System1"},
++++++++++++++++New+E_NotificationSystem()+With+{.SystemName+=+"System2"},
++++++++++++++++New+E_NotificationSystem()+With+{.SystemName+=+"System3"})

++++++++++++context.SaveChanges()

++++++++Catch+ex+As+DbEntityValidationException

++++++++++++Dim+sb+As+New+StringBuilder

++++++++++++For+Each+failure+In+ex.EntityValidationErrors

++++++++++++++++sb.AppendFormat("{0}+failed+validation"+&+vbLf,+failure.Entry.Entity.[GetType]())

++++++++++++++++For+Each+[error]+In+failure.ValidationErrors
++++++++++++++++++++sb.AppendFormat("-+{0}+:+{1}",+[error].PropertyName,+[error].ErrorMessage)
++++++++++++++++++++sb.AppendLine()
++++++++++++++++Next
++++++++++++Next

++++++++++++Throw+New+Exception(sb.ToString())

++++++++End+Try
End+Sub|code-block|syntax|javascript|376538|然后能够在包管理器控制台中看到异常。希望这对某些人有帮助。|376539|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|$]]

Richard thanks for getting me on the right path (had same issue) below is an alternative without the wrapper this worked for me in the migration configuration seed method:

<pre><code> Protected Overrides Sub Seed(context As NotificationContext)

 Try
 context.System.AddOrUpdate(
 Function(c) c.SystemName,
 New E_NotificationSystem() With {.SystemName = "System1"},
 New E_NotificationSystem() With {.SystemName = "System2"},
 New E_NotificationSystem() With {.SystemName = "System3"})

 context.SaveChanges()

 Catch ex As DbEntityValidationException

 Dim sb As New StringBuilder

 For Each failure In ex.EntityValidationErrors

 sb.AppendFormat("{0} failed validation" &amp; vbLf, failure.Entry.Entity.[GetType]())

 For Each [error] In failure.ValidationErrors
 sb.AppendFormat("- {0} : {1}", [error].PropertyName, [error].ErrorMessage)
 sb.AppendLine()
 Next
 Next

 Throw New Exception(sb.ToString())

 End Try
End Sub
</code></pre>

Was then able to see the exception in the package manager console. Hope this helps someone.

blocks|key|592393|text|我将craigvl的版本转换为C#，我必须添加context.SaveChanges()；才能让它为我工作，如下所示。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|592394|try
{
++++byte[]+bytes+=+System.IO.File.ReadAllBytes(@"C:\Users\sheph_000\Desktop\Rawr.png");
++++Console.WriteLine(bytes);

++++context.BeverageTypes.AddOrUpdate(
++++++++x+=>+x.Name,
++++++++new+AATPos.DAL.Entities.BeverageType+{+ID+=+1,+Name+=+"Sodas"+}
++++++++);

++++context.Beverages.AddOrUpdate(
++++++++x+=>+x.Name,
++++++++new+AATPos.DAL.Entities.Beverage+{+ID+=+1,+Name+=+"Coke",+BeverageTypeID+=+1,+ImageData+=+bytes,+IsStocked+=+true,+StockLevel+=+10,+Price+=+10.00M,+ImageMimeType+=+"test"+},
++++++++new+AATPos.DAL.Entities.Beverage+{+ID+=+2,+Name+=+"Fanta",+BeverageTypeID+=+1,+ImageData+=+bytes,+IsStocked+=+true,+StockLevel+=+10,+Price+=+10.00M,+ImageMimeType+=+"test"+},
++++++++new+AATPos.DAL.Entities.Beverage+{+ID+=+3,+Name+=+"Sprite",+BeverageTypeID+=+1,+ImageData+=+bytes,+IsStocked+=+true,+StockLevel+=+10,+Price+=+10.00M,+ImageMimeType+=+"test"+},
++++++++new+AATPos.DAL.Entities.Beverage+{+ID+=+4,+Name+=+"Cream+Soda",+BeverageTypeID+=+1,+ImageData+=+bytes,+IsStocked+=+true,+StockLevel+=+10,+Price+=+10.00M,+ImageMimeType+=+"test"+},
++++++++new+AATPos.DAL.Entities.Beverage+{+ID+=+5,+Name+=+"Pepsi",+BeverageTypeID+=+1,+ImageData+=+bytes,+IsStocked+=+true,+StockLevel+=+10,+Price+=+10.00M,+ImageMimeType+=+"test"+}
++++++++);

++++context.SaveChanges();
}
catch+(System.Data.Entity.Validation.DbEntityValidationException+ex)
{
++++var+sb+=+new+System.Text.StringBuilder();
++++foreach+(var+failure+in+ex.EntityValidationErrors)
++++++++++++{
++++++++++++++++sb.AppendFormat("{0}+failed+validation",+failure.Entry.Entity.GetType());
++++++++foreach+(var+error+in+failure.ValidationErrors)
++++++++++++++++{
++++++++++++sb.AppendFormat("-+{0}+:+{1}",+error.PropertyName,+error.ErrorMessage);
++++++++++++sb.AppendLine();
++++++++++++++++}
++++++++++++}

++++throw+new+Exception(sb.ToString());
}|code-block|syntax|javascript|592395|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 converted craigvl's version to C# I had to add context.SaveChanges(); in order for it to work for me as below.

<pre><code>try
{
 byte[] bytes = System.IO.File.ReadAllBytes(@"C:\Users\sheph_000\Desktop\Rawr.png");
 Console.WriteLine(bytes);

 context.BeverageTypes.AddOrUpdate(
 x =&gt; x.Name,
 new AATPos.DAL.Entities.BeverageType { ID = 1, Name = "Sodas" }
 );

 context.Beverages.AddOrUpdate(
 x =&gt; x.Name,
 new AATPos.DAL.Entities.Beverage { ID = 1, Name = "Coke", BeverageTypeID = 1, ImageData = bytes, IsStocked = true, StockLevel = 10, Price = 10.00M, ImageMimeType = "test" },
 new AATPos.DAL.Entities.Beverage { ID = 2, Name = "Fanta", BeverageTypeID = 1, ImageData = bytes, IsStocked = true, StockLevel = 10, Price = 10.00M, ImageMimeType = "test" },
 new AATPos.DAL.Entities.Beverage { ID = 3, Name = "Sprite", BeverageTypeID = 1, ImageData = bytes, IsStocked = true, StockLevel = 10, Price = 10.00M, ImageMimeType = "test" },
 new AATPos.DAL.Entities.Beverage { ID = 4, Name = "Cream Soda", BeverageTypeID = 1, ImageData = bytes, IsStocked = true, StockLevel = 10, Price = 10.00M, ImageMimeType = "test" },
 new AATPos.DAL.Entities.Beverage { ID = 5, Name = "Pepsi", BeverageTypeID = 1, ImageData = bytes, IsStocked = true, StockLevel = 10, Price = 10.00M, ImageMimeType = "test" }
 );

 context.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
 var sb = new System.Text.StringBuilder();
 foreach (var failure in ex.EntityValidationErrors)
 {
 sb.AppendFormat("{0} failed validation", failure.Entry.Entity.GetType());
 foreach (var error in failure.ValidationErrors)
 {
 sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
 sb.AppendLine();
 }
 }

 throw new Exception(sb.ToString());
}
</code></pre>

blocks|key|376588|text|我将Richards的答案转换为扩展方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|376589|++public+static+int+SaveChangesWithErrors(this+DbContext+context)
++++{
++++++++try
++++++++{
++++++++++++return+context.SaveChanges();
++++++++}
++++++++catch+(DbEntityValidationException+ex)
++++++++{
++++++++++++StringBuilder+sb+=+new+StringBuilder();

++++++++++++foreach+(var+failure+in+ex.EntityValidationErrors)
++++++++++++{
++++++++++++++++sb.AppendFormat("{0}+failed+validation\n",+failure.Entry.Entity.GetType());
++++++++++++++++foreach+(var+error+in+failure.ValidationErrors)
++++++++++++++++{
++++++++++++++++++++sb.AppendFormat("-+{0}+:+{1}",+error.PropertyName,+error.ErrorMessage);
++++++++++++++++++++sb.AppendLine();
++++++++++++++++}
++++++++++++}

++++++++++++throw+new+DbEntityValidationException(
++++++++++++++++"Entity+Validation+Failed+-+errors+follow:\n"+%2B
++++++++++++++++sb.ToString(),+ex
++++++++++++);+//+Add+the+original+exception+as+the+innerException
++++++++}
++++}|code-block|syntax|javascript|376590|像这样调用：|376591|context.SaveChangesWithErrors();|376592|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I converted Richards answer to an extension method :

<pre><code> public static int SaveChangesWithErrors(this DbContext context)
 {
 try
 {
 return context.SaveChanges();
 }
 catch (DbEntityValidationException ex)
 {
 StringBuilder sb = new StringBuilder();

 foreach (var failure in ex.EntityValidationErrors)
 {
 sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType());
 foreach (var error in failure.ValidationErrors)
 {
 sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
 sb.AppendLine();
 }
 }

 throw new DbEntityValidationException(
 "Entity Validation Failed - errors follow:\n" +
 sb.ToString(), ex
 ); // Add the original exception as the innerException
 }
 }
</code></pre>

Call like this:

<pre><code>context.SaveChangesWithErrors();
</code></pre>

blocks|key|376606|text|​|type|unstyled|depth|inlineStyleRanges|entityRanges|data|376607|I+Also+had+same+model+validation+problem+but+successfully+catch+by+myself+after+lot+of+thinking;

I+use+reverse+engineering+method+to+catch+the+problem+out+of+Over+80+%2B+Model+Classes;

1>+Made+copy+of+dbcontext,+changing+the+name+(I+add+"1"+at+end+and+make+respective+changes+in+class+constructor+and+initialization+etc.

Old:
+
>public+class+AppDb+:+IdentityDbContext<ApplicationUser>
>+++++
>+{
>+public+AppDb():+base("DefaultConnection",+throwIfV1Schema:+false)
>+{
>+
>+}
>+++++
>+public+static+AppDb+Create()
>{
>return+new+AppDb();
>}+

**New:**

>public+class+AppDb1+:+IdentityDbContext<ApplicationUser>
>{
>public+AppDb1()
>:+base("DefaultConnection",+throwIfV1Schema:+false)
>{
>}
>+
>public+static+AppDb1+Create()
>+{
>+return+new+AppDb1();
>++}`

...
2>+Make+changes+to+Codefirst+Migration+Configuration+from+Old+DbContext+to+my+new+Context.

>+internal+sealed+class+Configuration+:
>+DbMigrationsConfiguration<DAL.AppDb1>+{+public+Configuration()+{
>+AutomaticMigrationsEnabled+=+false;+}++++protected+override+void
>+Seed(DAL.AppDb1+context)+{`

3>+Comment+the+Dbsets+in+new+DbContext+which+was+doubt.
4>+Apply+update+migration+if+succeeded+the+probelm+lye+in+Commented+section.
5>+if+not+then+commented+section+is+clear+of+bug+clear.
6>+repeat+the+(4)+until+found+the+right+place+of+bug.
7>+Happy+Codding|code-block|syntax|javascript|376608|376609|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|K|8|@]|9|@]|A|$E|F]]|$1|G|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|M|8|@]|9|@]|A|$]]]|I|$]]

<div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-html lang-html prettyprint-override"><code>I Also had same model validation problem but successfully catch by myself after lot of thinking;

I use reverse engineering method to catch the problem out of Over 80 + Model Classes;

1&gt; Made copy of dbcontext, changing the name (I add "1" at end and make respective changes in class constructor and initialization etc.

Old:
 
&gt;public class AppDb : IdentityDbContext&lt;ApplicationUser&gt;
&gt; 
&gt; {
&gt; public AppDb(): base("DefaultConnection", throwIfV1Schema: false)
&gt; {
&gt; 
&gt; }
&gt; 
&gt; public static AppDb Create()
&gt;{
&gt;return new AppDb();
&gt;} 

**New:**

&gt;public class AppDb1 : IdentityDbContext&lt;ApplicationUser&gt;
&gt;{
&gt;public AppDb1()
&gt;: base("DefaultConnection", throwIfV1Schema: false)
&gt;{
&gt;}
&gt; 
&gt;public static AppDb1 Create()
&gt; {
&gt; return new AppDb1();
&gt; }`

...
2&gt; Make changes to Codefirst Migration Configuration from Old DbContext to my new Context.

&gt; internal sealed class Configuration :
&gt; DbMigrationsConfiguration&lt;DAL.AppDb1&gt; { public Configuration() {
&gt; AutomaticMigrationsEnabled = false; } protected override void
&gt; Seed(DAL.AppDb1 context) {`

3&gt; Comment the Dbsets in new DbContext which was doubt.
4&gt; Apply update migration if succeeded the probelm lye in Commented section.
5&gt; if not then commented section is clear of bug clear.
6&gt; repeat the (4) until found the right place of bug.
7&gt; Happy Codding</code></pre>
</div>
</div>

I'm at a loss for this:

I've defined my classes for a entity framework (4.1.3) code first approach. Everything was fine (I was creating the tables etc.) until I started to Seed.

Now when I do the 

<pre><code>Add-Migration "remigrate" ; Update-Database;
</code></pre>

I get an error on the package console "Validation failed for one or more entities. See 'EntityValidationErrors' property for more details."

I have a breakpoint in my Seed() method but because I'm running this on the console when the project is not running, I'm clueless as to how to get to the details (PS - I've seen the thread <a href="https://stackoverflow.com/questions/5400530/validation-failed-for-one-or-more-entities-while-saving-changes-to-sql-server-da">Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework</a> which shows how I can see the property.)

I know that my Seed() method has a problem because if I put a return right after the method call, the error goes away. So how do I set my breakpoint so I can see what the validation error is? Kinda lost. Or is there some other way to trace it in the nuget console??

EF Code First: How do I see 'EntityValidationErrors' property from the nuget package console?

包管理器

我对此感到困惑：我已经为实体框架(4.1.3)代码优先方法定义了我的类。一切都很好(我正在创建表等等)直到我开始播种。现在当我这样做时Add-Migration "remigrate" ; Update-Database;我在包控制台上得到一个错误“验证一个或多个实体失败。有关更多详细信息，请参阅'EntityVali...

问EF代码优先:如何在nuget包控制台中看到'EntityValidationErrors‘属性？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问EF代码优先:如何在nuget包控制台中看到'EntityValidationErrors‘属性？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问EF代码优先:如何在nuget包控制台中看到'EntityValidationErrors‘属性？
EN