Page 1 of 1
sql server to oracle add quote
Posted: Thu 29 Aug 2013 13:35
by alexis.lahsen
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
Re: sql server to oracle add quote
Posted: Mon 02 Sep 2013 16:39
by Shalex
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?
Re: sql server to oracle add quote
Posted: Wed 04 Sep 2013 07:43
by alexis.lahsen
I want disable quoting beceause my solution dont work with them but if i remove the quote they work
Re: sql server to oracle add quote
Posted: Fri 06 Sep 2013 16:40
by Shalex
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.
Re: sql server to oracle add quote
Posted: Wed 11 Sep 2013 07:38
by alexis.lahsen
it's ok the problem was that I did not choose the upper option in the maping's option
Thanks for the help