Click here to Skip to main content
12,703,063 members (29,111 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: ASP.NET
[AcceptVerbs(HttpVerbs.Post)]
 
public ActionResult CreateUser( [Bind(Exclude="IdUtilisateur")Utilisateur UtilisateurCree)
{
if (!ModelState.IsValid)
 
return View();
 
_db.AddToUtilisateurs(UtilisateurCree);
_db.SaveChanges(); 
return RedirectToAction("CreateUser");
}

it returns an exception when creating!!!!!
_db.AddToUtilisateurs(UtilisateurCree);

Exception: "cannot insert value for identity colum in table 'users' when IDENTITY_INSERT in set to off'
Posted 28-Dec-12 3:06am
loylmed374
Updated 28-Dec-12 4:05am
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

You are explicitly inserting a value in one of your database table column that is marked as an identity column. Either remove identity for that column or do not pass value from code to be inserted in the table.
  Permalink  
Comments
loylmed 28-Dec-12 8:15am
   
i have the IDUser but i dont pass a value from code to insert (i marked it as an identity column because i want that automaticly increment)!!!!!
explains me more plz
Zafar Sultan 28-Dec-12 8:23am
   
But the error itself says "Can not insert value for identity column table 'Users' when IDENTITY_INSERT is set to off". Debug your code, it sure is sending the value explicitly.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Try this...
USE DATABASENAME
GO
SET IDENTITY_INSERT [TABLENAME] ON
INSERT [TABLENAME] ([AUTOIDFIELDNAME]) VALUES(1)
SET IDENTITY_INSERT [Tbl_Co_IEUpdateId] OFF
GO
  Permalink  
Comments
loylmed 28-Dec-12 8:25am
   
i pass it as a query???

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 28 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100