sql server to oracle add quote

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
alexis.lahsen
Posts: 5
Joined: Fri 24 May 2013 14:00

sql server to oracle add quote

Post by alexis.lahsen » Thu 29 Aug 2013 13:35

hello,
I want migrate my lqml in sql server to oracle(the DB is ready) but when i regenerate the storage and maping to validate the lqml he add quote in field source. How remove this quote ?

Thanks

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: sql server to oracle add quote

Post by Shalex » Mon 02 Sep 2013 16:39

The default case for Oracle is UPPER case. That's why Entity Developer quotes the Source value (name of the database column) if the name of a class or a property includes letters in lower case. This is a designed behaviour.

Why do you want to disable quoting?

alexis.lahsen
Posts: 5
Joined: Fri 24 May 2013 14:00

Re: sql server to oracle add quote

Post by alexis.lahsen » Wed 04 Sep 2013 07:43

I want disable quoting beceause my solution dont work with them but if i remove the quote they work

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: sql server to oracle add quote

Post by Shalex » Fri 06 Sep 2013 16:40

Could you please specify the steps we should follow to reproduce the situation when quoting breaks the workability of the application?

Entity Developer quotes the tables names only if the case of its letters does not coincides with the default case of a particular database server. This is a correct behaviour.

alexis.lahsen
Posts: 5
Joined: Fri 24 May 2013 14:00

Re: sql server to oracle add quote

Post by alexis.lahsen » Wed 11 Sep 2013 07:38

it's ok the problem was that I did not choose the upper option in the maping's option
Thanks for the help

Post Reply