internal void PopulateDataFrom(string directory) { var directoryInfo = new DirectoryInfo(directory); IEnumerable <FileInfo> schemaFiles = directoryInfo.EnumerateFiles("*.xml"); var schemaToCsvDictionary = new Dictionary <string, string>(); foreach (FileInfo schema in schemaFiles) { if (schema.DirectoryName != null) { schemaToCsvDictionary.Add( schema.FullName, string.Format(@"{0}\{1}.csv", schema.DirectoryName, Path.GetFileNameWithoutExtension(schema.FullName))); } } foreach (var entry in schemaToCsvDictionary) { using (var bulkInserter = new SqlBulkInsertAdapter(entry.Key, this.ConnectionString)) { bulkInserter.BulkInsert(entry.Value); } } }
internal void PopulateDataFrom(string directory) { var directoryInfo = new DirectoryInfo(directory); IEnumerable<FileInfo> schemaFiles = directoryInfo.EnumerateFiles("*.xml"); var schemaToCsvDictionary = new Dictionary<string, string>(); foreach (FileInfo schema in schemaFiles) { if (schema.DirectoryName != null) { schemaToCsvDictionary.Add( schema.FullName, string.Format(@"{0}\{1}.csv", schema.DirectoryName, Path.GetFileNameWithoutExtension(schema.FullName))); } } foreach (var entry in schemaToCsvDictionary) { using (var bulkInserter = new SqlBulkInsertAdapter(entry.Key, this.ConnectionString)) { bulkInserter.BulkInsert(entry.Value); } } }