private void GenerateInserts(ICsvTable csvTable, string file)
{
string columnNames = null;
using (var fp = File.OpenRead(file)){
var data = new StreamReader(fp).ReadLine();
columnNames = (data ?? string.Empty)
.Split(',')
.Select(x => string.Format("[{0}]", x))
.Aggregate((x, y) => string.Format("{0},{1}", x, y));
}
csvTable.Write(string.Format(INSERT_HEADER_FORMAT, _headerEscapingStrategy.Escape(csvTable.Name), file, columnNames));
}
private void EndFile(ICsvTable csvTable, StringBuilder builder)
{
TurnOffIdentityInsert(csvTable, builder);
csvTable.Write(builder.ToString());
builder.Clear();
}