DataType Mapping text, tinytext, mediumtext, longtext

[Bitpainter]

Hello,

i use a DataGridView with an bound DataTable as DataSource.

Below there is the method to fill the DataTable:

Code: Select all

Using myCommand As New Devart.Data.MySql.MySqlCommand(myQuery, myConnection)
				myDataAdapter = New Devart.Data.MySql.MySqlDataAdapter(myCommand)
				myDataTable = oDataSet.Tables.Add
				myDataAdapter.Fill(myDataTable)
End Using

The problem now is that the .net DataType for MySQL *text is system.byte[] in DataTable
Why the Data for *text columns is not a string?

In the EF Documentation it is declared as string, why not in a DataTable?
https://www.devart.com/dotconnect/mysql ... pping.html

I don't want do Clone the DataTable and change the DataType for the Columns.
Is there a way to say the MySql Provider to map MySql *text DataTypes to String.

Best Regards

[Pinturiccio]

We could not reproduce the issue. Please create and send us a small test project with corresponding DDL\DML scripts which reproduces the issue. Please also tell us the version of dotConnect for MySQL and the MySQL server.