Windows Forms designer error since VS 17.5 update

cstauffer 20

Since updating to 17.5.0 (as well as 17.5.1) I am unable to open winforms design files due to the following error:

Unable to cast object of type 'System.Data.SqlClient.SqlCommand' to type
'Microsoft.Data.SqlClient.SqlCommand'.

This only happens for forms using components from the System.Data.SqlClient namespace, such as SqlDataAdapter, SqlCommand, SqlConnection, etc. There really isn't any additional info provided in Visual Studio aside from that error message. The projects all target .NET Framework 4.8.

Nothing has changed with the code, and applications still compile and run as they did prior to the update. I'm not sure where to look to see what is causing this issue. The projects do not have a reference to Microsoft.Data.SqlClient in them so I'm not sure why it's trying to cast stuff to types in that assembly.

Jack J Jun 24,296 Reputation points Microsoft Vendor

2023-03-08T05:54:24.9466667+00:00
@cstauffer, Welcome to Microsoft Q&A, the error often means that there two different namespaces have the same class name. I recommend that you could use the class with the namespace like the following code:

System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); etc.
James Taylor 11 Reputation points

2023-03-08T06:59:04.74+00:00

I have the same issue, have submitted a bug report:

https://developercommunity.visualstudio.com/t/Windows-Forms-designer-since-VS-175:-U/10303272
Lionelmesi 0 Reputation points

2023-03-08T07:02:00.79+00:00

Me too
Jack J Jun 24,296 Reputation points Microsoft Vendor

2023-03-08T09:03:30.6366667+00:00

@cstauffer, I also reproduced the problem. I also recommend that you could ask the Question in DC or follow other's submitted question.
Andy 0 Reputation points

2023-03-14T13:46:00.49+00:00

In my case, it appears that the old VS toolbox items for SqlCommand, SqlDataAdapter, etc. no longer appear to compile properly as part of the VS designer rendering code. I had to take them out of the .designer files and move the initialization code into the _Load event for the form. Once I did that, the designer would render the form again without errors.

Initially, the issue showed up as an error that it wouldn't render because it couldn't load Microsoft.Data.SqlClient version 3.0.0.0 (a DLL that I didn't use in my .NET 4.8 code, since that's something for .NET Core 3.0 or later), in case anyone is having that problem too.

Tony Lugg 40

It is a strange issue with the designer. Everything still compiles and runs but you can no longer use the designer to edit the form. Here is a stack trace form the designer window:

at Microsoft.VSDesigner.Data.VS.SqlCommandDesigner.Initialize(IComponent component)
at System.ComponentModel.Design.DesignerHost.AddToContainerPostProcess(IComponent component, String name, IContainer containerToAddTo)
at System.ComponentModel.Design.DesignerHost.PerformAdd(IComponent component, String name)
at System.ComponentModel.Design.DesignerHost.System.ComponentModel.Design.IDesignerHost.CreateComponent(Type componentType, String name)
at System.ComponentModel.Design.Serialization.DesignerSerializationManager.CreateInstance(Type type, ICollection arguments, String name, Boolean addToContainer)
at System.ComponentModel.Design.Serialization.DesignerSerializationManager.System.ComponentModel.Design.Serialization.IDesignerSerializationManager.CreateInstance(Type type, ICollection arguments, String name, Boolean addToContainer)
at System.ComponentModel.Design.Serialization.ComponentCodeDomSerializer.DeserializeInstance(IDesignerSerializationManager manager, Type type, Object[] parameters, String name, Boolean addToContainer)
at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeExpression(IDesignerSerializationManager manager, String name, CodeExpression expression)
at System.ComponentModel.Design.Serialization.CodeDomSerializer.DeserializeStatementToInstance(IDesignerSerializationManager manager, CodeStatement statement)
at System.ComponentModel.Design.Serialization.CodeDomSerializer.Deserialize(IDesignerSerializationManager manager, Object codeObject)
at System.ComponentModel.Design.Serialization.TypeCodeDomSerializer.DeserializeName(IDesignerSerializationManager manager, String name, CodeStatementCollection statements)

1 answer

Karsten Laufer 0 Reputation points

2023-03-08T08:19:54.21+00:00

Even a fresh new project "Windows Forms" has the same problem.

When drag/drop a data component form the Toolbox like SqlCommand, SqlDataAdapter the message appears:

Failed to create component "SqlCommand"... System.InvalidCastException: Unable to cast object of type 'System.Data.SqlClient.SqlCommand' to type 'Microsoft.Data.SqlClient.Sqlcommand'
Please sign in to rate this answer.

0 comments No comments
Sign in to comment