public static string GetSqlParam(object value)
{
if (value == null) return "NULL";
if (value is bool b) return b ? "1" : "0"; // OR: SQL dialect: TRUE, FALSE
if (value is Enum) return ((int)value).ToString();
if (IsNumeric(value.GetType())) return value.ToString();
if (value is DateTime d) return $"'{d.ToString("s", System.Globalization.CultureInfo.InvariantCulture)}'";
return "'" + value.ToString().Replace("'", "''") + "'";
}
IsNumeric implementation: https://solidt.eu/site/c-isnumeric/
401500cookie-checkC# Get SQL parameter