I have a WinForms NET 4.8 app which creates tables in a database and updated one of them. It works fine in a LAN. I use Microsoft.Data.SqlClient and do not use transactions scope.
I copy the app to AWS VM and run it. It works fine and at the end it waits closing. If I do not exit the app I do not see any tables in the db in SSMS. Also, do not see any changes in a table but in SQL Profiler I see all successfully executed statements.
After exit I see all tables. But table still not updated. In any LAN it I do not close the app but see all tables.
Why the behaviors different? How to fix it in AWS?