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

[Norpa]

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)