C# EF code-first create SQL view query

Question

I was trying to create a view from EF code-first. Unfortunately after my research, I couldn't find any topics about it.

I can get my SQL view queries using EF database-first, but can't get it from code-first.

Can someone help me ?

Thanks...

enter image description here

Embri · Accepted Answer · 2017-01-24 11:44:19Z

1

You can create views inside a Migration using the Sql method:

public partial class Migration : DbMigration
{
    public override void Up()
    {
        this.Sql("CREATE VIEW dbo.MyView AS (etc)");
    }

    public override void Down()
    {
        this.Sql("DROP VIEW dbo.MyView");
    }
}

There's not any problem to map an entity to a view, in your dbContext:

public class MyDbContext : DbContext
{
    public DbQuery<MyModelView> MyView
    {
        get
        {
            // Don't track changes to query results
            return Set<MyModelView>().AsNoTracking();
        }
    }
}

answered Jan 24, 2017 at 11:44

Embri

6223 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

hakan Over a year ago

EF says: The entity type is not part of the model for the current context.

Embri Over a year ago

@hakan maybe you are trying to modify the state of the entity and you can not do that..

Collectives™ on Stack Overflow

C# EF code-first create SQL view query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related