I say again: there is no FW45 in the testing computer. There is only FW40 and VS2010, nothing else.
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.
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.
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.
Tests done
3.0.2.0
- Stored Procedure from Entity
- Could not load type 'System.Runtime.CompilerServices.ExtensionAttribute'
from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
- Stored Procedure from ExecuteScalar
- Could not load type 'System.Runtime.CompilerServices.ExtensionAttribute'
from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
- Update model from database
- An error occurred while connecting to the database. The database might be unavailable. An exception of type
'System.Data.ProviderIncompatibleException' occurred. The error message is: 'The store data provider failed
to return information for the StoreSchemaDefinition request. See the inned exception for details. The inner
exception caught was of type 'System.MissingFieldExceptionExeption', with this erros message: 'Field not found:
System.Data.Common.DbProviderManifest.ConceptualSchemaDefinitionVersion3'.
- Run this query: ESTOQUES.Where(w => w.FISICO > 100).Select(s => new { Fisico = s.FISICO + s.RESERVADO ?? 0 + s.ENCOMENDA ?? 0 }).Dump();
- Works fine
3.0.0.0
- Stored Procedure from Entity
- Could not load type 'System.Runtime.CompilerServices.ExtensionAttribute'
from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
- Stored Procedure from ExecuteScalar
- Could not load type 'System.Runtime.CompilerServices.ExtensionAttribute'
from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
- Update model from database
- Works fine
- Run this query: ESTOQUES.Where(w => w.FISICO > 100).Select(s => new { Fisico = s.FISICO + s.RESERVADO ?? 0 + s.ENCOMENDA ?? 0 }).Dump();
- Works fine
2.7.7.0
- Stored Procedure from Entity
- Works fine
- Stored Procedure from ExecuteScalar
- Works fine
- Update model from database
- Works fine
- Run this query: ESTOQUES.Where(w => w.FISICO > 100).Select(s => new { Fisico = s.FISICO + s.RESERVADO ?? 0 + s.ENCOMENDA ?? 0 }).Dump();
- Dynamic SQL Error / SQL error code = -842 / Precision must be from 1 to 18
- Generated query:
SELECT
1 AS "C1",
CASE WHEN ("B"."FISICO" + "B"."RESERVADO" IS NULL) THEN CAST(CASE WHEN (0 + "B"."ENCOMENDA" IS NULL) THEN 0 ELSE 0 +
*******************
"B"."ENCOMENDA" END AS DECIMAL(19,0))
*******************
ELSE "B"."FISICO" + "B"."RESERVADO" END AS "C2"
FROM "ESTOQUES" AS "B"
WHERE "B"."FISICO" > CAST(100 AS DECIMAL(9,0))
****> decimalPrecision must be less than or equal to 18
I really hope you hear me. I'm not crazy.
Best regards,
Marco Castro
------------------------------------------------------------------------------ Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812
_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
