How i can set IDENTITY_INSERT to ON in "LINQ to SQL" ?

[humais]

i'm getting an error that "Cannot insert explicit value for identity column in table 'Comment' when IDENTITY_INSERT is set to OFF" i'm using "LINQ to SQL" in ASP.NET so how can i set IDENTITY_INSERT to ON? :^)

[TheGreatAndPowerfulOz]

use a stored procedure

"If your actions inspire others to dream more, learn more, do more and become more, you are a leader." - John Quincy Adams "Let me get this straight. You know her. She knows you. But she wants to eat him. And everybody's okay with this?"

[Vika Dev]

Why are you trying to insert an identity value? These are usually incremented automatically when a row is inserted into the DB and inserting your own value could cause a duplication in this column. You can open the table in Management Studio and turn off the indentity property for the column. Mike

[Bryian Tan]

hello, This thread might help IDENTITY_INSERT and linq[^]

[humais]

i'm using BlogID as primary key in Blog table & as a foreign key in Comment table.i'm trying to save BlogID manually in comment table from Query String in comment page.Tell me how i can do it? :confused:

[Ali Al Omairi Abu AlHassan]

How ?

Help people,so poeple can help you.