FuncScriptSql.cs

using System.Data.SqlTypes;

namespace FuncScript.Sql
{
    public class FuncScriptSql
    {
        internal static object? NormalizeDataType(object obj)
        {
            return obj switch
            {
                DBNull => null,
                SqlBinary sqlBinary => sqlBinary.Value,
                SqlBoolean sqlBoolean => sqlBoolean.Value,
                SqlDateTime sqlDateTime => sqlDateTime.Value,
                SqlDecimal sqlDecimal => sqlDecimal.Value,
                SqlDouble sqlDouble => sqlDouble.Value,
                SqlGuid sqlGuid => sqlGuid.Value,
                SqlInt16 sqlInt16 => sqlInt16.Value,
                SqlInt32 sqlInt32 => sqlInt32.Value,
                SqlInt64 sqlInt64 => sqlInt64.Value,
                SqlSingle sqlSingle => sqlSingle.Value,
                SqlString sqlString => RemoveNullBytes(sqlString.Value),
                SqlMoney sqlMoney => sqlMoney.Value,
                string str => RemoveNullBytes(str),
                _ => obj,
            };
        }

        private static string RemoveNullBytes(string str)
        {
            return str.Replace("\0", string.Empty);
        }
    }
}