如何解决OleDb查询Excel结果转泛型Tuple时的类型不匹配问题

AI 小北

2026-10-1

解决方案

核心逻辑为通过泛型参数的类型信息获取Tuple每个元素的目标类型，再套用类型转换即可解决OleDb读取Excel时的类型不匹配问题。

修复后的完整代码

public T ExecuteTuple<T>(string sqlStatement, IEnumerable<OleDbParameter> parameters) where T : ITuple, struct
{
    using var connection = new OleDbConnection(connectionString);
    using var command = new OleDbCommand(sqlStatement, connection);
    command.Parameters.AddRange(parameters.ToArray());
    connection.Open();
    using var reader = command.ExecuteReader();

    T results = default;
    // 获取Tuple所有元素的目标类型数组
    Type[] tupleElementTypes = typeof(T).GetGenericArguments();
    int tupleFields = tupleElementTypes.Length;

    // 无查询结果时直接返回默认值
    if (!reader.Read())
    {
        return results;
    }

    for (int i = 0; i < tupleFields; ++i)
    {
        object tupleObject = results;
        object rawValue = reader.GetValue(i);
        object setValue = default;

        if (rawValue != DBNull.Value)
        {
            Type targetType = tupleElementTypes[i];
            // 兼容可空类型的场景
            Type underlyingType = Nullable.GetUnderlyingType(targetType);
            if (underlyingType != null)
            {
                targetType = underlyingType;
            }
            setValue = Convert.ChangeType(rawValue, targetType);
        }

        results.GetType().GetField($"Item{i + 1}")?.SetValue(tupleObject, setValue);
        results = (T)tupleObject;
    }

    return results;
}