c# - Dapper QuerySingleOrDefault 不返回 null

Question

为什么 Dapper QuerySingleOrDefault 不返回 null？我用硬qwery。结果我有带有默认字段的对象。我在 DB Browser for SQLite 中运行了这个查询，它返回了 0 行。

public static Sensor GetSensor(string ip, string sensorName)
    {
        string sql = @"SELECT ip, name, invert, enable FROM DeviceAndOids AS A JOIN
                        DeviceForMonitoring AS B ON A.deviceForMonitoringKey=B.key JOIN
                        DeviceTypes AS C ON B.deviceTypeId=C.id WHERE 
                        oidForDeviceKey IN (SELECT key FROM OidsForDevice WHERE 
                        deviceTypeId IN (SELECT deviceTypeId FROM DeviceForMonitoring WHERE
                                ip = @ip) AND
                                name = @sensorName)";

        using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
        {
            var result = cnn.QuerySingleOrDefault<Sensor>(sql, new { ip, sensorName });
            return result;
        }
    }

Answer 1

Sensor 是 struct 。我把它改成了 class现在可以用了