MySQL
Hi everyone. I have a project to hand in about a week and i have a problem. This si for my Data Base class, so what my app is supposed to do is connect to a data base. That simple. Now how could i do something like that with Visual C# 2005 Express Edition. I don't have access to a windows server so there is no way i can install a server. What i do have access to is a linux server running MySQL. So the question is, is there any way i can either connect to MySQL server from my app, or is there any way i can make a distributed data base where my app only downloads part of the data base and useses it locally and then updates the file where it was orginally (or do you need a data base manager for that??).
Any help would be greatly apreaciated, or any other solution that will help me with my project. I don't know, i was even thinking of downloading the SQL Server 2005 Express Edition and installing on my computer and use it as a server, but i don't want to have to do that, so please HELP!!! thanks
One of the limitations to the express products is that it can only connect to certain databases. Now with the last statement this refers to the database wizards and binding controls, if you can code the connections and relevant code yourself you can still connect to any database source you would like. (There Have been several posts in the forums that go through this, you may have to search the Express general forums)
One way that I have been playing with is to create my own data layer that publishes the data as objects, then using the new binding to objects tools I can have the data controls work with the object data. A good example of this is the Photos code inside the Person Web Site Starter Kit.
