public static string GetSqlLiteral(SqlFormatProperties props, IDialectDataAdapter dda, SqlFormatterState state, IBedValueReader reader, DbTypeBase dsttype)
{
if (props.BinaryStrings)
{
switch (reader.GetFieldType())
{
case TypeStorage.String:
if (props.BinaryStrings)
{
return(dda.GetSqlLiteral(props.RealBinaryEncoding.GetBytes(reader.GetString()), dsttype));
}
break;
}
}
return(dda.GetSqlLiteral(reader, dsttype));
}
public void WriteRecord(StreamWriter fw, ITableStructure table, IBedRecord record, int index, object manager)
{
if (m_dda == null)
{
m_dda = (m_dialect ?? GenericDialect.Instance).CreateDataAdapter();
}
fw.Write("INSERT INTO ");
fw.Write(m_tableName);
fw.Write(" (");
bool was = false;
for (int i = 0; i < record.FieldCount; i++)
{
if (was)
{
fw.Write(",");
}
fw.Write(record.GetName(i));
was = true;
}
fw.Write(") VALUES (");
was = false;
for (int i = 0; i < record.FieldCount; i++)
{
if (was)
{
fw.Write(",");
}
record.ReadValue(i);
fw.Write(m_dda.GetSqlLiteral(record));
//TypeStorage type = record.GetFieldType();
//if (record.IsDBNull(i))
//{
// fw.Write("NULL");
//}
//else
//{
// fw.Write(m_quoteCharacter);
// string val = XmlTool.ObjectToString(record.GetValue(i));
// val = val.Replace("" + m_quoteCharacter, m_escapedQuote);
// fw.Write(val);
// fw.Write(m_quoteCharacter);
//}
was = true;
}
fw.Write(")");
fw.Write(m_statementSeparator.ReplaceCEscapes());
}
public static string GetSqlLiteral(SqlFormatProperties props, IDialectDataAdapter dda, SqlFormatterState state, ICdlValueReader reader, DbTypeBase dsttype)
{
if (props.BinaryStrings)
{
switch (reader.GetFieldType())
{
case TypeStorage.String:
if (props.BinaryStrings)
{
return dda.GetSqlLiteral(props.RealBinaryEncoding.GetBytes(reader.GetString()), dsttype);
}
break;
}
}
return dda.GetSqlLiteral(reader, dsttype);
}
public static string GetSqlLiteral(this IDialectDataAdapter dda, object value)
{
return(dda.GetSqlLiteral(value, null));
}
public static string GetSqlLiteral(this IDialectDataAdapter dda, IBedValueReader reader)
{
return(dda.GetSqlLiteral(reader, null));
}