public void WriteRecord(IRecord record)
{
if (_queryType == StructuredQueryType.UpdateWithFirstAsKey)
{
_writer.Write("UPDATE " + _name + " SET ");
for (int i = 1; i < record.Count; ++i)
{
_writer.Write("`" + _columns.ElementAt(i) + "` = " + this.Escape(record[i]));
if (i < record.Count - 1)
{
_writer.Write(",");
}
_writer.Write(" ");
}
_writer.WriteLine("WHERE `" + _columns.First() + "` = " + this.Escape(record[0]) + ";");
}
else
{
if (_line == 20)
{
_writer.WriteLine(";");
_writer.WriteLine();
_line = 0;
}
if (_line == 0)
{
_writer.WriteLine("INSERT INTO `" + _name + "` (`" + String.Join <string>("`, `", _columns) + "`) VALUES");
}
else
{
_writer.WriteLine(",");
}
_line++;
_writer.Write("(" + String.Join <string>(", ", record.AsEnumerable().Select(cell => this.Escape(cell))) + ")");
}
}
public void WriteRecord(IRecord record)
{
_writer.WriteLine(String.Join <string>(this.Separator.ToString(), record.AsEnumerable().Select(cell => this.Encloser.HasValue ? this.Encloser.ToString() + (cell == null ? "NULL" : cell) + this.Encloser.ToString() : cell)));
}
