I am trying to add a Room into my database but keep getting the above error and cannot figure out why.
I am trying to insert:
ID: 12345 Name: Room
There is no entry in the database with an ID of 12345, in fact there are no entries, I cannot insert anything.
Model
public class Room
{
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public int ID { get; set; }
public string name { get; set; }
public virtual ICollection<RoomItem> RoomItems { get; set; }
public virtual ICollection<StaffRoom> StaffRooms { get; set; }
public virtual ICollection<RoomAudit> RoomAudit { get; set; }
}
Controller
[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Create([Bind(Include = "ID, name")] Room room)
{
db.Rooms.Add(room);
db.SaveChanges();
return RedirectToAction("Index");
}
Connection String
<connectionStrings>
<add name="UniversityContext" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=RoomAudit;Integrated Security=SSPI;" providerName="System.Data.SqlClient" />
</connectionStrings>
I have been trying to figure this out for hours so any help is massively appreciated.
EDIT
Full error:
An exception of type 'System.Data.Entity.Infrastructure.DbUpdateException' occurred in EntityFramework.dll but was not handled in user code
Additional information: An error occurred while updating the entries. See the inner exception for details.
Inner exception 1:
{"An error occurred while updating the entries. See the inner exception for details."}
Inner exception 2:
{"Cannot insert explicit value for identity column in table 'Room' when IDENTITY_INSERT is set to OFF."}
