Entity Framework Core - Knowledge Base (KB)

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

Circular dependency in ASP.NET Core

For school we have to write our own WebApi using the .NET Entity Core Framework. I've written my api but when I tried to use it in swagger, it always returned a HTTP 500 error: internal server error. I downloaded Fiddler to start debugging and came across...

Why can't I get all data related to my model?

I'm using lazyloading to get all my related data and return json to my API. But I can't seem to get all my related data....Not sure how to use the include syntax correctly either....public class Recipe { public int Id { get; set; } public string R...

Entity Framework Core 2.2.6 Many-to-Many relationship (extra column at table creation)

I'm trying to configure many-to-many relationship in Entity Core, based on that discussion:...https://github.com/aspnet/EntityFrameworkCore/issues/1368...After configuration database is created, with extra column (ProducerId in Movies table), as shown her...

ef core best practice to update complexe objects

We are leading into some issues with ef-core on sql databases in a web-api when trying to update complexe objects on the database provided by a client....A detailed example: When receiving an object "Blog" with 1-n "Posts" from an client and trying to upd...

Retrieve data from multiple database tables to API in ASP.NET Core

I have a database in SQL Server stored locally with a number of different tables, all connected together by different types of relations (one-to-many and many-to-many). You can see some of theme like this:...I created a Web API for these with Entity Frame...

Creating a .NET Core web api that has a route access to an existing Database

Currently I am reading some documentations on creating web API using the Database first approach. I noticed that most of the tutorials migrate their table on their application. How do I make an web api that only expose or has one route to expose the table...

Access existing connection string in web.config to new .NET Core Web API

I am new to .NET Core Web API. I was able to create a .NET Core Web API using the documentation provided and help from the people here. Documentation shows a way to access the database by putting a connection string in the ...appsettings.json... which inc...