System.Data.Objects.ObjectSet does not contain definition "Remove"

Harlem 98

4y1.1k.NET

Hello community.

Im having a very confusing error.. I implemented a manual Delete method for deleting rows from a grid. I implemented the method in 2 different classes, in one of them it worked without problems, in the other is throwing the mentioned error

"System.Data.Objects does not contain definition for "Remove" and no extension method "Remove" accepting a first argument of type.... could not be found."

I'm using the namespace System.entity.data... Do you have any ideias on the problem, or equivalent alternatives for delete method (used through BLL logic in TelerikRadGrid with Delete Command)

public void DeleteFile(int ID)
{
try
{
using (GPEntities lt = new GPEntities())
{
ListagemTimesheet ddelete = lt.ListagemTimesheets.Find(ID);
lt.ListagemTimesheets.Remove(ddelete);
lt.SaveChanges();
}
}

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar4y ago
Accepted answer
Hi,

Please use this one,
public void DeleteFile(int id)
        {
            try
            {
                using (GestaoProjectosEntities lt = new GestaoProjectosEntities())
                {
                    ListagemTimesheet deptDelete = lt.ListagemTimesheets.FirstOrDefault(x => x.Id = id); //FirstOrdefault
                    lt.ListagemTimesheets.DeleteObject(deptDelete);
                    lt.SaveChanges();
                }
            }
            catch (Exception ex)
            {
            }
        }
Harlem 984y ago
Thank you both for the help :)
Harlem 984y ago
I saw the documentation, but made no help because i´m programatically defining the method, as i show in teh sample, because i'm using layers architecture.

I dont have any error now, but when debugging, the method gets the datakey, but doesen't delete it from DB.
Srinivasan Ramamoorthi4y ago
Can you check this articel too?
https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/data-editing/delete-records/overview
Srinivasan Ramamoorthi4y ago
Are you getting same exception with DeleteObject()?
Harlem 984y ago
Thank you, replacing by DeleteObject is actually more adequate to my code.

Nevertheless, still, the method is not working.

Please take a look on my full code (i'm using telerik rad grid command controls)
BLLListagemTimesheets listagembll = new BLLListagemTimesheets();

//ListagemTimesheets is the data table, and GestaoProjetosEntities the  complete object source

//Method BLL
public void DeleteFile()
        {
            try
            {
                using (GestaoProjectosEntities lt = new GestaoProjectosEntities())
                {
                    ListagemTimesheet deptDelete = lt.ListagemTimesheets.FirstOrDefault(); //FirstOrdefault
                    lt.ListagemTimesheets.DeleteObject(deptDelete);
                    lt.SaveChanges();
                }
            }
            catch (Exception ex)
            {
            }
        }

//CS code
  else if (e.CommandName == "Delete")
            {
                //GridDataItem item = (GridDataItem)e.Item;
                //var itemIndex = e.CommandArgument;
                var ID = (int)((GridDataItem)e.Item).GetDataKeyValue("ID");
                try
                {
                    listagembll.DeleteFile();
                }
                catch (System.Exception)
                {
                    //ShowErrorMessage();
                }


protected void gvTimesheets_DeleteCommand(object sender, GridCommandEventArgs e)

        {

            GridEditableItem editedItem = e.Item as GridEditableItem;
            int ID = 0;
            ID = Convert.ToInt32(editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["ID"]);
            //BLLListagemTimesheets.DeleteFile(ID);
            BLLListagemTimesheets.DeleteObject(ID);
            BLLListagemTimesheets.SaveObject();

        }
Srinivasan Ramamoorthi4y ago
Can you also share the code for other class that is working?
Srinivasan Ramamoorthi4y ago
Ideally the error shouldnt be coming, can you try DeleteObject() method.