I am a newbie to NHibernate just trying to get started, and am having some issues in using it with SQLAnywhere 11. My starting point is the very helpful tutorial "Your first NHibernate based application" at
http://blogs.hibernatingrhinos.com/nhibernate/archive/2008/04/01/your-first-nhibernate-based-application.aspx. The example uses SQL Server compact and works fine. However, when I attempt to convert it to use SQLA 11, I am running into an issue when I call the method Configuration.BuildSessionfactory(). Tracing into the code, it is failing in AbstractDatabaseSchema.GetRervedWords(). The method is:
public virtual ISet<string> GetReservedWords()
{
var result = new HashedSet<string>();
DataTable dtReservedWords = connection.GetSchema(DbMetaDataCollectionNames.ReservedWords);
foreach (DataRow row in dtReservedWords.Rows)
{
result.Add(row["ReservedWord"].ToString());
}
return result;
}
It fails on the line inside the foreach's curly braces because the column name in the DataRow is named "reserved_word" instead of "ReservedWord".
Any ideas on where to look on this issue? I checked out the main trunk of the code yesterday (2009-12-29) and compiled it using VS2008.