Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
Do you have nullable reference types enabled? If so, you might need to change your model correspondingly.
Problem with Azure Database for MySQL
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 15%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELE%3C/text%3E%3C/svg%3E)
Lab Emersive
0
Reputation points
I receive this message:
InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
MySqlConnector.MySqlDataReader.GetString(int ordinal) in MySqlDataReader.cs, line 287
Azure Database for MySQL
Developer technologies | .NET | Other
Developer technologies | .NET | Other
Microsoft Technologies based on the .NET software framework. Miscellaneous topics that do not fit into specific categories.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator2023-07-21T17:43:44.8+00:00 Hi Lab Emersive,
Thanks for using Microsoft Q&A!!
Based on the error it looks like the null in column values are causing this error. Can you please provide more context including the table schema, sample data and code snippet so that I can provide any further suggestions.
Thanks
Saurabh
Sign in to comment