hi, really struggling to resolve this issue. using nhibernate Im trying to join two different tables from two different databases but im getting a collation conflict error.

To resolve this issue i know i need to append

to the end of the sql string but have no idea how to do it using nhibernate.

Error:
Code:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

have looked for solutions for some time without any real joy. I get the feeling that it will be a simple configuration change. I thought that maybe i could override some string function within IQuery to append "collate Latin1_General_CI_AS" to the end of the sql but couldnt find anything obvious.

the sql that nhibernate fails on fails in ms sql 2005 management studio but runs and returns a result if i append the collate.

any help would be greatly recieved.

much love c

RESOLVED AT LAST!

public class InstallationMappingOverride : IAutoMappingOverride<Installation> {
public void Override(FluentNHibernate.Automapping.AutoMapping<Installation> mapping) {
mapping.References<Customer>(a => a.Customer)
.Fetch.Select()
.Column("CustomerCode");
}
}

by simply adding the line highlighted above - ".Fetch.Select" within the automapping override it resolves my problem. I have no idea why if someone could tell me then great but at least i can crack on now.

I would hope this helps someone because it really bugged me.