Hello,
I'm using NHibernate 1.2.0 (for .Net Framework 2.0...). I'm trying to use the Jetdriver but in file 'JetDriver.cs' something strange happens:
1) I have a table in MS Acces, mapped the table and created a class-file (everything perfect here);
2) Code behind form:
IList<VerkoopEenh> lijst = new List<VerkoopEenh>();
ISession session = GetSession();
IQuery c = session.CreateQuery("from VerkoopEenh ve");
lijst = c.List<VerkoopEenh>();
3) MS Access database is opened!
I get an error implying the SQL is wrong. When I follow the process I found out that in class 'JetDriver' method 'GenerateCommand' the query 'from VerkoopEenh ve' is parsed. I jugles a lot, during this process I can see a correct SQL emerge!! Afther this the new query is NOT used but a new version of the old one 'from verkoop_eenh verkoopeen0_' is parsed to MS Access resulting in an obvious SQl error.
This is such a basic error that I think I builded the wrong version of the Jet-driver/dialect/ or NHibernate.JetDriver
Do you perhaps know how to correct this (other JetDriver-class?). Does this problem also emerge when I start persisting?
Stefan
|