EntityFrameWork

[Norbert Saint Georges]

Hi,

"Expression 'LOWER()' in the SQL tree does not have a type mapping
assigned."

I can't find anything on the subject, any ideas?

--
Norbert Saint Georges
http://tetrasys.fi

[Norbert Saint Georges]

After a long debug, it crashes there

FirebirdSql.EntityFrameworkCore.Firebird.Query.Expressions.Internal.FbSpacedFunctionExpression.VisitChildren(ExpressionVisitor visitor) dans /_/src/FirebirdSql.EntityFrameworkCore.Firebird/Query/Expressions/Internal/FbSpacedFunctionExpression.cs :ligne 45

-----Message d'origine-----
De : firebird-n...@googlegroups.com [mailto:firebird-n...@googlegroups.com] De la part de Norbert Saint Georges
Envoyé : lundi 7 novembre 2022 14:41
À : firebird-n...@googlegroups.com
Objet : [firebird-net-provider] EntityFrameWork

--
You received this message because you are subscribed to the Google Groups "firebird-net-provider" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-net-pro...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/firebird-net-provider/tkauci%24u56%241%40ciao.gmane.io.

[Jiří Činčura]

Create issue on GH, with some example code. Probably I forgot to apply some type mappings somewhere.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

[Norbert Saint Georges]

it must be me that screwed up, it's at the identity level (lower(UserName)) but can't find any tracks or docs.

For GitHub, it will be difficult without putting the whole project :-(

-----Message d'origine-----
De : firebird-n...@googlegroups.com [mailto:firebird-n...@googlegroups.com] De la part de Jirí Cincura
Envoyé : lundi 7 novembre 2022 19:49
À : 'Mr. John' via firebird-net-provider
Objet : Re: [firebird-net-provider] EntityFrameWork

To view this discussion on the web visit https://groups.google.com/d/msgid/firebird-net-provider/3e4be648-1fee-4672-8a1b-58bd31e63841%40app.fastmail.com.

[Norbert Saint Georges]

well no, for once it's not me :-)
To test:

Add the line:
var query = db.Set<TwoComputedInsertEntity>()
.CountAsync(u => u.Name.ToLower().Trim() == "foobar" && u.Id != 27);

to the InsertTest.cs file on line 227.
and run FirebirdSql.EntityFrameworkCore.Firebird.Test you will get :



1) Error : FirebirdSql.EntityFrameworkCore.Firebird.Tests.EndToEnd.InsertTests.TwoComputedInsert
System.InvalidOperationException : Expression 'LOWER(t.NAME)' in the SQL tree does not have a type mapping assigned.
at Microsoft.EntityFrameworkCore.Query.RelationalSqlTranslatingExpressionVisitor.SqlTypeMappingVerifyingExpressionVisitor.VisitExtension(Expression extensionExpression)
at System.Linq.Expressions.Expression.Accept(ExpressionVisitor visitor)
at System.Linq.Expressions.ExpressionVisitor.Visit(Expression node)
at FirebirdSql.EntityFrameworkCore.Firebird.Query.Expressions.Internal.FbSpacedFunctionExpression.VisitChildren(ExpressionVisitor visitor) in C:\dev vs2022\NETProvider-master\src\FirebirdSql.EntityFrameworkCore.Firebird\Query\Expressions\Internal\FbSpacedFunctionExpression.cs:line 45
at System.Linq.Expressions.ExpressionVisitor.VisitExtension(Expression node)
at Microsoft.EntityFrameworkCore.Query.RelationalSqlTranslatingExpressionVisitor.SqlTypeMappingVerifyingExpressionVisitor.VisitExtension(Expression extensionExpression)
at System.Linq.Expressions.Expression.Accept(ExpressionVisitor visitor)
....blabla



-----Message d'origine-----
De : firebird-n...@googlegroups.com [mailto:firebird-n...@googlegroups.com] De la part de Norbert Saint Georges
Envoyé : lundi 7 novembre 2022 20:33
À : firebird-n...@googlegroups.com
Objet : RE: [firebird-net-provider] EntityFrameWork

To view this discussion on the web visit https://groups.google.com/d/msgid/firebird-net-provider/1F00205D6097D74BA69E202DC215296F4AA2E7%40raoul.tetrasys.oy.local.

[Jiří Činčura]

Great. I'll look at that.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

> https://groups.google.com/d/msgid/firebird-net-provider/1F00205D6097D74BA69E202DC215296F4AA2E8%40raoul.tetrasys.oy.local.