search

FirebirdSQL / NETProvider

Firebird ADO.NET Data Provider
https://www.firebirdsql.org/en/net-provider/
Other
152 stars 63 forks source link

Expression 'LOWER(t.NAME)' in the SQL tree does not have a type mapping assigned. #1081

Open Norpa opened 1 year ago

Norpa commented 1 year ago

To test:

Add the line: var query = db.Set() .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)