hi all,
i have a problem with sqlite and nhibernate 1.0.2. i have this query
Code:
"select i from ExamItem as i, Exam as e where i in elements(e.Items) and e.Id = " + mid
and mid is a int variable in my class.
it throw an exception "Could not excute query" and InnerException = {"no such column: exam1_.Id"}.
i use sqlite3.dll and SQlite.Net.dll and also nhibernate 1.0.2 for using sqlite database.
my database file is created successfully and i have all columns in it correctly.
i tested the hql query and it have problem when i add elements keyword in it.
this is my Configuration :
Code:
cfg.SetProperty("hibernate.dialect", "NHibernate.Dialect.SQLiteDialect");
cfg.SetProperty("hibernate.connection.provider", "NHibernate.Connection.DriverConnectionProvider");
cfg.SetProperty("hibernate.connection.driver_class", "NHibernate.Driver.SQLiteDriver");
cfg.SetProperty("hibernate.connection.connection_string", @"Data Source=" + GetDatabaseName() + ";Version=3");
cfg.SetProperty("hibernate.query.substitutions", "true=1;false=0");
cfg.SetProperty("hibernate.show_sql", "true");
may anybody help me to fix this issue??
thanks all,
Login
FAQ
Search