Hello,

Are there any plans to support Oracle Lite database in LLBLGen Pro ? If not, is it possible to write our own DQE for it ?

Sincerely, Jean.

Oracle Lite is Oracle express?

No, Oracle Lite (formerly known as Oracle Personal Light) is a lightweigth version of oracle designed to run on small devices such as PDA. It is designed to be SQL-compatible with the standard Oracle server (but does not support neither PL/SQL nor stored procedures).

There is an Oracle Data Provider for DotNet, however it is not the same as the standard ODP.NET (the namespace is Oracle.DataAccess.Lite, not Oracle.DataAccess.Client) but the main classes (OracleConnection, OracleCommand, OracleParamater, ...) are present and have almost the same methods than the standard ODP.NET ones (the main difference being that the "Lite" version of OracleParamater uses the standard System.Data.DbType and not the OracleDbType constants). Other than that, the SQL generated by the Oracle DQE shipped with LLBLGan Pro should work perfectly with Oracle Lite.

For more information, here is Oracle product page for Oracle Lite 10g : http://www.oracle.com/database/Lite_Edition.html

Sincerely, Jean.

If it supports the same statements, you can pick the DQE sourcecode of the oracle dqe and compile that against the lite provider.

There aren't plans for supporting oracle lite for now, because the compact framework is a pain to program for, and if we had known the problems we ran into with sqlce support we never would have added the support.

Nevertheless, for oracle lite it should work similar to the sqlce support: you create a normal oracle project on oracle 10g, then generate code for oracle lite using a special template set (which for example skips stored procs, if oracle lite doesn't support these). The daaadapter.template needs a couple of conditional compilation statements to exclude the stored proc call code, and the references at the top of the file are probably different.

The amount of work is minimal, the amount of time spend to get it all working on the cf.net framework might be huge, due to the crappy development environment (no stacktraces!)

Thanks for this answer, however we wil not use Oracle Lite with the Compact Framework, we will use it with the standard .NET 2.0 Framework (OracleLite also works with Win32, not only WinCE) on Laptops.