Linq update with using automapper?

Question

[HttpPost]
public ActionResult _EditCustomer(CustomerViewModel CustomerViewModel)
{
    if (ModelState.IsValid)
    {
        try
        {
            Customers customer = entity.Customers.FirstOrDefault(x => x.sno == CustomerViewModel.sno);
            customer = AutoMapper.Mapper.Map<CustomerViewModel, Customers>(CustomerViewModel);
            entity.SaveChanges();

            return Content("<div class=\"success\">Müşteri düzenleme işlemi başarılı.</div>", "text/html");
        }
        catch (Exception e)
        {
            ModelState.AddModelError("", "Müşteri güncelleme hatası.");
        }
    }

    //Updating customer is failed!
    CustomerViewModel.Cities = entity.Cities;
    CustomerViewModel.PowerSuppliers = entity.PowerSuppliers;
    CustomerViewModel.Sectors = entity.Sectors;

    return PartialView(CustomerViewModel);
}

I debugged the code, and then in runtime customer is updating(automapper is working, I can see the changes), but entity.SaveChanges(); is not working.

Is there any another way to update records, when using automapper?

Thanks in advance.

score 1 · Accepted Answer · answered Nov 27 '12 at 09:04

1

Your code creates new customer entity, which is not attached to context:

var newCustomer = Mapper.Map<CustomerViewModel, Customers>(CustomerViewModel);

To update existing entity, use following Map method of automapper:

Mapper.Map(CustomerViewModel, customer);

answered Nov 27 '12 at 09:04

Sergey Berezovskiy

232,247
41
429
459

`Customers customer = entity.Customers.FirstOrDefault(x => x.sno == CustomerViewModel.sno); customer = AutoMapper.Mapper.Map(CustomerViewModel, customer); entity.SaveChanges();` – AliRıza Adıyahşi Nov 27 '12 at 09:16
1

I sorry, I think problem is customerId=0 I use hiddenFor but it returns 0 – AliRıza Adıyahşi Nov 27 '12 at 09:28
Error: "Missing type map configuration or unsupported mapping." – AliRıza Adıyahşi Nov 27 '12 at 09:42
You should create mapping: `Mapper.Create();` Also I'd use different name for `CustomerViewModel` parameter, at least one which is camel-case `customerViewModel`. – Sergey Berezovskiy Nov 27 '12 at 09:45
In my App_Start, I have this: `Mapper.CreateMap();` and this: `Mapper.CreateMap();`. – AliRıza Adıyahşi Nov 27 '12 at 09:50
When I try to create new Customer with mapper it work. But I try to use your suggestion map method, I get this error. – AliRıza Adıyahşi Nov 27 '12 at 09:52
@AliRızaAdıyahşi this method works, when appropriate mapping exist. Set a breakpoint and verify your `customer` when you getting it from context. Maybe it has `null` value. – Sergey Berezovskiy Nov 27 '12 at 10:06
It is not null. I use auto mapper to save my time, but it is the exact opposite :) I cant do your suggestion.Also, Thanks for helps. – AliRıza Adıyahşi Nov 27 '12 at 10:13
@AliRızaAdıyahşi I did that trick many times and it works. According to your exception, something wrong with you mapping. http://stackoverflow.com/questions/1942691/getting-an-exception-with-automapper – Sergey Berezovskiy Nov 27 '12 at 10:24

Linq update with using automapper?

1 Answers1