Skip to main content

An error occurred while updating the entries. See the inner exception for details.



If you are using EF then you may get the error. This error is not specify where the error exactly occur in your table. To specify the error use this code & use debugger to see the exact error message.


  try  
       {  
                 //Your code  
                     db = new FEDALIC_AGRI_DBEntities ();  
                     model.FarmerVillage = new Guid(village);  
                     model.FarmerThana = new Guid(thana);  
                     model.FarmerDistrict = new Guid(district);  
                     var _SET_FARMER_INFO = EMFermar.SetToModelObject(model);  
                     db.SET_FARMER_INFO.Add(_SET_FARMER_INFO);  
                     db.SaveChanges();  
       }  
       catch (DbUpdateException e)  
       {  
         var innerEx = e.InnerException;  
         while (innerEx.InnerException != null)  
           innerEx = innerEx.InnerException;  
         throw new Exception(innerEx.Message);  
       }  
       catch (DbEntityValidationException e)  
       {  
         var sb = new StringBuilder();  
         foreach (var entry in e.EntityValidationErrors)  
         {  
           foreach (var error in entry.ValidationErrors)  
           {  
             sb.AppendLine(string.Format("{0}-{1}-{2}",  
               entry.Entry.Entity,  
               error.PropertyName,  
               error.ErrorMessage  
               )  
             );  
           }  
         }  
         throw new Exception(sb.ToString());  
       }  



[NB: I got this exception because of duplicate primary key when I am going to insert in my table]
Thank you.

Comments

Popular posts from this blog

WPF datagrid cell textbox change event

Entity/Class: public class FeesDetails : INotifyPropertyChanged { public int Id { get; set; } public string FeesName { get; set;} public string FeesDetailsName { get; set; } public int? PaidAmount { get; set; } public event PropertyChangedEventHandler PropertyChanged; private void NotifyPropertyChanged(System.String info) { if (PropertyChanged != null) { PropertyChanged(this, new PropertyChangedEventArgs(info)); } } public int feesAmount { get; set; } public int FeesAmount { get { return this.feesAmount; } set { if (value != this.feesAmount) { this.feesAmount = value; NotifyPropertyChanged("FeesAmount"); } } } } XAML: <DataGrid AutoGenerateColumns="False" Height="21...

mvc razor textboxfor change event change another textboxfor value

Based on value of Weight, Rate , CNF & AWB it will change the value of Freight , TTLCNF anfd TTLFright . Freight= Weight*Rate; TTLCNF  = Weight*CNF; TTLFright=  Freight+ TTLCNF  + AWB; @Html.TextBoxFor(model => model.Weight, new { onChange="return GetWight(this);"}) @Html.TextBoxFor(model => model.Rate, new { onChange="return GetWight(this);"})/Kg @Html.TextBoxFor(model => model.Freight, new {disabled = "disabled" , @readonly = "readonly" ,onChange="return GetTTLFright(this);"}) @Html.TextBoxFor(model => model.CNFPK, new { onChange="return GetCNFPK(this);"}) @Html.TextBoxFor(model => model.TTLCNF, new {disabled = "disabled" , @readonly = "readonly",onChange="return GetTTLFright(this);" }) @Html.TextBoxFor(model => model.AWB, new { onChange="return GetTTLFright(this);"}) and script <script> function GetW...

mvvm double click event in listview

If you want to get the double click event on a listview item you can try with this code; <ListView Grid.Row="0" Grid.RowSpan="3" Grid.Column="0" Width="250" Height="200" HorizontalAlignment="Stretch" VerticalAlignment="Top" AlternationCount="2" BorderBrush="#FFA8CC7B" ItemContainerStyle="{StaticResource alternatingStyle}" ItemsSource="{Binding FromPayerNameList}" SelectedItem="{Binding SelectedFromPayer, Mode=TwoWay}"> <ListView.ItemTemplate> <DataTemplate> <TextBlock Width="{Binding Path=ActualWidth, RelativeSource={RelativeSource FindAncestor, AncestorType={x:Type ListView}}}" Text=...