How to insert value for a identity column in Entity Framework?

c# entity-framework

Question

I've created two columns in sql table that one is a identity column and another one is a varchar column. I need to generate identity column starting from the value 1000. I had tried the below code snippet, but it was given error "An error occurred while updating the entries. See the inner exception for details.."

   Place objPlace = new Place();
   objPlace.PNAME = "place 3";
   //objPlace.PID = 1003;   //purposefully commented for auto increment

   objContext.Places.AddObject(objPlace);
   objContext.SaveChanges();

I guess this is very basic question as I'm new to EF so please help me to sort it out.

1
0
3/24/2013 11:27:29 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

You cannot assign value to the Identity column. its meaningless.

if you want to change the starting value of your identity column, why not do it through a simple script?

context.Database
       .ExecuteSqlCommand("ALTER TABLE Place ALTER COLUMN Id IDENTITY (1000,1)");

this will insert Place.Id as 1000, for the first row in the table, and then 1001,1002... and so on for subsequent rows.

0
3/24/2013 10:56:19 AM

Popular Answer

Are you just wanting to do this in EF to learn the syntax? the reason I ask, is because you could set the seed on the column in SSMS (http://msdn.microsoft.com/en-gb/library/aa933196%28v=sql.80%29.aspx)

christiandev

Related Questions

Getting the value of an identity column after entering it in Entity Framework

wow! that was a nightmare but at last I solved it, although I didn't understand what the problem was. Maybe this helps someone with the same problem....Generate the script for creating the table and its data....Drop the table....Run the script.
entity-framework identity-column
asked by nima

Entity Framework error: Cannot insert explicit value for identity column in table

Try this:...using System.ComponentModel.DataAnnotations.Schema; [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)] public decimal Identity_Col { get; set; } ...The Entity Framework class file adds these lines of code to the Identity column.
c# entity-framework sql
asked by thomas

How can I force entity framework to insert identity columns?

EF 6... method, using the ...msdn article...:... using (var dataContext = new DataModelContainer()) using (var transaction = dataContext.Database.BeginTransaction()) { var user = new User() { ID = id, Name = "John" }; dataContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[User] ON"); ...
asp.net database ef-code-first entity-framework sql-server
asked by Roman O

Cannot insert the value NULL into column in ASP.NET MVC Entity Framework

I have encountered this problem multiple times while working with ...Microsoft SQL Server... and I have followed the same way to fix it. To solve this problem, make sure ...Identity Specification... is set to ...Yes.... Here's how it looks like:...In this way the column number ...auto increments... as a primary key normally would....HOW?:...right-c...
asp.net c# entity-framework
asked by youHaveAlsoBeenABeginner

Entity Framework 6 Code First int Identity column value is zero for first row

Your concrete migration class should look "something" like the following:...public class 201707132034165_MyAwesomeDbInitial : DbMigration { #region <Methods> public override void Up() { CreateTable( "dbo.HasOverdrive", c => new { HasOverdriveId = c.Int(nullable: false, identit...
c# ef-code-first entity-framework-6 sql-server
asked by Prisoner ZERO

Cannot insert explicit value for identity column in table 'MyTableName' when IDENTITY_INSERT is set to OFF

If you need insert a value on ID, try this...[Required, Key, DatabaseGenerated(DatabaseGeneratedOption.None)] public int ID{ get; set; }
asp.net asp.net-core-mvc c# entity-framework-6
asked by J4ime

EF6 entity with DatabaseGeneratedOption.Identity Guid Id force insert my Id value

You can achieve what you want by defining two contexts that derive from a base context. One context defines its keys with ...DatabaseGeneratedOption.Identity..., the other one with ...DatabaseGeneratedOption.None.... The first one will be your regular application's context....This is possible by virtue of Guid primary keys not being real identity c...
c# code-first database entity-framework entity-framework-6
asked by Gert Arnold

Cannot insert explicit value for identity column while updating entity

I tried this ... public override async Task<StudentDegreeDto> Create(StudentDegreeCreateDto input) { //CheckCreatePermission(); StudentDegreeCore st = new StudentDegreeCore(); try { StudentDegreeCore core = new StudentDegreeCore() { ...
aspnetboilerplate entity-framework entity-framework-6 identity-insert
asked by Nighil

Entity Framework - Cannot insert the value NULL into column?

If you want the column to be nullable, you should set the property of your model to a nullable type....public int? StudentId { get; set; } ...After this, you will have to create and run your migrations again.
c# entity-framework-6 visual-studio
asked by Jerodev

EF - pass null value to SQL column so default value gets inserted

Thanks to squillman's ...reference to another SO post..., I was able to find the answer. ...Go to EDMX diagram, and you can set the StoreGeneratedPattern property to achieve what I am trying to do....There are three Database Generated Options...Computed : The database generates a value when a row is inserted or updated. Identity : The database gene...
entity-framework-6 sql-server
asked by nanonerd

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow