I would suggest putting a middle ware between your app and your DB.. Throw a simple RESTful service between your mobile device and your MySQL DB.. This will increase security, give you a clean separation of concerns and increase the performance of your mobile app by decreasing the communications burdon of your app..
Also, are you using Mono for Android 4.0 if you are, make sure Fast Deploy is off... Your FileNotFoundException sounds related to fast deploy issues around external assemblies. Josh Handel Mobile Architect 512.328.8181 | Main 512.328.0584 | Fax 512.577-6568 | Cell www.catapultsystems.com<https://webmail.catapultsystems.com/owa/UrlBlockedError.aspx> CATAPULT SYSTEMS INC. THE MICROSOFT CONSULTING COMPANY ________________________________ From: monodroid-boun...@lists.ximian.com [monodroid-boun...@lists.ximian.com] on behalf of Vladimir Dimitrov [vlad.dimit...@gmail.com] Sent: Thursday, December 08, 2011 6:49 AM To: monodroid@lists.ximian.com Subject: [mono-android] Using MySQL Connector Hey guys, I am trying to figure out what is the best way to connect to a MySQL server from the Mono Android app I am creating. I had mixed success before. I am experimenting with the mysql.data.cf.dll version of the connector which is trimmed down version for Pocket PCs, so it gets less dependences on stuff not available like System.Transactions which I don’t need either way. The problem is that when there is no linking the app seems to work fine. But this should not be the way to proceed for production, so I looked at the linking options and added linking of all the user and SDK assemblies and –linkskip for the MySql.Data.CF assembly. But now when the package is created and shipped to the device I get a FileNotfoundException about the MySql assembly not being found at all. Any ideas what should be done in this scenario? Thanks, Vladimir
_______________________________________________ Monodroid mailing list Monodroid@lists.ximian.com UNSUBSCRIBE INFORMATION: http://lists.ximian.com/mailman/listinfo/monodroid