Skip to content

Scaffold views into SQL definitions on the model #20940

@MM-RYO

Description

@MM-RYO

Hi,

I just run the Scaffold-DbContext command to generate DBModels. and we also want DB Views to be included in the generated DB Context. but we found the codes are not correct. it should call the ToView method instead of ToTable. please check the below codes. thank a lot.

modelBuilder.Entity("VTest", b =>
{
    b.Property<int?>("TestId1").HasColumnType("integer");
    b.Property<string>("TestId2").HasColumnType("text");
    b.ToTable("V_Test","public");
});

Steps to reproduce

Run below command

Scaffold-DbContext "****" Npgsql.EntityFrameworkCore.PostgreSQL -OutputDir Models

Further technical details

EF Core version: 3.1.3
Database provider: Npgsql.EntityFrameworkCore.PostgreSQL 3.1.3
Target framework: .NET Core 3.1
Operating system: Win 10
IDE: Visual Studio 2019 16.5.4

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions