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