MySQL Bugs: #98013: Visual Studio does not see unsigned types in stored procedure

Bug #98013	Visual Studio does not see unsigned types in stored procedure
Submitted:	18 Dec 2019 0:15	Modified:	20 Dec 2019 15:41
Reporter:	Pierre Weill-Tessier	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Visual Studio Integration	Severity:	S3 (Non-critical)
Version:	8	OS:	Windows (Windows 10)
Assigned to:		CPU Architecture:	Any
Tags:	Visual Studio

Description:
Hello,

I have spent hours trying to understand what was wrong my stored procedure... But I think now this is a problem with Visual Studio.

I'm using Visual Studio Community 2019, MySQL Server 8.0.18, and MySQL for VS 1.2.9.

My problem is : I want to use a stored procedure that contains unsigned int parameters (both IN and OUT). When get the stored procedure into my dataset in Visual Studio, the method that is created to perform the stored procedure from C# uses int instead of uint.

Thanks for your help,
Pierre

How to repeat:
Create a stored procedure with paramters of type "int unsigned".
In Visual Studio, use the data sources tool to create a dataset containing the stored procedure: VS creates the appropriate wrappers. You can see the method that can be called in C# from the adapter generated by VS uses the type "int" instead of "uint".

Thank you for the bug report.