entity framework code first and view mapping

Question

I have a application using code first; in search section I have to gather information from 3 tables and their related tables so I made a view; and since there is no syntax for code first to create view (I think so; please let me know if I'm wrong) I used pure SQL script; on model creating to prevent EF to create a table with same name as table (VIEW_SEARCH) I did :

protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Ignore<View_Search>();
    }

any ways application works fine until you try to get data from the view then BANG...

The model backing the 'SearchContext' context has changed since the database was created. Consider using Code First Migrations to update the database (http://go.microsoft.com/fwlink/?LinkId=238269)

Try my solution. It prevents migration generation for tables marked as views — giokoguashvili
– giokoguashvili, Commented Jun 9, 2020 at 17:04

a'' · Accepted Answer · 2013-06-29 20:20:25Z

1

This error simply says that what you have in your model file is inconsistent with what you have in your database. To make it consistent go to Package Manager Console and type Enable-Migrations, then Add-Migration yourMigrationName and Update-Database. The error should disappear.

If you want to combine data from 3 tables you can simply create a ViewModel.

Let's say you have 3 models: Book, Author, BookStore and you want to have all information in one view. You create ViewModel

public class MyViewModel 
{
   public Book myBook {get; set;}
   public Author myAuthor {get; set;}
   public BookStore myBookStore {get; set;}
}

Then you add at the top of your all-in-one-view

@model myNamespace.MyViewModel

and access items like

Model.Book.title
Model.Author.name
Model.BookStore.isClosed

answered Jun 29, 2013 at 20:20

a''

2,3922 gold badges24 silver badges34 bronze badges

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

2 Comments

Navid Kianfar Over a year ago

maybe i dint give enough information; the migration is enabled and database is regenerating if model changes!!!!

Navid Kianfar Over a year ago

and about combination: i need them merged sth like this:

public class SearchResult     {         public SearchResult()         {             Query = null;             Total = TotalPages = 0;             Page = 1;             Result = new List<View_Search>();         }          public int Page { get; set; }          public string Query { get; set; }          public List<View_Search> Result { get; set; }          public int Total { get; set; }          public int TotalPages { get; set; }     }

Lester · Accepted Answer · 2016-03-08 19:53:45Z

0

I'm actually working with Entity Framework "Code First" and views, the way I do it is like this:

1) Create a class

[Table("view_name_on_database")]
public class ViewClassName {
    // View columns mapping
    public int Id {get; set;}
    public string Name {get; set;}
    // And a few more...
}

2) Add the class to the context

public class ContextName : DbContext {
    // Tables
    public DbSet<SomeTableClassHere> ATable { get; set; }
    // And other tables...

    // Views
    public DbSet<ViewClassName> ViewContextName { get; set; }

    // This lines help me during "update-database" command
    protected override void OnModelCreating(DbModelBuilder modelBuilder) {
        // Remove comments before "update-database" command and 
        // comment this line again after "update-database", otherwise 
        // you will not be able to query the view from the context.
        // Ignore the creation of a table named "view_name_on_database"
        modelBuilder.Ignore<ViewClassName>();
    }
}

answered Mar 8, 2016 at 19:53

Lester

7502 gold badges10 silver badges20 bronze badges

1 Comment

wtf512 Over a year ago

Got an error when read data: Value cannot be null (dont konw what is Value is ...)

Collectives™ on Stack Overflow

entity framework code first and view mapping

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related