Hello everybody!

Is it possible to fetch a foreign key as a property?

it actually is if I map the foreignkeycolumn as a property. But when exporting the database schema I get a duplicate columnname exception.
I'm looking for a cleaner way to do so..

thx in advance & kind regards!

If you use the "Proxy fetching" strategy the calling of the getIdentifier() will not fetch the entity.

A.getB().getId() wil return the FK without a fetch.

If you want to look into the source: net.sf.hibernate.proxy.LazyInitializer
R.
Tom

allright... as this issue still remains unsolved, here's how I try to get the id (remember: "NHibernate" and asp.net!)

string id = A.b.Id;

I have not implemented methods as getters and setters... just members!

However, id always ends up to be null!

What am i doing wrong? When debugging, A.b is : {CProxyTypeAndNamespaceGoesHere_NHibernate_ProxyINHibernateProxy_System_Runtime_SerializationISerializable2}, but A.b.Id = null

I know that the Id must be somehwere in the proxy object, but I can't get - even if i try to cast B - just as a test of course

LOL,
I was not aware that I ended up on a .net forum :-)

We had in Hibernate this problem:
http://forum.hibernate.org/viewtopic.ph ... hing+getid

I'm not aware if this problem also resembles in NHibernate, but it seems to be more or less the same.
Good luck,
Tom