private object DbParameterValue_Statement(object propertyValue, DatabaseEntityPropertyDef info)
{
if (propertyValue == null)
{
return(DBNull.Value);
}
return(info.TypeConverter == null?
_databaseEngine.GetDbValueStatement(propertyValue, needQuoted : false) :
info.TypeConverter.TypeValueToDbValue(propertyValue));
}
public static string SqlJoin(IEnumerable values, IDatabaseEngine dbEngine)
{
StringBuilder sb = new StringBuilder();
foreach (object value in values)
{
sb.Append(dbEngine.GetDbValueStatement(value, needQuoted: true));
sb.Append(',');
}
sb.Remove(sb.Length - 1, 1);
return(sb.ToString());
}
public string SqlFormat(string sqlText, params object[] sqlParams)
{
List <string> escapedParams = new List <string>();
foreach (object sqlParam in sqlParams)
{
if (sqlParam == null)
{
escapedParams.Add("NULL");
}
else
{
if (sqlParam is SQLInValues sqlInValues)
{
escapedParams.Add(sqlInValues.ToSqlInString(databaseEngine));
}
else
{
escapedParams.Add(databaseEngine.GetDbValueStatement(sqlParam, needQuoted: true));
}
}
}
return(string.Format(GlobalSettings.Culture, sqlText, escapedParams.ToArray()));
}