On Apr 15, 2010, at 12:31 , Anders Holbøll wrote:

On Thu, Apr 15, 2010 at 11:40, mabu <[email protected]> wrote:
i was wondering if the sqls generated by the oracle provider are
working at anybody?
I ran into the problem that i had to override the quoting stuff
because that broke the sqls ...

I think it mostly works for me. I'm still in the process of getting
the real unit tests converted to oracle, but it seemed to run most of
the old unit tests.

What problems are you seeing? Are you using the Microsoft or the
Oracle (odp.net) provider? If you are using odp.net I think you need
to make sure that it is the one for .net 2.x (i.e. the version of the
Oracle.DataAccess.dll is 2.x.x.x).


The problems i see is that the statement looks like
select count(*) from "my_table" where "field" = :somevalue

This sql throws an exception because of the " characters. i have overriden the Start and End Quote stuff. Now the sqls work like a charm ... no problems at the moment. Next week i gonna test the insert statements.

I am using System.Data.OracleClient.dll for .net 2.x ... Are the sqls working only with Oracle.DataAccess.dll ?

Do you need some help at converting the unit tests?


Martin

--
You received this message because you are subscribed to the Google Groups 
"DbLinq" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/dblinq?hl=en.

Reply via email to