How to relate a SQL based entity with an Object based entity in Entity Framework
- From: "markla" <markla@xxxxxxxxxxxxxxx>
- Date: Fri, 3 Oct 2008 22:37:35 +1000
Hi,
I have an Entity data model built in Entity Framework, which sources data primarily from an MS SQL 2008 database, and sources some static (data dictionary) values from code-based objects. I know I *could* store the data dict values in SQL: for various reasons that's not the path I want to take.
I have some lookups, which are based on code-based Objects. They are encapsulated in Objects because the values can change during processing, and are not persisted to the database, and they derive from "EntityObject" so they are EF-ready.
For example, I may have an EF object "Event", and an Object type "EventType". Event is stored in the database, however EventType is loaded depending on what types I support in an application variant (depending on DLLs loaded).
In looking at the edmx file and other info, I can't see how to mix SQL and Non-SQL Object based entities.
How can I create an EF relation between the SQL based "Event", and an Object based "EventType"?
Thanks in advance for assistance,
+Mark
.
- Follow-Ups:
- RE: How to relate a SQL based entity with an Object based entity in Entity Framework
- From: "Steven Cheng"
- RE: How to relate a SQL based entity with an Object based entity in Entity Framework
- Prev by Date: Can I set the width of scroll bar on asp Panel webcontol?
- Next by Date: Re: Custom Configuration Sections in Location Tag
- Previous by thread: Can I set the width of scroll bar on asp Panel webcontol?
- Next by thread: RE: How to relate a SQL based entity with an Object based entity in Entity Framework
- Index(es):
Relevant Pages
|
