Menu
▾
▴
Re: [Firebird-net-provider] FW: What is this error: Fieldnotfound:System.Data.Common.DbProviderManifest.ConceptualSchemaDefinitionVersion3
|
From: M. A. C. <mc...@mc...> - 2013-01-04 20:22:10
|
> <span style="font-family: 'courier new', courier, arial, helvetica, sans-serif;">Because you installed .NET 4.5 version.</span><div><span style="font-family: 'courier new', courier, arial, helvetica, sans-serif;"><br></span></div><div><span style="font-family: 'courier new', courier, arial, helvetica, sans-serif;">I say again: there is no FW45 in the testing computer. There is only FW40 and VS2010, nothing else.</span></div><div><span style="font-family: 'courier new', courier, arial, helvetica, sans-serif;"><br></span></div><div><div><font face="courier new, courier, arial, helvetica, sans-serif">Dear Jiri, is very sad to be treated like a moron. I am a developer for 25 years and if I said no FW45 on my computer because there is not installed FW45 on my computer. Used, as a mater o fact, a new computer with any installed Framework at start. The errors presented in this computer clear of FW45.</font></div><div><font face="courier new, courier, arial, helvetica, sans-serif"><br></font></div><div><font face="courier new, courier, arial, helvetica, sans-serif">You come confirming that the problem is in the entities, but the problem occurs on calls ExecuteScalar type that does not use entities for execution.</font></div><div><font face="courier new, courier, arial, helvetica, sans-serif"><br></font></div><div><font face="courier new, courier, arial, helvetica, sans-serif">Tests performed in 3 versions of Firebird provider and see the results. All tests were performed in the same computer. I switched providers and did the same tests. If you provide me a solution to the only issue introduced in version 2.7.7.0, I am satisfied.</font></div></div><div><font face="courier new, courier, arial, helvetica, sans-serif"><br></font></div><div><font face="courier new, courier, arial, helvetica, sans-serif">Tests done</font></div><div><font face="courier new, courier, arial, helvetica, sans-serif"><br></font></div><div><font face="courier new, courier, arial, helvetica, sans-serif"><div>3.0.2.0</div><div><br></div><div> - Stored Procedure from Entity</div><div> - Could not load type 'System.Runtime.CompilerServices.ExtensionAttribute' </div><div> from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.</div><div><br></div><div> - Stored Procedure from ExecuteScalar</div><div> - Could not load type 'System.Runtime.CompilerServices.ExtensionAttribute' </div><div> from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.</div><div><br></div><div> - Update model from database</div><div> - An error occurred while connecting to the database. The database might be unavailable. An exception of type</div><div> 'System.Data.ProviderIncompatibleException' occurred. The error message is: 'The store data provider failed</div><div> to return information for the StoreSchemaDefinition request. See the inned exception for details. The inner</div><div> exception caught was of type 'System.MissingFieldExceptionExeption', with this erros message: 'Field not found:</div><div> System.Data.Common.DbProviderManifest.ConceptualSchemaDefinitionVersion3'.</div><div><br></div><div> - Run this query: ESTOQUES.Where(w => w.FISICO > 100).Select(s => new { Fisico = s.FISICO + s.RESERVADO ?? 0 + s.ENCOMENDA ?? 0 }).Dump();</div><div> - Works fine</div><div><br></div><div>3.0.0.0</div><div><br></div><div> - Stored Procedure from Entity</div><div> - Could not load type 'System.Runtime.CompilerServices.ExtensionAttribute' </div><div> from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.</div><div><br></div><div> - Stored Procedure from ExecuteScalar</div><div> - Could not load type 'System.Runtime.CompilerServices.ExtensionAttribute' </div><div> from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.</div><div><br></div><div> - Update model from database</div><div> - Works fine</div><div><br></div><div> - Run this query: ESTOQUES.Where(w => w.FISICO > 100).Select(s => new { Fisico = s.FISICO + s.RESERVADO ?? 0 + s.ENCOMENDA ?? 0 }).Dump();</div><div> - Works fine</div><div><br></div><div><b>2.7.7.0</b></div><div><br></div><div> - Stored Procedure from Entity</div><div> - Works fine</div><div><br></div><div> - Stored Procedure from ExecuteScalar</div><div> - Works fine</div><div><br></div><div> - Update model from database</div><div> - Works fine</div><div><br></div><div> - Run this query: ESTOQUES.Where(w => w.FISICO > 100).Select(s => new { Fisico = s.FISICO + s.RESERVADO ?? 0 + s.ENCOMENDA ?? 0 }).Dump();</div><div> - Dynamic SQL Error / SQL error code = -842 / Precision must be from 1 to 18</div><div> - Generated query:</div><div> SELECT</div><div> 1 AS "C1",</div><div> CASE WHEN ("B"."FISICO" + "B"."RESERVADO" IS NULL) THEN CAST(CASE WHEN (0 + "B"."ENCOMENDA" IS NULL) THEN 0 ELSE 0 +</div><div> *******************</div><div> "B"."ENCOMENDA" END AS DECIMAL(19,0))</div><div> *******************</div><div> ELSE "B"."FISICO" + "B"."RESERVADO" END AS "C2"</div><div> FROM "ESTOQUES" AS "B"</div><div> WHERE "B"."FISICO" > CAST(100 AS DECIMAL(9,0))</div><div><br></div><div> ****> decimalPrecision must be less than or equal to 18</div><div><br></div><div>I really hope you hear me. I'm not crazy.</div><div><br></div><div>Best regards,</div><div>Marco Castro</div></font></div>
|