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