MySQL and the CF

[Derek]

Hello

I've been using the ByteFX Data Provider for the regular framework - now I
need to access a MySQL DBase using the compact framework - ByteFX seems to
have problems with the System.Data.Common.DbDataAdapter type (imports
failing).

Are there any workarounds or other methods to access MySQL from the CF?

Thanks!

 

[Alex Feinman [MVP]]

You might need to add a reference to System.Common.DLL Unlike desktop in CF
it is in a separate assembly

 

[Derek]

That is actually what I did initially - it is still saying that the
DdDataAdapter type is failing.

 

[Alex Feinman [MVP]]

I've looked at it - you will not be able to use it as it is. It includes
support for designer which will not compile under CF. Under CF designer
component needs to be moved out into a separate project.

I'm not aware of other MySql libraries but I never really researched the
issue

 

[Derek]

Thanks for your help thus far Alex. Quick question - what do you mean as a
designer component exactly?

 

[Alex Feinman [MVP]]

The full ByteFX library allows you to drag and drop MySql connections and
commands from the toolbox onto the form. This is done via designer
components. For CF naturally designer component has to be built with
references to the desktop libraries