Using entity framework, how to map a function?

Question

I'm using entity framework, and imagine that I have a function where returns a table with the following columns:

StudentId : smallint
TestTemplateId : smallint
Date : date

As you can see, I'm returning a table with only ids. In the application I have a classes like Student and TestTemplate, I don't know if it will be possible that the function can map to complex objects.

undefined · Accepted Answer · 2012-10-22 06:49:27Z

1

What you are looking for is Entity Framework Navigation Properties. These allow you to represent foreign key relationships in your database as direct object links in your model.

Ive written an intro tutorial to code first navigation properties which is available here: http://blog.staticvoid.co.nz/2012/07/entity-framework-navigation-property.html

edited Oct 22, 2012 at 6:49

answered Oct 22, 2012 at 6:30

undefined

34.4k23 gold badges136 silver badges203 bronze badges

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

2 Comments

Darf Zon Over a year ago

Yes, I'm looking for that! So, when a create a foreign relationship, by default do I create a navigation property?

undefined Over a year ago

@DarfZon When i write ef I normally let EF manage database schema updates via EF migrations. This means i only need to modify my EF entity classes to add in a navigation property (which when migrations runs creates the foreign key in the database). However if you are manually performing your DB updates you can do it in both the EF Entities and database to produce the same effect

Collectives™ on Stack Overflow

Using entity framework, how to map a function?

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