private DataTable [] GetColumnMetaData() { DataTable [] columnMetaDataTables = new DataTable [2]; SqlCommand cmd = new SqlCommand("select @@trancount; " + "set fmtonly on select * from " + DestinationTableName + " set fmtonly off;" + "exec sp_tablecollations_90 '" + DestinationTableName + "'", connection); SqlDataReader reader = cmd.ExecuteReader(); int i = 0; // Skipping 1st result do { if (i == 1) { columnMetaDataTables [i - 1] = reader.GetSchemaTable(); } else if (i == 2) { SqlDataAdapter adapter = new SqlDataAdapter(); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; columnMetaDataTables [i - 1] = new DataTable(); adapter.FillInternal(columnMetaDataTables [i - 1], reader); } i++; } while (reader.IsClosed == false && reader.NextResult()); reader.Close(); return(columnMetaDataTables); }
public void WriteToServer(IDataReader reader) { DataTable table = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.FillInternal(table, reader); BulkCopyToServer(table, 0); }
public void WriteToServer (IDataReader reader) { DataTable table = new DataTable (); SqlDataAdapter adapter = new SqlDataAdapter (); adapter.FillInternal (table, reader); BulkCopyToServer (table, 0); }
private DataTable [] GetColumnMetaData () { DataTable [] columnMetaDataTables = new DataTable [2]; SqlCommand cmd = new SqlCommand ("select @@trancount; " + "set fmtonly on select * from " + DestinationTableName + " set fmtonly off;" + "exec sp_tablecollations_90 '" + DestinationTableName + "'", connection); if (externalTransaction != null) cmd.Transaction = externalTransaction; SqlDataReader reader = cmd.ExecuteReader (); int i = 0; // Skipping 1st result do { if (i == 1) { columnMetaDataTables [i - 1] = reader.GetSchemaTable (); } else if (i == 2) { SqlDataAdapter adapter = new SqlDataAdapter (); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; columnMetaDataTables [i - 1] = new DataTable (DestinationTableName); adapter.FillInternal (columnMetaDataTables [i - 1], reader); } i++; } while (reader.IsClosed == false && reader.NextResult()); reader.Close (); return columnMetaDataTables; }