public void Import(DataFile file)
{
string database = file.database;
if (!context.DatabaseExists(database))
{
context.CreateDatabase(database);
context.ChangeDatabase(database);
}
DataTable csvData = CSVReadWrite.ReadCsvDataTable(file.path);
context.ExecuteBulkCopy((bulkCopy) => CreateDatabaseTable(file, csvData, bulkCopy));
}
public void Import(DataFile file)
{
if (context.DatabaseExists(file.database))
{
throw new InvalidOperationException("database already exists");
}
Restore restore = new Restore();
BackupDeviceItem backup = new BackupDeviceItem(file.path, DeviceType.File);
restore.Database = file.database;
restore.Devices.Add(backup);
RelocateFile relocateDataFile = new RelocateFile(LookupLogicalName(restore, "D"), string.Format(savePath, file.database, DataConfig.mdfExt));
RelocateFile relocateLogFile = new RelocateFile(LookupLogicalName(restore, "L"), string.Format(savePath, file.database, DataConfig.ldfExt));
restore.RelocateFiles.Add(relocateDataFile);
restore.RelocateFiles.Add(relocateLogFile);
restore.Action = RestoreActionType.Database;
restore.ReplaceDatabase = false;
restore.SqlRestore(SQLServerContext.Server);
context.ChangeDatabase(file.database);
}