Add support for Microsoft.Data.SqlClient

[PawelFojt]

Add support for Microsoft.Data.SqlClient

[ErikEJ]

Try to change data source when creating the connection

[ErikEJ]

It is caused by differences in connection strings between System.Data.SqlClient and Microsoft.Data.SqlClient

[ErikEJ]

@PawelFojt Ping?

[ErikEJ]

I was able to repro, I will get this fixed

[ErikEJ]

I added a fix for this in the latest daily build from VSIX gallery, could you try it and let me know?

[ErikEJ]

See bc7eb88

[PawelFojt]

Now, when connected to the database, there's no issue, and I can even see that database under "Data Connections." However, when I try to right click on my DB -> script database -> Script schema.., the same error pops up. Additionally, I don't see a single table under the icon of my database.

So I think this issue occurs in multiple places within the application.

[ErikEJ]

Where are you right clicking?

[PawelFojt]

On the icon of the database I connected to.

[ErikEJ]

@PawelFojt OK, you are basically asking for support for Microsoft.Data.SqlClient - it was never added. I will look into it,

In the meantime you can create a connection using the legacy Provider:

[ErikEJ]

@PawelFojt I added a fix for this in the latest daily build from VSIX gallery, could you try it and let me know?

[PawelFojt]

The database connection is working, and there are no errors popping up when using the 'Script schema..' command. However, I don't see any tables. When I connect to the same database using SSMS, I can see several tables.

[ErikEJ]

I am not able to repro, can you share a sample schema?

[PawelFojt]

Right click on Data Connections -> Add SQL Server Connection.. -> fill Server name -> change Authentication to SQL Server Authentication -> fill User name and Password -> check Trust Server Certificate -> Test Connection is OK -> Click OK -> now I see myDb below Data Connections (but I don't see any table) - right click on myDb -> Script Database.. -> Script Schema -> here I also don't see any table

[ErikEJ]

Data Connections (but I don't see any table)

Correct, the tool does not list any server tables - this is by design

I am unable to repro - I see tables listed.