static void ConvertStringToSql(StringBuilder stringBuilder, string value)
{
var start = "'";
if (value.Any(ch => ch > 127))
{
start = "N'";
}
DataTools.ConvertStringToSql(stringBuilder, "+", start, AppendConversion, value);
}
static void ConvertStringToSql(StringBuilder stringBuilder, string value)
{
string startPrefix = null;
if (value.Any(ch => ch > 127))
{
startPrefix = "N";
}
DataTools.ConvertStringToSql(stringBuilder, "+", startPrefix, AppendConversion, value, null);
}
public void ConvertStringToSql(string testString, string startPrefix, char[] extraEscapes, string expected)
{
var sb = new StringBuilder();
DataTools.ConvertStringToSql(
sb,
"&",
startPrefix,
(strb, c) => strb.AppendFormat("chr({0})", c.ToString(CultureInfo.InvariantCulture)),
testString,
extraEscapes);
Assert.AreEqual(expected, sb.ToString());
}
static void ConvertStringToSql(StringBuilder stringBuilder, SqlDataType sqlDataType, string value)
{
string startPrefix;
switch (sqlDataType.DataType)
{
case DataType.Char:
case DataType.VarChar:
case DataType.Text:
startPrefix = null;
break;
default:
startPrefix = "N";
break;
}
DataTools.ConvertStringToSql(stringBuilder, "+", startPrefix, AppendConversion, value, null);
}
static void ConvertStringToSql(StringBuilder stringBuilder, string value)
{
DataTools.ConvertStringToSql(stringBuilder, "||", null, AppendConversion, value, null);
}
static void ConvertStringToSql(StringBuilder stringBuilder, string value)
{
DataTools.ConvertStringToSql(stringBuilder, "+", "'", AppendConversion, value);
}
static void ConvertStringToSql(StringBuilder stringBuilder, string value)
{
DataTools.ConvertStringToSql(stringBuilder, "||", null, AppendConversionAction, value, _extraEscapes);
}
