I don't think that accessing two fundamentally different databases from the same ISession's going to be possible, even for NHibernate. How is the relational integrity being managed between the two databases? My suspicion is that you might have 2 distinct domains with a loose [RDBMS-wise] relationship - if that's the case then it's fairly easy to maintain an ISessionFactory for each database though and do the cross-database work in memory.
/Pete From: [email protected] [mailto:[email protected]] On Behalf Of Atilla Ilhan KARTAL Sent: 18 March 2013 13:48 To: [email protected] Subject: [nhusers] Join between Different Database Management Systems Dear All; I have two applications (Code Name: X and Y) and i want to merge this application on my business program.. X Application use Oracle 10 G Y Application use SQL Server 2005 I want to make map X and Y entities. For Example; Products on the X Application but Order Systems on the Y Application My Entities. class Product{ ..... IList<Order> orders; ..... } class Order{ ..... Product product; ..... } Product p = ........ p.Orders; How can i do this using with nhibernate??? (That is Possible??) Atilla İlhan KARTAL Web Application & Software Architect (Java & PHP & Registered Android Developer) Kuşadası / Aydın / Turkey www.atillailhankartal.com.tr twitter.com/TrojanMyth -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers?hl=en. For more options, visit https://groups.google.com/groups/opt_out. !DSPAM:1,5147206e98451325010060! -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
