DataType Mapping text, tinytext, mediumtext, longtext

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Bitpainter
Posts: 1
Joined: Thu 09 Feb 2017 15:13

DataType Mapping text, tinytext, mediumtext, longtext

Post by Bitpainter » Thu 09 Feb 2017 15:30

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
Devart Team
Posts: 2141
Joined: Wed 02 Nov 2011 09:44

Re: DataType Mapping text, tinytext, mediumtext, longtext

Post by Pinturiccio » Mon 13 Feb 2017 11:38

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.

Post Reply