Is NHibernate LINQ stable and do all NHibernate bolt on projects allow it

Question

I have been a long time user of Subsonic due to its ease of use and LINQ integration.

I now have to use something else because I need to be able to use Oracle.

I have 2 databases with the same schema therefore I want to have 1 set of POCO's and then change a connection string to switch between SQL & Oracle depending on the requirements.

Is this possible firstly, is LINQ fully functioning and stable in NHibernate and do Castle ActiveRecord and Fluent Hibernate allow the LINQ querying?

Answer 1

1. It is stable.
2. It is not fully functioning, and it is not planned to be fully functioning. I don't think there exists linq providers supporting 100% everything. The question should be: "Is it fully function for the queries you need to execute?" (The answer to that question would be yes in 99% of the cases)
3. You can find reported bugs/missing features in Jira
4. Fluent NHhibernate doesn't do any querying, just mapping. Castle active record doesn't query either. The linq namespace does not have a reference to active record or fluent and vise versa.