Integration through databases is just plain bad. I would reconsider heavily what you are doing.
On Mon, Feb 15, 2010 at 3:18 PM, F.B. ten Kate <[email protected]> wrote: > I've got something i want to implement but i am not sure if it's > possible, and if it is how to go about it. > > Basically we have a couple of applications running with their own > databases. These databases in some cases have reference fields to > other databases (not proper FK's at this point in time but still). > > Now what i would like/want/need is to use the same mapping files, what > i mean is for example we have in one databases, orders, invoices, > buyers etc. > > If a buyer is late with payment the profile gets moved to our > "collecting" department. A Collection / Claim then gets a direct > reference to an Invoice_ID. > > Now currently i have the following mapping: > > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" > assembly="Webcasso.Backoffice.Entities" > namespace="Webcasso.Backoffice.Entities" > schema="Webcasso_develop.dbo"> > <class name="Claim" table="tbl_Incasso_Vordering"> > <id name="ID" column="Incasso_Vordering_ID"> > <generator class="native" /> > </id> > <property name="DirectpayInvoiceID" column="DP_Factuur_ID" /> > <many-to-one column="Incasso_ID" fetch="join" lazy="false" > name="Collection" class="Collection"/> > </class> > </hibernate-mapping> > > This works perfectly since at the moment the two databases are running > on the same server. Due to the size however this will not always be > the case, meaning i'd implement a linked server to the server holding > the "Webcasso_develop" database. > > Now from what i understand i can alter the schema and add the linked > server to it, this means however that i'd get two mapping files: > > - Mapping file to map the Claim to invoices on the Invoice Database. > - Mapping file to map the claim on the claim database (without a > linked server) > > Is there a way to set a linked server name for a assembly holding the > mappings? This way i have the same mappings i use when querying > through a linked server as i'd have when querying from a direct > connection to this server. (IE, Querying from the Invoices application > against the Claim database or Querying the Claim database directly.) > > That way i can just have one centralized mapping instead of having two > that i need to be keeping up to date. > > If this doesn't make sense people tell me how and i'll attempt to > ellaborate. > > Hope someone can point me in the right direction. > > Thanks in advance & Greetings, > > F.B. ten Kate > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- Les erreurs de grammaire et de syntaxe ont été incluses pour m'assurer de votre attention -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
