public void AddUsersToRoom(long roomId, List <long> userIdList) { using (var connection = new SqlConnection(_connectionString)) using (var cmd = connection.CreateCommand()) { connection.Open(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = AddUsersToRoomCmd; cmd.Parameters.AddWithValue("@roomId", roomId); cmd.Parameters.Add(TableUtil.CreateTableLong("@userList", userIdList)); cmd.ExecuteNonQuery(); } }