private Dictionary <int, int> UpsertFromTempTable()
{
var inserts = new Dictionary <int, int>();
using (var selectCommand = _connection.CreateCommand())
{
var mergeCommand = new MergeCommand(_tempTableSchema, _targetTableSchema);
selectCommand.CommandText = mergeCommand.ToString();
using (var reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
var action = (string)reader["action"];
if (action == "INSERT")
{
var ident = (int)reader["ident"];
var surrogateKey = (int)reader["_Surrogate"];
inserts.Add(surrogateKey, ident);
}
}
}
}
return(inserts);
}
private Dictionary<int, int> UpsertFromTempTable()
{
var inserts = new Dictionary<int, int>();
using (var selectCommand = _connection.CreateCommand())
{
var mergeCommand = new MergeCommand(_tempTableSchema, _targetTableSchema);
selectCommand.CommandText = mergeCommand.ToString();
using (var reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
var action = (string)reader["action"];
if (action == "INSERT")
{
var ident = (int)reader["ident"];
var surrogateKey = (int)reader["_Surrogate"];
inserts.Add(surrogateKey, ident);
}
}
}
}
return inserts;
}
