SQL, one of the earlier programming language, was subsequently developed by Donald D. Codd of IBM proposed the Relational Database Model in 1970. SQL defines a set of commands, such as SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, DROP TABLE, and etc.Įdgar F.
If C# can be used on Mac from the database through user interface layers, why would anyone bother with developing in Objective C, Swift, PHP, Java or etc. If someone from tech support has a trivial example that works, please post it here and you will end up with many happy customers. Making suggestions like those above does not help because that is just guessing.
This is why I would like someone to respond who actually has connected Xamarin on Mac OS X to MySQL on same Mac or with ODBC. But without C# MySQL database access, I have to write the access in Xcode, or some other language, then interop with Xamarin. I can use Java to work with MySql, but then why would I need Xamarin? Or I could use some other non-Xamarin solution which still begs the question. My clients love their Macs and they want to carry a production quality database with them. Most of Xamarin's effort targets the mobile world, and that is ok because that is your market. And it seems to me that Xamarin Mac support is somewhat limited.
And that software works very well on Windows.
The database-access link that you provided is for Windows users. Don't forget to use MySQL Workbench to verify that MySQL is running. I hope this helps the next MySQL developer.
And the Open method fails correctly when wrong credentials are used. MySqlConnection.ConnectionString = connectionString String connectionString // Note the spelling of keywords.ĬonnectionString Now we make the connection. Create a test connection in Initialize(). Final step in testing is to edit MainWindow.cs.ī. (It turns out that MySQL.Data references System.Data so both assemblies are satisfied.)ġ0. Check the MySQL.Data checkbox, then click Add Package. (Now oui-la, a whole list of popular assemblies are shown in a check box list!)Īnd best of all there is a package named: MySQL.Dataĩ. Right click Packages: select Add Packages. Check the System.Data checkbox, then OK.Ĩ. (We want to add a reference to System.Data so it can be referenced by the package we are about to add.)ħ. Right click References: select Edit References Here is the solution to the connect to MySql on a Mac.Ĥ. This time I noticed something new: Packages. Thanks to Chris's insistence, I pushed harder.