How Do I Delete A Row With Linq To Entities

Question

0.00/5 (No votes)

See more:

Hi I post here my code

VB

Public Shared Function delete_config(ByVal configurazione As CanoniConfig) As Boolean
       Dim result As Boolean = False
       Dim configurazione_to_delete As ConfigurazioniCanoniFissi = Nothing

       Try
           Using dbContext As New P2000ProdwareEntities
               configurazione_to_delete = getFirstConfig(configurazione)
               If Not configurazione_to_delete Is Nothing Then
                   dbContext.DeleteObject(configurazione_to_delete)
                   dbContext.SaveChanges()
               End If
               result = True
           End Using
       Catch ex As Exception
           result = False
       End Try
       Return result
   End Function

configurazione_to_delete is the instance to the row that need to be deleted and it's not nothing.

If I run this code I obtain this
"Can not delete the object because it was not found in ObjectStateManager."

What is wrong?
Thank you!

Posted 21-Jul-15 21:51pm

gregorio89

Updated 21-Jul-15 21:54pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

gregorio89 · Accepted Answer · 2015-07-27T00:43:00

Done.
The problem was that the operation of updating or deleting rows must be
l between using statement so if you get the row with getfirst config your modifying that have no effect.
so the code is this

Public Shared Function delete_config(ByVal configurazione As CanoniConfig) As Boolean
    Dim result As Boolean = False
    Dim configurazione_to_delete As ConfigurazioniCanoniFissi = Nothing
    Try
        Using dbContext As New P2000ProdwareEntities
            configurazione_to_delete = (From e In dbContext.ConfigurazioniCanoniFissis
                                  Where e.ChFase = configurazione.chfase And e.ChTecnica = configurazione.chtecnica And e.Commessa = configurazione.commessa And e.ChCliente = configurazione.chcliente
                                  Select e).First
            If Not configurazione_to_delete Is Nothing Then
               dbContext.DeleteObject(configurazione_to_delete)
                dbContext.SaveChanges()
            End If
            result = True
        End Using
    Catch ex As Exception
        result = False
    End Try
    Return result
End Function