tags:

views:

35

answers:

0
Q: 

How to map EF4 Complex Type as seperate/dedicated table in Database.

Is it possible to use EF4 ComplexType as Table (similar to EAV style)?

From the designer, I define ComplexType X as part of Entity A. In Database, I would like to have Table A and X, where table A has a foreign key to Table X.

related questions

Query several EAV attributes in separate columns
Using Magento's addFieldToFilter to filter by existing columns
How to pivot a MySQL entity-attribute-value schema
Property-values database
MySQL correlated subquery in JOIN syntax
Key/Value pairs in a database table
Best beginner resources for understanding the EAV database model?
How do I search a "Property Bag" table in SQL?
How to design a database for unkown amount of 'meta'-data
DataModel for Workflow/Business Process Application
Table Module vs. Domain Model
Choosing a method to store user profiles?
How to design a database schema to support tagging with categories?
SQL database problems with addressbook table design
Creating a Metatable table in a database
Optimal DB structure for additional fields entity
Questions about DB modelling...
datatype supplied by user for SQL field
Name Value pairs and fact tables
How to define structure in a tag-based organization?
Is there a Entity Attribute Value (EAV) framework out there for PHP/MySQL?
What is best practice for this problem (different properties for different categories)?
Performance of large EAV/open schema systems on SQL Server
what's the best implemention of client creatable and modifiable web forms in a relational database?
Designing an 'Order' schema in which there are disparate product definition tables