I have SQL procedure named
dbo.[XXX.YYY]
When I create a model and execute this procedure as a method of DataContext - the command sent to SQL server is this:
EXEC [dbo].[[XXX].[YYY]]
And of course it fails with SQL server message:
Msg 105, Level 15, State 1, Line 1
Unclosed quotation mark after the character string 'YYY]'.
Is there any way to make sure devart does not change the original procedure name from dbo.[XXX.YYY]
to
[dbo].[[XXX].[YYY]]
?
I have hundreds of procedures with "." in the name - it is a legacy from Oracle packages conversion ...
Any help?
Thanks,
Alex
period in procedure name
Re: period in procedure name
Thank you for the report. We have reproduced this issue. We will investigate it and inform you about the results as soon as possible.
Re: period in procedure name
The bug with working with stored procedures named like "[XXX.XXX]" has been fixed. The fix will be included in the next build of LinqConnect. We will inform you when it is available for download.