Using database first entity with code first entity in entity framework

Question

I am working in an asp.net MVC 4 application and I am using Entity framework 6 in my application. I am using both code first approach for new tables/entities as well as database first approach with model designer(edmx). Customers are in codefirst model with separate context where as vehicles are in edmx. both have different context object. I want to use a query like this:

return View(maindb.Reservations.Include("customer").Include("Vehicle"));

but it returns error:

A specified Include path is not valid. The EntityType 'myproject.Data.Reservation' does not declare a navigation property with the name 'Vehicle'.

Please suggest how to fix it so that I can get properties of Vehicle and use them in my view.

Dennis · Accepted Answer · 2013-12-17 05:45:15Z

1

I am using both code first approach for new tables/entities as well as database first approach with model designer(edmx)

Wrong way to go.

Please suggest how to fix it

Put those entities into the same context. You need to choose which approach is more suitable for you. For example, code first works as well with existing tables. If your tables don't match the naming conventions, you can easily override them with data annotations or fluent API, which is very flexible (see http://msdn.microsoft.com/en-us/data/jj591617 and http://msdn.microsoft.com/en-us/data/jj591620).

answered Dec 17, 2013 at 5:45

Dennis

37.9k11 gold badges87 silver badges157 bronze badges

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

Collectives™ on Stack Overflow

Using database first entity with code first entity in entity framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related