Visual Studio Crash when changing CommandText

[chris901]

Hello,

i use a PgSqlConnection and a PgSqlDataTable.

I noticed two Visual Studio crashes:

● PgSqlDataTable property Active = true and then change the CommandText and preview
● DataColumns were created (right click -> Create Columns) and then the CommandText is changed and previewed

I recorded a video to show the steps i am doing: https://www.youtube.com/watch?v=hXHfhrKT8vw

I am using this database:
http://www.postgresqltutorial.com/postg ... -database/

I installed the database like this:
http://www.postgresqltutorial.com/load- ... -database/


The queries i use:

Code: Select all

select *
from inventory i
join rental r on r.inventory_id = i.inventory_id
where i.inventory_id > 20
order by i.inventory_id;

and

Code: Select all

select * from pg_tables;

This bug makes it nearly impossible for me to be productive when using PgSqlDataTabe.

I would appreciate a workaround or fix.



Best regards,

Chris

[Pinturiccio]

We have performed described steps, but Visual Studio does not crash. However, we got another incorrect behaviour when we previewed a changed command text. We will investigate this incorrect behaviour and post here about the results as soon as possible.

[chris901]

Hello Pinturiccio,

i just tested it again on a second Computer and it shows the same behavior.

Visual Studio doesn't respond for some seconds and then crashes.

Both computers run Windows 10 x64 and the latest dotConnect.

[Pinturiccio]

Thank you for the additional information. We have reproduced Visual Studio crash on a computer with Windows 10. We will investigate the issue and post here about the results as soon as possible.

[Pinturiccio]

We have fixed the bug with data preview in the PgSqlDataTable designer when the command text was changed. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

[chris901]

Great can't wait

[Pinturiccio]

New build of dotConnect for PostgreSQL 7.6.729 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=34214