Menu
▾
▴
Re: [Firebird-net-provider] LINQ Outer Error
|
From: M. A. C. <mc...@mc...> - 2013-05-09 12:59:28
|
Hello Muthu,<br><br> I would say that your issue is at this part of the code:<br><br> <font size="2"><font face="Consolas"><font color="#000000">: l.</font><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTITEMs</span></font></font><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">FirstOrDefault</span><span style="color: black; font-family: Consolas; font-size: 10pt;">().</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">DEPARTMENT<br><br> and/or<br><br> <font color="#000000">(l.</font><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTDISCOUNTs</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">Any</span><span style="color: black; font-family: Consolas; font-size: 10pt;">()</span><br><br> Marco Castro</span><br><br><b>----- Original Message -----</b><br>
<b>From:</b> Muthu Annamalai [mailto:pea...@ho...]<br>
<b>To:</b> fir...@li...<br>
<b>Sent:</b> Wed, 8 May 2013 22:34:13 -0500<br>
<b>Subject:</b> [Firebird-net-provider] LINQ Outer Error<br><br>
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
span.EmailStyle19
{mso-style-type:personal-compose;
font-family:"Trebuchet MS","sans-serif";
color:#3366FF;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--><div class="WordSection1"><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;">I Use VS 2012 Ultimate, EF 5.0 Code First, Firebird Provider 3.0.2.0</span></p><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;">When I use the following LINQ query</span></p><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;"> </span></p><p class="MsoNormal" style="background: white;"><span style="color: blue; font-family: Consolas; font-size: 10pt;">public</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: darkblue; font-family: Consolas; font-size: 10pt;">IQueryable</span><span style="color: black; font-family: Consolas; font-size: 10pt;"><</span><span style="color: darkblue; font-family: Consolas; font-size: 10pt;">SalesTotalCount</span><span style="color: black; font-family: Consolas; font-size: 10pt;">> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ZDepartmentSalesPeriod</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> {</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">get</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> {</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">return</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> (</span><span style="color: blue; font-family: Consolas; font-size: 10pt;">from</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> r </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">in</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ReceiptRepository</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">NoTracking</span><span style="color: black; font-family: Consolas; font-size: 10pt;">()</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">where</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> r.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTDATE</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">>=</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ReportEndDate</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> &</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> r.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTDATE</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;"><=</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ReportEndDate</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">from</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> l </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">in</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> r.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTLINEs</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">let</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> department =</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ITEMSTYLE</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> != </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">null</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> ? l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ITEMSTYLE</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ITEM</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">CATEGORY</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">DEPARTMENT</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> : l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTITEMs</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">FirstOrDefault</span><span style="color: black; font-family: Consolas; font-size: 10pt;">().</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">DEPARTMENT</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">group</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> l </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">by</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> department</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">into</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> receiptLines</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">select</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">new</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: darkblue; font-family: Consolas; font-size: 10pt;">SalesTotalCount</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> {</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Name</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> = receiptLines.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Key</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">DEPARTMENTNAME</span><span style="color: black; font-family: Consolas; font-size: 10pt;">,</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Total</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> = (</span><span style="color: blue; font-family: Consolas; font-size: 10pt;">double</span><span style="color: black; font-family: Consolas; font-size: 10pt;">)receiptLines.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">Sum</span><span style="color: black; font-family: Consolas; font-size: 10pt;">(l =></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">QUANTITY</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> * l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">PRICE</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> -</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> (l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTDISCOUNTs</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">Any</span><span style="color: black; font-family: Consolas; font-size: 10pt;">()</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> ? l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTDISCOUNTs</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">Sum</span><span style="color: black; font-family: Consolas; font-size: 10pt;">(d => d.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">DISCOUNT</span><span style="color: black; font-family: Consolas; font-size: 10pt;">)</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> : 0)),</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Count</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> = receiptLines.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">Count</span><span style="color: black; font-family: Consolas; font-size: 10pt;">(),</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Listed</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> = receiptLines.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Key</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">LISTED</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> });</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> }</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> }</span></p><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;"> </span></p><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;">Firebird is throwing this exception</span></p><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;"> </span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">SQL error code = -104</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">Token unknown - line 35, column 4</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><b><span style="background: white; color: red; font-family: Consolas; font-size: 9pt; mso-highlight: white;">OUTER</span></b><span style="background: white; color: red; font-family: Consolas; font-size: 9pt; mso-highlight: white;"> </span><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">---&amp;gt; Dynamic SQL Error</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">SQL error code = -104</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">Token unknown - line 35, column 4</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">OUTER</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;"> at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;"> at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior)</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;"> at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)</span></p><p class="MsoNormal"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;"> at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)</ExceptionString><InnerException><ExceptionType>FirebirdSql.Data.Common.IscException, FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c</ExceptionType><Message>Dynamic SQL Error</span><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;"></span></p></div>
|
