vovasight.blogg.se

To do so the easiest possible way, I just added a method to my ASP.NET Core API. Just remember to remove HasNoKey in configuration and attribute in the entity. You can specify a view with a key, though. This way we do not need to have a key in the result, but it also means that it would only be read-only model.Ĭurrently, Entity Framework Core 5 does not support updating the view, while it is possible in SQL Server database. Notice that we configure RoomOccupied entity to have no key. However, there is a tiny detail that makes this collection different. Protected override void OnModelCreating(ModelBuilder modelBuilder)Īs you can see it is a normal DbSet, that can be queried as we wish. Public PrimeDbContext(DbContextOptions options) Let’s see how that can be accomplished: public class PrimeDbContext : DbContext

Now we need to add a DbSet to my PrimeDbContext and we need to configure our model, so that RoomsOccupied will be executed against view.

In my case, to map all view’s columns, we need to create a RoomOcupied model, that would look like this: In Entity Framework Core 5 views can be represented as a regular DbSet. This kind of data can be useful for example when planning maintenance. This view presents rooms that are occupied, where we can filter by date. Protected override void Down(MigrationBuilder VIEW vwRoomsOccupied") SELECT r., r., ro.Number As RoomNumber, ro.Level, ro.WithBathroom Protected override void Up(MigrationBuilder migrationBuilder) Let’s see how it may look: public partial class vwGuestArrivals : Migration This will generate a migration, that we can put our SQL into. Let’s start by adding a migration with EF Core global tool command: dotnet ef migrations add vwGuestArrivals The best way to do so is to add a database migration with an appropriate SQL.

Adding a viewįirst of all, we need to add a view to the database. Entity Framework Core 5 can handle views and in this article, I’m going to show you how. They are typically used as read-only objects that are optimized to provide data for a given scenario. In SQL, a view is a virtual table based on the result-set of an SQL statement.