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(); }