http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Mark, you can use DBLink to make the disparate database works, so yes. For using Web Services, the answer is that technically, you may be able to do it. Practically, it is not really a good solution, at least not in my opinion. http://ayende.com/2327/multi-table-entities-in-nhibernate#comment6http://ayende.com/2327/multi-table-entities-in-nhibernate#comment6Thu, 03 May 2007 06:06:16 GMTIs this something that can be done when the tables are in different databases? A specific example might be that most of a salepersons information (address etc) is stored in an HR database however other information (general ledger code?) might be stored in a Financial systems database. Can these be brought together into one single entity. To push the example even further, is there any way to make one of the sources a web service rather than a database table? http://ayende.com/2327/multi-table-entities-in-nhibernate#comment5http://ayende.com/2327/multi-table-entities-in-nhibernate#comment5Thu, 03 May 2007 04:41:30 GMTHm, the assoication in NHibernate for multi table entities is using a column in the sub-table that matches the PK of the entity. I am not sure that I follow why this is a limitation, since I can't quite figure how you can have a single entity in multiply tables without assoication between them. http://ayende.com/2327/multi-table-entities-in-nhibernate#comment4http://ayende.com/2327/multi-table-entities-in-nhibernate#comment4Wed, 02 May 2007 09:22:24 GMT>?? Can you explain? Do you mean the entity framework? Yes. At the moment they can't update/insert/delete entities on multiple tables if they're not inheritance based or don't have the pk/fk fields inside them. WHich is logical, because that's also the reason why you can't update a view based on multiple tables in sqlserver/oracle etc.: they always update just 1 table. http://ayende.com/2327/multi-table-entities-in-nhibernate#comment3http://ayende.com/2327/multi-table-entities-in-nhibernate#comment3Wed, 02 May 2007 07:50:45 GMTIf you have a PK-FK assoication, I would say that this is another entity, and not the same one. > that's also the scope of the current EDM state ?? Can you explain? Do you mean the entity framework? http://ayende.com/2327/multi-table-entities-in-nhibernate#comment2http://ayende.com/2327/multi-table-entities-in-nhibernate#comment2Wed, 25 Apr 2007 15:21:49 GMTStill the scope is limited to PK-PK related tables. Nothing wrong with that, but that's also the scope of the current EDM state, as there's currently no way to insert fields in table B if the PK of B isn't in the entity at hand which is for example identified by the PK of table A, not related to B. http://ayende.com/2327/multi-table-entities-in-nhibernate#comment1http://ayende.com/2327/multi-table-entities-in-nhibernate#comment1Wed, 25 Apr 2007 15:12:53 GMT