insert statement affected an unexpected number of rows (0)

Question

I'm trying to insert a record using Entity Framework Code First. When trying to save the record I'm Keep getting the following error.

Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. Refresh ObjectStateManager entries.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OptimisticConcurrencyException: Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. Refresh ObjectStateManager entries.

Model:

 [Table("tblActual_CategoryItem")]
    public class Actual_CategoryItem
    {
        [Key]
        [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
        public int ID { get; set; }
        public int? AgencyID { get; set; }
        public string UniqueURL { get; set; }
        public string Name { get; set; }
        public string Price { get; set; }
        public string Location { get; set; }
        public string LastUpdated { get; set; }
        public string Description { get; set; }
        public string PhotoURL1 { get; set; }
        public string PhotoURL2 { get; set; }
        public string AgencyName { get; set; }
        public string AgencyUniqueURL { get; set; }
        public string AgencyPhotoURL { get; set; }
        public string AgentName { get; set; }
        public string AgentContactNo { get; set; }
        public string AgentEmail { get; set; }
        public DateTime? ImportedDateTime { get; set; }
        public int? CategoryID { get; set; }
        public int? UserID { get; set; }
        public string Suburb { get; set; }
        public string State { get; set; }
        public string PostCode { get; set; }

        [ForeignKey("CategoryID")]
        public CategoryType Category { get; set; }

         [ForeignKey("AgencyID")]
        public Actual_AgencyProfile agency { get; set; }

         [ForeignKey("UserID")]
         public UserProfile userProfile { get; set; }
    }

Controller:

 [HttpPost]
        public ActionResult Create([Bind(Exclude = "ID")]Actual_CategoryItem actual_categoryitem)
        {
            if (ModelState.IsValid)
            { 
                db.ItemList.Add(actual_categoryitem);

                db.SaveChanges();
                return RedirectToAction("Index");
            }

            ViewBag.CategoryID = new SelectList(db.CategoryTypes, "CategoryID", "TypeName", actual_categoryitem.CategoryID);
            ViewBag.AgencyID = new SelectList(db.Actual_AgencyProfile, "ID", "UniqueURL", actual_categoryitem.AgencyID);
            return View(actual_categoryitem);
        }

View:

@using (Html.BeginForm())
{
    @Html.ValidationSummary(false)
   @Html.HiddenFor(model => model.ID)
    
        
        



        
            
                @Html.ActionLink("Back to List", "Index")
            
            
                
                    Add New Post


                    
                        

                            
                                
                            

                            
                                
                                    Category : 
                                
                                
                                    
                                        @Html.DropDownList("CategoryID", (IEnumerable)ViewBag.CategoryID, new { @class = "form-control" })
                                        @Html.ValidationMessageFor(model => model.CategoryID)
                                    
                                
                                
                            

                            
                                Business Name: 
                            
                            
                                
                                    @Html.TextBoxFor(o => o.Name, new { @class = "form-control" })
                                
                            
                            

                            
                                Sale Price : 
                            
                            
                                
                                    @Html.TextBoxFor(o => o.Price, new { @class = "form-control" })
                                
                            
                            

                            
                                Street Address : 
                            
                            
                                
                                    @Html.TextBoxFor(o => o.Location, new { @class = "form-control" })
                                
                            
                            

                            
                                State: 
                            
                            
                                
                                    @Html.DropDownListFor(o => o.State, new List() { ( new SelectListItem() { Text = "New South Wales", Value = "NSW" }),( new SelectListItem() { Text = "Victoria", Value = "VIC" }),
                               ( new SelectListItem() { Text = "Queensland", Value = "QLD" }),( new SelectListItem() { Text = "Western Australia", Value = "WA" })
                            ,( new SelectListItem() { Text = "ACT", Value = "ACT" }),( new SelectListItem() { Text = "South Australia", Value = "SA" })
                            ,( new SelectListItem() { Text = "Tasmania", Value = "TAS" }),( new SelectListItem() { Text = "Northern Territory", Value = "NT" })}
                               , "Please Select", new { @class = "form-control" })

                                
                            
                            


                        

                    
                    
                    
                        


                            
                                Suburb: 
                            
                            
                                
                                    @Html.TextBoxFor(o => o.Suburb, new { @class = "form-control" })

                                
                            
                            

                            
                                Post Code: 
                            
                            
                                
                                    @Html.TextBoxFor(o => o.PostCode, new { @class = "form-control" })
                                
                            
                            

                            
                                Contact No: 
                            
                            
                                
                                    @Html.TextBoxFor(o => o.AgentContactNo, new { @class = "form-control" })
                                
                            
                            

                            
                                Contact Email: 
                            
                            
                                
                                    @Html.TextBoxFor(o => o.AgentEmail, new { @class = "form-control" })
                                
                            

                        
                    


                    
                
                
                   
                            

                            
                                
                                    
                                
                            
            

        
        
            @Html.ActionLink("Back to List", "Index")
        
    

    
        .
    
}

chamara · Accepted Answer

Turn out that EF produces this error when you have SQL triggers on your database table. Adding following at the end of the trigger solved the problem. However this may not be the perfect solution.

SELECT * FROM deleted UNION ALL
SELECT * FROM inserted;

insert statement affected an unexpected number of rows (0)

Answers (2)

Related Questions