EF how to use derived condition if the property is a navigation property in other model

Question

Hi all,

do you know if in EF 4 we can have a navigation property in a conditional field.

My database is simple i have two tables "ListAll" and "TypeList"

Structure of ListaLL
Id int
TypeListId int (Foreign key of TypeList)
Value nvarchar(max)

Structure of TypeList
TypeListId int
Name navarchar(max)

in my edmx i have a base class Listall and a derived class for each TypeList with for each derived class a condition TypeListId specific.

Now if i want to add in my edmx, the TypeList table (for display in the user interface) i can't add it, because the ListAll doesn't expose anymore the TypeListId ! and none of the derived class expose it.

So how can i do that ?

 

 

Answer 1

I would use a view or stored procedure to expose the data in the TypeList table.

http://weblogs.asp.net/kencox/archive/2009/11/25/using-a-stored-procedure-in-entity-framework-4.aspx

Answer 2

Hello Didier9658,

 

I am writing to check the status of the issue on your side.  Would you mind letting us know the result of the suggestions?  And because your thread has lasted for a long time, I will close it for you by marking an answer.
 
If you need further assistance, please feel free to let me know.   I will be more than happy to be of assistance.

Have a nice day.

---

Jackie Sun [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.