Hi all,

basically in my nhibernate project, i have few Objects and mapped with MS SQL.

Example :

[Class(Table = "A", Lazy = false)]
ObjectA

[Property(Name = "ADate", Column = "AD", TypeType = typeof(DateTime))]
public DateTime ADate
{
get { return _ADate; }
set { _ADate= value; }
}

Currently i'm using Nhiberhate ExecuteQuery to get the result from table. however i want to know, is there any "built-in" method to retrieve field name in MS SQL from property?
something like these -->

XXXmethod( pass in ObjectA.ADate) and these method will return the field name. In this case would be --> AD.

Kindly advice. Thanks a lot .

Hi,
you can get the column names from a property with this code:


type = your class type
propName = name of the property

you'll get a string array from this call, because nhibernate can have multiple columns mapped per property. so you have to take the first element of this array if your properties are mapped to single columns...

hi,

thanks for reply, anyway, i'm using nhibernate version 1.2.0 beta 3, and unfortunate, it don't have the GetColumnNames method... kindly advice..

Oh, OK. This method only exists in NHibernate 1.2. In NHibernate 2 this method was renamed to GetPropertyColumnNames(string propName).

definately u r right! thanks a lot for the help. nice day

Is there anything to get the reverse? Say I have a column name and I want to get the Property name that it is mapped from.