Mapping a DTO to an Entity with Automapper

automapper c# entity-framework

Question

I have an Entity Framework POCO with the following structure.

public class Entity
{
    public virtual int Id { get; set; }
    public virtual string Name { get; set; }
}

I've created a Data Transfer Object for this entity to be used by my views.

public class EntityDto
{
    public int Id { get; set; }
    public string Name { get; set; }
}

Now, I have the following mapping code in my Global.asax file.

Mapper.CreateMap<Entity, EntityDto>();
Mapper.CreateMap<EntityDto, Entity>(); // not sure whether I need this as well?

Everything is working fine, I pass the DTO to my views OK and I can create a new instance of Entity from my EntityDto model. The problem arises when I try to edit my Entity; I'm aware this is down to AutoMapper losing the Entity Key that EF creates to track changes to the object, but having read through a few sources there doesn't seem to be a definitive solution. Here is the action I'm using to edit my entity.

public ActionResult EditEntity(EntityDto model)
{
    var entity = context.Entities.Single(e => e.Id == model.Id);
    entity = Mapper.Map<EntityDto, Entity>(model); // this loses the Entity Key stuff
    context.SaveChanges();

    return View(model);
}

Now, what do I do to solve this? Can I:

  1. Somehow tell AutoMapper to .Ignore() the Entity Key properties?
  2. Get AutoMapper to copy out the Entity Key properties?
  3. .Attach() my mapped Entity and set the state to modified?

Any help always appreciated.

1
9
10/31/2012 11:04:36 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

.Attach() my mapped Entity and set the state to modified?

public ActionResult EditEntity(EntityDto model)
{
    var entity = Mapper.Map<Entity>(model);
    context.Set<Entity>().Attach(entity); // (or context.Entity.Attach(entity);)
    context.Entry<Entity>(entity).State = System.Data.EntityState.Modified;
    context.SaveChanges();
    return View(model);
}

Where is your context instantiated? You should do that in your EditEntity action imo.

public ActionResult EditEntity(EntityDto model)
{
    using(var context = new MyContext())
    {
        var entity = Mapper.Map<Entity>(model);
        context.Set<Entity>().Attach(entity); // (or context.Entity.Attach(entity);)
        context.Entry<Entity>(entity).State = System.Data.EntityState.Modified;
        context.SaveChanges();
        return View(model);
    }
}
10
4/3/2017 11:57:03 AM

Popular Answer

Try passing entity as a second parameter to your mapping.

entity = Mapper.Map<EntityDto, Entity>(model, entity);

Otherwise, your entity instance is overwritten with a new instance, and you lose the entity created in the first line.

dark_ruby

Related Questions

AutoMapper + Entity Framework ( Entity to DTO and DTO to Entity )

The problem I had was related to updates to EntityCollection references. AutoMapper creates a new instance of the relation when mapping from the DTO to the Entity, and that doesn't please the EF....What solved my problem was configuring AutoMapper to use the destination value for my EntityCollection properties. In your case:...Mapper.CreateMap< Cus...
automapper c# dto entity-framework
asked by Pablo Montilla

Automapper causing error: missing type map configuration or unsupported mapping

I am new to Automapper....I have added Nuget package - Automapper into my Manager (BLL) and DAL layer....Now, below is related stuff:...Below is the statment of Manager library that giving me exception:...this.dataRepository.Update(Mapper.Map<StudentMaster>(studentDTO)); ...Exception is as follow:...Missing type map configuration or unsupported map...
automapper-3 entity-framework-6 nuget-package
asked by user3711357

How to map a nullable property to a DTO using AutoMapper?

I think you may be able to solve this problem simply....Consider the following example:...public class A { public int? Foo { get; set; } public MyEnum? MyEnum { get; set; } } public class B { public string Bar { get; set; } public string MyEnumString { get; set; } } ...The following mapping statement will resolve them as desired:...
automapper c# entity-framework linq
asked by NWard

Saving AutoMapper mapped Collections of Entities using Entity Framework

I have the following Entity Framework Entities:...public class Region { public int RegionId { get; set; } // Primary Key public string Name { get; set; } public virtual ICollection<Country> Countries { get; set; } // Link Table } public class Country { public int CountryId { get; set; } // Primary Key public string Name { get; s...
.net automapper c# entity-framework entity-framework-6
asked by Muhammad Rehan Saeed

Cleanest Way To Map Entity To DTO With Linq Select?

I've been trying to come up with a clean and reusable way to map entities to their DTOs. Here is an example of what I've come up with and where I'm stuck. ...Entities...public class Person { public int ID { get; set; } public string Name { get; set; } public Address Address { get; set; } // Other properties not included in DTO } ...
c# entity-framework linq linq-to-entities linq-to-sql
asked by Bacon

AutoMapper binding issues with Entity Framework mapping

I'm using AutoMapper as an ORM in application with Entity Framework v6....My problem statement is that if I executes a single query via LINQ to Entities on any single entity and maps entity data via AutoMapper with DTO, many other queries will be executed at the same time while data binding....Kindly anyone let me know, how to avoid this problem.
automapper c# entity-framework-6 linq-to-entities
asked by Faisal

Automapper - Missing type map configuration or unsupported mapping

Been struggling with this for a day now to no avail. I am new to Automapper and I am trying to map a EF domain object with a viewModel but I receive the following exception:...Missing type map configuration or unsupported mapping.\r\n\r\nMapping types:\r\nCatalogueDefinitionFile -> CatalogueDefinitionFileViewModel\r\nDigital.PriceBuilder.Core.Domai...
asp.net-mvc automapper c# entity-framework
asked by jgill09

AutoMapper 6 - How can I create a mapping that ignore and map a list of object

You are trying to access QuitacoesDocFinan collection in DocFinanceiroViewModel constructor before initializing. Your DocFinanceiroViewModel should be something like this:...public class DocFinanceiroViewModel { public virtual ICollection<QuitacaoDocFinanViewModel> QuitacoesDocFinan { get; set; } public decimal ValorPago { get ...
asp.net-mvc-5 automapper-6 ef-fluent-api entity-framework-6
asked by ZingerCar

Missing map CreateMap exception for related entity (AutoMapper & code first)

The Config should have been:... var config = new MapperConfiguration(cfg => { cfg.CreateMap<Product, ProductBase>() .ForMember(pob => pob.ProductOptionsBase, opts => opts.MapFrom(po => po.ProductOptions)); cfg.CreateMap<ProductOption, ProductOptionBase>(); }); ...There is also no need to u...
automapper c# entity-framework-6
asked by brioni

Entity Framework stored column mapping issue with DTO

Your select statement does not return any column with the name ReferenceNumber or BookingNumber. Property names in the objects must match those in data reader for this to work. You can either rename the database columns to match exact properties names on your model or rename property names on your model to match database column names....Alternative...
.net c# entity-framework-6 linq sql-server
asked by codein

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow