FillSchema returns no Default value

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Florian Heinemann

FillSchema returns no Default value

Post by Florian Heinemann » Wed 30 Aug 2006 20:12

Hello!

We're using FillSchema to retrieve standardized table information. Unfortunately is the value "DafaultValue" not set... So we have to write special code for MySQL using GetSchema to get the default information. Is there a way to force MySqlDirect to fill in the DefaultValue column?

Regards,

Florian Heinemann

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 31 Aug 2006 07:16

To retrieve DefaultValue use MySqlConnection.GetSchema method.
For example,

Code: Select all

DataTable myTable = mySqlConnection1.GetSchema("Columns", new string[] { "Test", "emp" });

Post Reply