Entity Framework Core - Knowledge Base (KB)

PATCH when working with DTO

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, a...

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

EF Core supports Json Patch - ...RFC6902...https://github.com/aspnet/JsonPatch...I wanted to add support for Json Merge Patch in my app - ...RFC7396...I am new to entity framework....I tried following, it works fine, but wanted to know if the implementati...

ASP.NET Core 2.0 web api Entity Framework Core - looking for a more elegant solution

I am working on a web api project on ASP.NET Core 2.0 with Entity Framework Core connecting to a postgres database....The following PUT method works without at problem but I feel I might be misunderstanding the use of the update method and I also feel lik...

include only returning one row and not closing json

I'm having difficulty with my .NET Core Api 2.1....I set up a database in SQL Server 2017 and created my tables with all the proper conventions, FK's, PK's and so on....The tables are structured as follows:...Contacts:...namespace ContactsApi { public...

Entity Framework Core API return table with .Include

I have a Model with ICollection:...public class Blog { public int Id { get; set; } [Required] public string Name { get; set; } public ICollection<Posts> Posts { get; set; } } ...This works with MVC:...public async Task<IActionResult> Ind...

Unable to run web api (gateway) project - This localhost page can’t be found. No webpage was found for the web address:

I am trying to setup and run this git project - ...https://github.com/johnph/simple-transaction#WebApi-Endpoints...I have successfully clean up and re-build the whole solution. I have successfully configure to perform EF Core Code-First migration and data...

Related data in tables using Entity Framework

I have a question on related data in tables using Entity Framework. I have 2 tables "customer" && "customerpreferences", since both tables have customer, then the primary key is "Id_Cus". I reviewed eager, lazy loading. It was decided to use eager loading...

Best way of using/querying many databases with the same model with EF Core 2.2

I'm currently working on a project and for some strange reason I have to use 32 different SQL Server databases with the same model. These databases have different information but the same exact design. ...For some stupid requirement I can't unify these da...