Update existing row mysql linq

Question

I have html page with table. When I change field I need to re-save existing record in table.

public int SaveTask(TimesheetListModel task, int userId)
{
    var worklog = new tblWorkLog();

    if (task != null)
    {
        worklog.AccountId = userId;     
        worklog.WorkDate = task.Date;
        worklog.Note = task.Note;       
        worklog.TaskTitle = task.Task;

        DataContext.tblWorkLogs.InsertOnSubmit(worklog);

        DataContext.SubmitChanges(ConflictMode.FailOnFirstConflict);
    }

    return worklog.WorkItemId;
}

This function saves data to table tblWorklogs and returns me id of record. But when I updating record, I already have id of record and I need to find this record in table and update fields. How to do this? I wrote begin function:

public bool UpdateTask(TimesheetListModel task)
{
    /* If update succefull must return true */
    return false;
}

JEV · Accepted Answer · 2015-09-15 08:47:44Z

3

Not too sure on your implementation but depending on the context you could do something like.

public bool UpdateTask(TimesheetListModel task)
{
    var entity = DataContext.tblWorkLogs.FirstOrDefault(twl => twl.Id == task.Id);
    if (entity != null)
    {
      entity.AccountId = userId;     
      entity.WorkDate = task.Date;
      entity.Note = task.Note;       
      entity.TaskTitle = task.Task;
      DataContext.SubmitChanges();
      return true;
    }

    return false;
}

The logic behind it is:

Attempt to retrieve entity from Database.
If it exists, edit property/properties as desired
Save Changes

This all relies on whether you are tracking entities, otherwise you have to Attach the entity.

answered Sep 15, 2015 at 8:47

JEV

2,5224 gold badges36 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update existing row mysql linq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related