please help!!! Validation failed for one or more entities. See 'EntityValidationErrors' property for more details. RSS

• • Reply
  

  Memnoch1984

  Member

  8 Points

  32 Posts

  please help!!! Validation failed for one or more entities. See 'EntityValidationErrors' property ...

  Mar 28, 2012 03:54 PM|LINK

  Here is my model

  namespace SolucionesEfectivas.Models
  {
      using System;
      using System.Collections.Generic;
      
      public partial class sucursal
      {
          public sucursal()
          {
              this.buro = new HashSet<buro>();
              this.caja = new HashSet<caja>();
              this.cliente = new HashSet<cliente>();
              this.cuenta = new HashSet<cuenta>();
              this.cuentadestino = new HashSet<cuentadestino>();
              this.empleado = new HashSet<empleado>();
          }
      
          public int id { get; set; }
          public int idoficina { get; set; }
          public string nombreoficina { get; set; }
          public string nombreencargado { get; set; }
          public string apencargado { get; set; }
          public string amencargado { get; set; }
          public int codigopostal { get; set; }
          public string estado { get; set; }
          public string municipio { get; set; }
          public string colonia { get; set; }
          public string calle { get; set; }
          public int numeroext { get; set; }
          public Nullable<int> numeroint { get; set; }
          public string telefono { get; set; }
      
          public virtual ICollection<buro> buro { get; set; }
          public virtual ICollection<caja> caja { get; set; }
          public virtual ICollection<cliente> cliente { get; set; }
          public virtual ICollection<cuenta> cuenta { get; set; }
          public virtual ICollection<cuentadestino> cuentadestino { get; set; }
          public virtual ICollection<empleado> empleado { get; set; }
          public virtual oficina oficina { get; set; }
      }
  }

  and here is my controller:

  public ActionResult Create()
          {
              ViewBag.idoficina = new SelectList(db.oficina, "id", "descripcion");
              return View();
          } 
  
          //
          // POST: /Sucursal/Create
  
          [HttpPost]
          public ActionResult Create(sucursal sucursal)
          {
              if (ModelState.IsValid)
              {
                  db.sucursal.Add(sucursal);
                  db.SaveChanges();
                  return RedirectToAction("Index");  
              }
  
              ViewBag.idoficina = new SelectList(db.oficina, "id", "descripcion", sucursal.idoficina);
              return View(sucursal);
          }

  Here es the stack error:

  [DbEntityValidationException: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.]
     System.Data.Entity.Internal.InternalContext.SaveChanges() +173
     System.Data.Entity.Internal.LazyInternalContext.SaveChanges() +23
     System.Data.Entity.DbContext.SaveChanges() +20
     SolucionesEfectivas.Controllers.SucursalController.Create(sucursal sucursal) in C:\Users\EDS2\Documents\SolucionesEfectivas\SolucionesEfectivas\Controllers\SucursalController.cs:52
     lambda_method(Closure , ControllerBase , Object[] ) +162
     System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +17
     System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +208
     System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27
     System.Web.Mvc.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() +55
     System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +263
     System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +19
     System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +191
     System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +343
     System.Web.Mvc.Controller.ExecuteCore() +116
     System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +97
     System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +10
     System.Web.Mvc.<>c__DisplayClassb.<BeginProcessRequest>b__5() +37
     System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +21
     System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +12
     System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62
     System.Web.Mvc.<>c__DisplayClasse.<EndProcessRequest>b__d() +50
     System.Web.Mvc.SecurityUtil.<GetCallInAppTrustThunk>b__0(Action f) +7
     System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action) +22
     System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +60
     System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
     System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +8969117
     System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +184

   I really don´t now why its happend, I debugg my proyect and in the part of database the field oficina return NULL, but oficina it´s only a virtual collertion in my model that it´s catched in my controller whit idoficina.

  Please someone helps

  P.D. my models, controllers ands views whas created whit EF I really only put my database.
  
  

  
  
  

• • Reply
  

  Memnoch1984

  Member

  8 Points

  32 Posts

  Re: please help!!! Validation failed for one or more entities. See 'EntityValidationErrors' prope...

  Mar 28, 2012 04:33 PM|LINK

  I found the error, jejeje my partner put char in some data and I was traing to introduce nvarchar, jeje

  Thanks.

  • Marked as answer by Memnoch1984 on Mar 28, 2012 04:33 PM
• • Reply
  

  habeeb_matri...

  Member

  12 Points

  15 Posts

  Re: please help!!! Validation failed for one or more entities. See 'EntityValidationErrors' prope...

  Oct 24, 2012 09:47 AM|LINK

  Here is a readymade catch block to get into the real issue that throws this exception from the entity framework.

  http://dotnet-programming-solutions.blogspot.com/2012/10/validation-failed-for-one-or-more_24.html