Map View - Entity Framework

Question

I know it has been asked something similar, but in the answers I found said that to map the view should put the Dataannotation [Table("view name")] or configure in the Fluent API

I created a view in the database called "Users". So I created a class called Userview

[Table("Users")]
public class UserView 
{
  public string EmailAddress { get; set;} 
  ......
}

Then in my Dbcontext I created Dbset

public DbSet<UserView> Users { get; set; }

When I went around the application I had an error like "The model backing the context has changed Since the database was created."

So in the Nuget Package Console I came in with

Update-Database -force -verbose

Then I had a mistake that there is already an object called "Users". There on the console even showed a "CREATE TABLE USERS ...." IE, he tried to create the table.

I am using Automatic Migrations. How could I map this existing view and/or create it if it does not exist?

Answer 1

This is totally wrong. If you have a context managed by the Entity Framework, you cannot map read-only objects on it.

Create a second reading-only context, like this:

public class ReadOnlyContext: DbContext
{
    public ReadOnlyContext()
        : base("name=DefaultConnection")
    {
        Database.SetInitializer<ReadOnlyContext>(null);
    }
}

Put the DbSet who will read the view bank:

public class ReadOnlyContext: DbContext
{
    public ReadOnlyContext()
        : base("name=DefaultConnection")
    {
        Database.SetInitializer<ReadOnlyContext>(null);
    }

    public DbSet<UserView> UsersView { get; set; }
}