PATCH when working with DTO

asp.net-core c# entity-framework-core json-patch rest

Question

I'm working on asp.net core webAPi and EF core, and want to implement "update" operation (partially edit entity). I searched the correct way to deal with that, and saw that I should use jsonPatch. the problem is that I'm expose just DTOs through my API, and if I use jsonPatch like:

public AccountDto Patch(int id, [FromBody]JsonPatchDocument<AccountDto> patch)

then I need to apply the patch on DTO, and I can't apply it on the model entity, without create a new entity.

I also read about Odata.Delta, but it still not work on asp.net core, and furthermore - I don't think it has a built in solution for working with dto (I found this example that can help when Odata for core will be available)

So, for now - should I use POST and send DTO with list of changed properties in query (as I saw here), Or - there is more elegant solution?

Thanks!

1
9
5/23/2017 11:46:01 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Now I saw that using autoMapper I can do just

CreateMap<JsonPatchDocument<AccountDTO>, JsonPatchDocument<Account>>();
        CreateMap<Operation<AccountDTO>, Operation<Account>>();

and it work like a charm :)

5
7/31/2016 7:02:12 PM

Popular Answer

Eventually,

I just remove the type from JsonPatchDocument, and saw that it can work without type...

[HttpPatch("{id}")]
    public AccountDTO Patch(int id, [FromBody]JsonPatchDocument patch)
    {
        return _mapper.Map<AccountDTO>(_accountBlService.EditAccount(id, patch));
    }

And then, In BL layer, 

public Account EditAccount(int id, JsonPatchDocument patch)
    {
        var account = _context.Accounts.Single(a => a.AccountId == id);
        var uneditablePaths = new List<string> { "/accountId" };

        if (patch.Operations.Any(operation => uneditablePaths.Contains(operation.path)))
        {
            throw new UnauthorizedAccessException();
        }
        patch.ApplyTo(account);            
        return account;
    }
arielorvits

Related Questions

Entity Framework 6 "HasRequired" and "WithMany" partially working - not working as expected

The problem seems to be caused by the new ...initializers for auto-property... feature of C# 6....If you initialize the properties "inline" Entity Framework breaks on one to many relationships....Remove the initializers and the navigation properties should work again....public class Company { public virtual ICollection<BusinessUnit> BusinessUni...
.net c# entity-framework entity-framework-6
asked by Albireo

Entity Framework Core - Mapping Raw Query(DTO Class without ID field) , Scalar

Here is a class that will solve your needs....Usage var listOfEntity = DatabaseServices.ExecuteStoredProcedure(Stored Procedure Name, List of SqlParameter)...public class DatabaseServices : IDatabaseServices { private readonly ApplicationDbContext _applicationDbContext;... public DatabaseServices(ApplicationDbContext applicationDbCon...
c# dbcontext entity-framework entity-framework-core stored-procedures
asked by John Gnazzo

ASP.NET Core with EF Core - DTO Collection mapping

AutoMapper... is the best solution....You can do it very easily like this :... Mapper.CreateMap<Customer, CustomerDto>(); Mapper.CreateMap<CustomerDto, Customer>(); Mapper.CreateMap<Person, PersonDto>(); Mapper.CreateMap<PersonDto, Person>(); ...Note :... Because ...AutoMapper... will automatically map the ...List<Person>... to ...L...
asp.net-core asp.net-core-webapi automapper entity-framework-core
asked by Sampath

Entity Framework Core - REST json merge patch (Partial Update)

Its a bad pattern to use entity types, which reflect an internal schema (your database) in external interfaces (your api). ...but for a partial update you can use dynamic like this:...dynamic changedData = new { /* props you wanna change */ }; DataContext.Entry(yourEntity).CurrentValues.SetValues(changedData);
c# entity-framework entity-framework-core rest
asked by humbrie

Would the Entity Framework's navigational properties work if I drop foreign key constraints from the database?

At this case better to remove references from both classes and handle relations manually outside of these classes:...public class Sims { public int ID { get; set; } public string Code { get; set; } //public User User { get; set; } public int UserID { get; set; } }
c# entity-framework entity-framework-6 sql
asked by Slava Utesinov

Should one perform a calculation in a DTO model or in the destination entity model?

I'm currently creating various entities in ASP.NET Core 2.2 with accompanying DTOs for a Web API. The client application would submit a DTO object to the relevant controller action. There using the AutoMapper, this would be mapped from the DTO object to an entity object. The resulting entity object would be saved to an entity framework repository w...
asp.net-core c# dto entity-framework entity-framework-core
asked by ProgrammerMan

Map DTO to Entity

For model binding with ...Automapper..., follow steps below: ...Install package ...AutoMapper... and ...AutoMapper.Extensions.Microsoft.DependencyInjection...Add ...services.AddAutoMapper(typeof(Startup));... to ...Startup.cs...Add ...ModelProfile.cs... like ...public class ModelProfile: Profile { public ModelProfile() { CreateMap...
asp.net-core c# dto entity entity-framework-core
asked by Edward

How to map a list of related DTOs in a DTO: Nesting DTO mapping

This is Mapper profile example. Profile class comes from Automapper lib....public class ApplicationServiceAutoMapperProfile : Profile { public ApplicationServiceAutoMapperProfile() { //Don't use ForMember method if you want to show Id's CreateMap<Book, BookDTO>() .ForMember(m => m.Id, opt => opt.Ignore()); ...
asp.net-core c# dto entity-framework-core linq-to-sql
asked by Yigit Tanriverdi

Why some of my Data Annotations in my dto class are not working when I validate the Model in my WebApi?

System.Guid... is a value type and it has a default value (actually an instance of) ...Guid.Empty..., so it's never null. Because of that, the ...[Required]... attribute will always pass the validation....One of the solutions and probably the easiest one is to make the Guid nullable, like so:...[Required] public virtual System.Guid? Id { get; set;...
asp.net-mvc asp.net-web-api c# data-annotations entity-framework-core
asked by mladjo

How to patch enumerables and guids with OData V4 Delta in Asp.Net.Core 3.1

@whiskytangofoxtrot Assuming you're hitting your service from Postman (or equivalent), kindly ensure to include the Enum type annotation in the payload. As follows:...{ "@odata.context": "{{ServiceRoot}}/$metadata#Accounts/$entity", "Id": "3527ba9a-f5aa-4337-b7bb-dfe634b15e57", "OwnerId": "3527ba9a-f5aa-4337-b7bb-dfe634b15e57", "Sta...
asp.net-core entity-framework-core odata postman
asked by John Gathogo

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