visual-studiostored-proceduresvisual-studio-2019tableadapter

Visual Studio 2019 - DataSet tableadapters add ";1" after each stored procedure name




So I have to update an old .Net application for my job.
When I open the application's DataSet and want to update one of the tableadapters, I end up with this type of "bug" :

How CommandText is :

How it should be :

I have found a page about this topic but it doesn't help me much, because I can't reinstall the SQL Server in my situation :

https://answers.sap.com/questions/5936797/what%27s-with-the-semicolon-1-notation-in-stored-pro.html

Do you have any idea how to resolve this problem ?

Edit:


Solution

  • I've found the answer !

    Everything works as excepted !
    Hope it helps others encountering this same problem

    Edit: Had to make another DataSet because it keeps auto-generating code with Odbc component even after updating the ConnectionString...