Add SqlDataAdapter Design and Toolbox attributes

[michell711]

This is what the sqlDataAdapter in .net 4.8 can do.
But when I upgraded to .net 8.0
And use>Microsoft.Data.SqlClient
A very simple "automatically generate SQL syntax and SQL parameters - window design function",
=>Disappeared!

Please fix it.

[mdaigle]

Hi @michell711, can you please provide some example programs so that I can try to replicate what you're seeing?

[michell711]

https://kalachakra-my.sharepoint.com/:u:/g/personal/michell_kalachakra_onmicrosoft_com/EQ3p2dxvL3RJghNSUkmSgaIBU5S31lMc9G0RZK62Lwm9sA

The point is that the [...] of sqlcommand disappears.
Previously, when you clicked
The "Automatic-SQL Syntax Query Tool" may appear.
"SQL parameters" will also be automatically generated.
Now these features are "gone"

https://kalachakra-my.sharepoint.com/:u:/g/personal/michell_kalachakra_onmicrosoft_com/ESFrHJcAOfdBmnGXZCpTODIBrvB0v2oAggjayTH37R8dAQ?e=4lVj5r

[michell711]

你好@michell711，您能否提供一些示例程序，以便我嘗試複製您所看到的內容？

I have already replied. Is this sample information sufficient?

[mdaigle]

It's not sufficient. We'll need to see the actual code that reproduces the issue, not just the symptom. For example, there may be differences with how libraries need to be imported and used across different target frameworks that are not apparent unless we can see the code itself. Please attach example projects that show the working behavior in .NET Framework 4.8.1 and broken behavior in .NET 8 and I can take a look. Thanks!

[michell711]

這還不夠。我們需要查看重現問題的實際程式碼，而不僅僅是症狀。例如，在不同的目標框架中匯入和使用函式庫的方式可能會有所不同，除非我們能夠看到程式碼本身，否則這些差異是不會顯現出來的。請附上展示 .NET Framework 4.8.1 中的工作行為和 .NET 8 中的損壞行為的範例項目，以便我可以查看。謝謝！

我已經提供了直接的程式碼範例。
請從這兩個鏈接下載文件

https://kalachakra-my.sharepoint.com/:u:/g/personal/michell_kalachakra_onmicrosoft_com/EQ3p2dxvL3RJghNSUkmSgaIBU5S31lMc9G0RZK62Lwm9sA

https://kalachakra-my.sharepoint.com/:u:/g/personal/michell_kalachakra_onmicrosoft_com/ESFrHJcAOfdBmnGXZCpTODIBrvB0v2oAggjayTH37R8dAQ?e=4lVj5r

[mdaigle]

I see, your links have an incorrect hyperlink and just take me to the issues page for this repo. But copying the location straight into the address bar works.

[michell711]

I see, your links have an incorrect hyperlink and just take me to the issues page for this repo. But copying the location straight into the address bar works.

Thank u

[mdaigle]

I noticed that you updated from System.Data.SqlClient to Microsoft.Data.SqlClient. Looking around, I did find some existing issues that look similar having to do with VS Designer support for Microsoft.Data.SqlClient.

• https://developercommunity.visualstudio.com/t/vs-designer-support-for-microsoftdatasqlclient/1543400
• VS Designer support for Microsoft.Data.SqlClient #1297
  I also see mention in the code of missing design and toolbox attributes: https://github.com/dotnet/SqlClient/blob/main/src/Microsoft.Data.SqlClient/src/Microsoft/Data/SqlClient/SqlDataAdapter.cs#L19

I believe adding that support would address this issue. I'll discuss with my team and we'll decide on the priority of this feature.

[michell711]

@mdaigle

Thanks for finding this section,
The problem is indeed very much the same.
However... Microsoft mentioned that this Function has been fixed.
Released in the latest product update release, Visual Studio 2022 17.5
=>
But I use Visual Studio 2022 17.13.3,
This part of the problem still exists.
Need the team to help...fix it first.

With the maturity of .net 8 and .net 9,
I believe there are more people,
would like to upgrade from .net 4.8
will need this function

Thank you all,
Efforts and contributions made.
Thanks