Linq To Sql Delete

[news.microsoft.com]

Hello people:

First of all forgiveness for my English.
I am working with Linq to SQL, Visual Studio 2008 and SQL Server 2000.
When you delete a record and then go back to Insert (ie, insert a record
with the same primary key)
and I run SubmitChange it generates an key duplicate exception.
I am reviewing the SQL commands generated by linq, and I see that attempts
to run
first insert command, and then delete command.
I imagine that this is the problem because I expected the first run delete
and then Insert.
Any thoughts on this?
Thanks

[Mannen]

"news.microsoft.com" <si*****@hotmail.comwrote in message
news:uA**************@TK2MSFTNGP02.phx.gbl...

Hello people:

First of all forgiveness for my English.
I am working with Linq to SQL, Visual Studio 2008 and SQL Server 2000.
When you delete a record and then go back to Insert (ie, insert a record
with the same primary key)
and I run SubmitChange it generates an key duplicate exception.
I am reviewing the SQL commands generated by linq, and I see that attempts
to run
first insert command, and then delete command.
I imagine that this is the problem because I expected the first run delete
and then Insert.
Any thoughts on this?
Thanks

Either use a (different) n-tier application structure or use the Attach()
method if you need to update entries. For example you can use
myDB.Attach(myEntry, true) to attach myEntry as modified, which will
translate into the (SQL) UPDATE-command.