Click here to Skip to main content
Rate this: bad
good
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 2:06am
loylmed374
Edited 28-Dec-12 3:05am
v2
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 at 28-Dec-12 8:25am
   
i pass it as a query???
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 at 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 at 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.

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 350
1 Gihan Liyanage 332
2 OriginalGriff 236
3 ClimerChinna 222
4 vikinghunter 168
0 Sergey Alexandrovich Kryukov 8,298
1 OriginalGriff 7,112
2 CPallini 2,598
3 Richard MacCutchan 2,005
4 Abhinav S 1,788


Advertise | Privacy | Mobile
Web02 | 2.8.140827.1 | Last Updated 28 Dec 2012
Copyright © CodeProject, 1999-2014
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