表达式树转SQL时Guid常量转字符串引发类型转换异常的解决方法

我有一个返回动态分组键的方法：

private Expression<Func<T, object>> GetKeySelector<T>(Request req,
    Expression<Func<T, Guid>> domainKey, ...

// Gets called on a Queryable q.   
q.GroupBy(GetKeySelector<Order>(req, x => x.DomainId, ...

// Inside GekKeySelector, based on the request a key is picked:
if (...)
{
    return Expression.Lambda<Func<T, object>>(Expression.Convert(domainKey.Body, typeof(object)), domainKey.Parameters);
}

由于存在不同的键类型，返回类型为Expression<Func<T, object>>。

现在我想新增一种基于domainKey的分组方式，通过翻译列表构建if-then-else表达式树：

if (...)
{
    // List is of type 'a new { id, OrganizationId }
    var list = ...;

    Expression expr = Expression.Constant(Guid.Empty, typeof(Guid)); // Default value

    foreach (var item in list)
    {
        expr = Expression.Condition(Expression.Equal(domainKey.Body, Expression.Constant(item.Id, typeof(Guid))),
            Expression.Constant(item.OrganizationId, typeof(Guid)), expr);
    }

    expr = Expression.Convert(expr, typeof(Guid)); // Debugging attempt - did not help.
    
    return Expression.Lambda<Func<T, object>>(Expression.Convert(expr, typeof(object)), domainKey.Parameters);
}

该代码能生成对应的SQL和表达式，但执行查询时抛出异常：

System.InvalidOperationException
  HResult=0x80131509
  Message=An error occurred while reading a database value. The expected type was 'System.Object' but the actual value was of type 'System.String'.
  Source=Microsoft.EntityFrameworkCore.Relational
  StackTrace:
   at Microsoft.EntityFrameworkCore.Query.RelationalShapedQueryCompilingExpressionVisitor.ShaperProcessingExpressionVisitor.ThrowReadValueException[TValue](Exception exception, Object value, Type expectedType, IPropertyBase property)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.<MoveNextAsync>d__20.MoveNext()
   at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1.ConfiguredValueTaskAwaiter.GetResult()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.<ToListAsync>d__65`1.MoveNext()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.<ToListAsync>d__65`1.MoveNext()
   at [REDACTED]
  This exception was originally thrown at this call stack:
    [External Code]

Inner Exception 1:
InvalidCastException: Unable to cast object of type 'System.String' to type 'System.Guid'.

我认为问题出在Expression.Constant(..., typeof(Guid))生成的常量被转换为字符串，正确的应该是CAST(...) as uniqueidentifier来匹配预期类型。请问如何解决该异常，使生成的SQL返回正确的Guid类型？

问题核心是EF Core查询翻译器未正确识别Guid常量的CLR类型，导致SQL生成时将其转为字符串，最终映射回CLR对象时出现类型转换错误。可通过以下两种方式解决：

方法1：简化常量表达式，保留强类型信息 #

构建Expression.Constant时无需显式指定typeof(Guid)，让编译器自动推断类型，同时移除多余的类型转换，避免干扰EF Core的类型判断：

if (...)
{
    var list = ...;

    // 直接使用Guid.Empty作为默认值，依赖编译器自动推断类型
    Expression expr = Expression.Constant(Guid.Empty);

    foreach (var item in list)
    {
        expr = Expression.Condition(
            Expression.Equal(domainKey.Body, Expression.Constant(item.Id)),
            Expression.Constant(item.OrganizationId),
            expr
        );
    }

    // 仅做一次转换为object，匹配返回类型要求
    return Expression.Lambda<Func<T, object>>(
        Expression.Convert(expr, typeof(object)),
        domainKey.Parameters
    );
}

方法2：显式添加类型转换表达式 #

如果上述方法不生效，可手动为常量添加强类型转换，明确告知EF Core该常量应映射为数据库的uniqueidentifier类型：

// 封装一个生成强类型Guid常量的辅助方法
Expression CreateTypedGuidConstant(Guid value)
{
    return Expression.Convert(Expression.Constant(value), typeof(Guid));
}

if (...)
{
    var list = ...;

    Expression expr = CreateTypedGuidConstant(Guid.Empty);

    foreach (var item in list)
    {
        expr = Expression.Condition(
            Expression.Equal(domainKey.Body, CreateTypedGuidConstant(item.Id)),
            CreateTypedGuidConstant(item.OrganizationId),
            expr
        );
    }

    return Expression.Lambda<Func<T, object>>(
        Expression.Convert(expr, typeof(object)),
        domainKey.Parameters
    );
}

原理说明 #

EF Core的查询翻译器依赖CLR类型信息来生成对应SQL类型，当明确指定Guid类型的常量或通过Expression.Convert强制类型后，翻译器会将其映射为数据库的uniqueidentifier类型，而非默认的字符串类型，从而避免后续的类型转换异常。

内容的提问来源于stack exchange，提问作者sommmen