tags:

views:

36

answers:

1
Q: 

Does EF4 support mapping 1 component from several tables?

At my company we have a database with one table being so big that it was splitted into 3 tables. They all share an ID and the info is NOT normalized so there is info for several entities in the tables, some entities actually have some fields in one table and some fields in the other tables.

There is a new project and they want to use nHibernate to map it, so that the code uses the ORM and we work on objects rather than query strings.

One of the problems we are having is that we are using nHibernates fluent "join" to map the 3 tables into one, but nHibernate won't let you map components inside joins, also it seems liek you cant map components that are split several tables.

Is Entity Framework 4 capable of doing this?

+2  A: 

Yes. So does EF 1. It's called entity splitting.

Craig Stuntz  2010-09-17 20:25:03
Little on the short side, but it was a good place to start looking for info, thanks!
Francisco Noriega  2010-09-20 15:41:05
As any evil overlord wizard worth his salt knows, once you know something's true name, you can control it.
Craig Stuntz  2010-09-20 15:57:42

related questions

IQuery NHibernate - does it HAVE to be a list?
(N)Hibernate - is it possible to dynamically map multiple tables to the one class
How can I map a list of strings to my entity using NHibernate?
Best practices for querying with NHibernate
NHibernate ISession Flush: Where and when to use it, and why?
IList.Cast<typeof(T)>() returns error, syntax looks ok
NHibernate Generators
101 tutorial for setting up nhibernate?
NHibernate Session.Flush() Sending Update Queries When No Update Has Occurred
NHibernate SetTimeout on ICriteria
Best way to manage session in NHibernate?
Has anyone moved to NHibernate 2.0 in a production environment?
NHIbernate: Difference between Restriction.In and Restriction.InG
NHibernate and Oracle connect through Windows Authenication
Is it possible to use nHibernate with Paradox database?
NHibernate 1.2 to 2.0 migration
NHibernate vs LINQ to SQL
Windows Service Increasing CPU Consumption
(N)Hibernate Auto-Join
MSTest and NHibernate
SQL 2008 Dialect Support for NHibernate
ADO.NET Entity vs NHibernate
Data Auditing in NHibernate and SqlServer
Best way to model Many-To-One Relationships in NHibernate When Dealing With a Legacy DB?
Subsonic Vs NHibernate