private string PrepareValue(SqlTimingParameter p)
{
if (p.Value == null)
{
return("null");
}
if (dontQuote.Contains(p.DbType))
{
if (p.DbType == "Boolean")
{
return(p.Value == "True" ? "1" : "0");
}
return(p.Value);
}
string prefix = "";
if (p.DbType == "String" || p.DbType == "StringFixedLength")
{
prefix = "N";
}
return(prefix + "'" + p.Value.Replace("'", "''") + "'");
}
/// <summary>
/// Returns a string representation of the parameter's value, including the type
/// </summary>
/// <param name="param">The timing parameter to get the value for.</param>
public string GetParameterValue(SqlTimingParameter param)
{
// TODO: ugh, figure out how to allow different db providers to specify how values are represented (e.g. bit in oracle)
var result = param.Value;
var type = param.DbType ?? string.Empty;
if (result != null)
{
switch (type.ToLower())
{
case "string":
case "datetime":
result = string.Format("'{0}'", result);
break;
case "boolean":
result = result switch
{
"True" => "1",
"False" => "0",
_ => null,
};
break;
}
}
result ??= "null";
if (includeTypeInfo)
{
result += " /* " + param.Name + " DbType." + param.DbType + " */";
}
return(result);
}
/// <summary>
/// Prepare the parameter value for use in SqlFormatter output
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
protected string PrepareValue(SqlTimingParameter parameter)
{
if (parameter.Value == null)
{
return("null");
}
if (DontQuote.Contains(parameter.DbType))
{
if (parameter.DbType == "Boolean")
{
return(parameter.Value == "True" ? "1" : "0");
}
return(parameter.Value);
}
var prefix = string.Empty;
if (parameter.DbType == "String" || parameter.DbType == "StringFixedLength")
{
prefix = "N";
}
return(prefix + "'" + parameter.Value.Replace("'", "''") + "'");
}
public void GetHashCodeWithNullParameterValue()
{
SqlTimingParameter parameter = new SqlTimingParameter();
parameter.Name = "TestParameter";
parameter.Value = null;
parameter.ParentSqlTimingId = Guid.NewGuid();
Assert.DoesNotThrow(() => parameter.GetHashCode());
}
public void GetHashCodeWithNullParameterValue()
{
SqlTimingParameter parameter = new SqlTimingParameter();
parameter.Name = "TestParameter";
parameter.Value = null;
parameter.ParentSqlTimingId = Guid.NewGuid();
Assert.DoesNotThrow(() => parameter.GetHashCode());
}
/// <summary>
/// prepare the value.
/// </summary>
/// <param name="p">The p.</param>
/// <returns>the prepared string.</returns>
private string PrepareValue(SqlTimingParameter p)
{
if (p.Value == null)
{
return("null");
}
if (DontQuote.Contains(p.DbType))
{
return(p.Value);
}
return("'" + p.Value.Replace("'", "''") + "'");
}
private void GenerateStoreProcedureCall(string commandText, List <SqlTimingParameter> parameters, StringBuilder buffer)
{
buffer.Append("EXEC ");
SqlTimingParameter returnValueParameter = GetReturnValueParameter(parameters);
if (returnValueParameter != null)
{
buffer.Append(EnsureParameterPrefix(returnValueParameter.Name)).Append(" = ");
}
buffer.Append(commandText);
GenerateStoredProcedureParameters(buffer, parameters);
buffer.Append(";");
GenerateSelectStatement(buffer, parameters);
}
/// <summary>
/// Returns a string representation of the parameter's value, including the type
/// </summary>
/// <param name="p">The parameter to get a value for</param>
/// <returns></returns>
public string GetParameterValue(SqlTimingParameter p)
{
// TODO: ugh, figure out how to allow different db providers to specify how values are represented (e.g. bit in oracle)
var result = p.Value;
var type = p.DbType ?? "";
switch (type.ToLower())
{
case "string":
case "datetime":
result = string.Format("'{0}'", result);
break;
case "boolean":
switch (result)
{
case "True":
result = "1";
break;
case "False":
result = "0";
break;
default:
result = null;
break;
}
break;
}
if (result == null)
{
result = "null";
}
if (_includeTypeInfo)
{
result += " /* " + p.Name + " DbType." + p.DbType + " */";
}
return(result);
}
/// <summary>
/// Returns a string representation of the parameter's value, including the type
/// </summary>
/// <param name="p">The parameter to get a value for</param>
/// <returns></returns>
public string GetParameterValue(SqlTimingParameter p)
{
// TODO: ugh, figure out how to allow different db providers to specify how values are represented (e.g. bit in oracle)
var result = p.Value;
var type = p.DbType ?? "";
switch (type.ToLower())
{
case "string":
case "datetime":
result = string.Format("'{0}'", result);
break;
case "boolean":
switch (result)
{
case "True":
result = "1";
break;
case "False":
result = "0";
break;
default:
result = null;
break;
}
break;
}
if (result == null)
{
result = "null";
}
if(_includeTypeInfo)
{
result += " /* " + p.Name + " DbType." + p.DbType + " */";
}
return result;
}
private string PrepareValue(SqlTimingParameter p)
{
if (p.Value == null)
{
return "null";
}
if (dontQuote.Contains(p.DbType))
{
return p.Value;
}
return "'" + p.Value.Replace("'", "''") + "'";
}
/// <summary>
/// prepare the value.
/// </summary>
/// <param name="parameter">The parameter.</param>
/// <returns>the prepared parameter value.</returns>
private string PrepareValue(SqlTimingParameter parameter)
{
if (parameter.Value == null)
{
return "null";
}
if (DontQuote.Contains(parameter.DbType))
{
if (parameter.DbType == "Boolean")
{
return parameter.Value == "True" ? "1" : "0";
}
return parameter.Value;
}
var prefix = string.Empty;
if (parameter.DbType == "String" || parameter.DbType == "StringFixedLength")
{
prefix = "N";
}
return prefix + "'" + parameter.Value.Replace("'", "''") + "'";
}
private string GetJsonVal(SqlTimingParameter p)
{
if (p.Value == null || p.Value.Length == 0)
{
return null;
}
DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(List<List<string>>));
using (Stream s = GenerateStreamFromString(p.Value))
{
var data = (List<List<String>>)ser.ReadObject(s);
var rows = new List<string>();
foreach (List<string> row in data)
{
for (int i = 0; i < row.Count; i++)
{
row[i] = "'" + row[i].Replace("'", "''") + "'";
}
rows.Add("(" + string.Join(",", row) + ")");
}
return string.Join(",\n", rows);
}
}
private string PrepareValue(SqlTimingParameter p)
{
if (p.Value == null)
{
return "null";
}
if (dontQuote.Contains(p.DbType))
{
return p.Value;
}
string prefix = "";
if (p.DbType == "String" || p.DbType == "StringFixedLength")
{
prefix = "N";
}
return prefix + "'" + p.Value.Replace("'","''") + "'";
}
