C#•3y ago

❔ Npgsql.NpgsqlOperationInProgressException: "A command is already in progress: SELECT * FROM games"

When executing the GetAll() method, the Pgsql error is returned.Npgsql Operation In Progress Exception: "A command is already in progress: SELECT * FROM games"

don't know how to fix it?
https://pastebin.com/ZaXiCUSJ

Pastebin

public List GetAll() { var command = Database.Get...

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

Pobiega•5/9/23, 12:53 PM

the error doesn't appear to be in these methods, but rather how you are calling them

Pobiega•5/9/23, 12:53 PM

are you doing any parallell, multithreaded or async work with these methods?

PPobiega are you doing any parallell, multithreaded or async work with these methods?

MarselOP•5/9/23, 12:55 PM

Pobiega•5/9/23, 12:56 PM

oh sorry I missed the problem

Pobiega•5/9/23, 12:56 PM

public List<Game> GetAll()
        {
            var command = Database.GetCommand("SELECT * FROM games");
            var games = new List<Game>();
            using(var reader = command.ExecuteReader())
            {
                while (reader.Read())
                {
                    var publisher = publisherService.PublisherById(reader.GetInt32(reader.GetOrdinal("publisher_id")));
                    var genre = genreService.GenreById(reader.GetInt32(reader.GetOrdinal("genre_id")));

public List<Game> GetAll()
        {
            var command = Database.GetCommand("SELECT * FROM games");
            var games = new List<Game>();
            using(var reader = command.ExecuteReader())
            {
                while (reader.Read())
                {
                    var publisher = publisherService.PublisherById(reader.GetInt32(reader.GetOrdinal("publisher_id")));
                    var genre = genreService.GenreById(reader.GetInt32(reader.GetOrdinal("genre_id")));

Pobiega•5/9/23, 12:57 PM

publisherService.PublisherByIdpublisherService.PublisherById will try to initiate a new db query while reading the results from one

Pobiega•5/9/23, 12:57 PM

thats not allowed

Pobiega•5/9/23, 12:57 PM

you need to finish one before you can start a new

Pobiega•5/9/23, 12:57 PM

if you want publisher/genre info at the same time, write a better query

MarselOP•5/9/23, 12:58 PM

i need to use join?

Pobiega•5/9/23, 12:58 PM

https://sqlbolt.com/lesson/select_queries_with_joins

Pobiega•5/9/23, 12:58 PM

yes

MarselOP•5/9/23, 12:58 PM

ok, thank you

Accord•5/10/23, 1:11 PM

Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.

public List<Game> GetAll() { var command = Database.GetCommand("SELECT * FROM games"); var games = new List<Game>(); using(var reader = command.ExecuteReader()) { while (reader.Read()) { var publisher = publisherService.PublisherById(reader.GetInt32(reader.GetOrdinal("publisher_id"))); var genre = genreService.GenreById(reader.GetInt32(reader.GetOrdinal("genre_id")));