How to deploy C# application with database

Question

0.00/5 (No votes)

See more:

Hi All,

I have finished a program that uses a database. Now I want to deploy the project so that other people can install it. However I do not know how I should add the mysql database so that the tables and everything would be installed on the client computer so that the program works on any computer as it does on my computer while I'm debugging.

Can anyone point me in the right direction?

Regards,
Chris

Posted 11-Mar-14 9:57am

Christopher Smit

Add a Solution

Comments

Sergey Alexandrovich Kryukov 11-Mar-14 16:04pm

Are you talking about the database, or database management system (MySQL itself, as a product)?
—SA

Christopher Smit 11-Mar-14 16:09pm

Well to tell the truth I'm not sure what is necessary? I just want the tables to be there when the person installs the program on his computer. So that he can begin using the program right and the data in the software is stored as it should be. So basically the program is installed and along with that I want the database structure I suppose to be installed as well for the data to be stored. How do I do this? and what am I trying to do based on the question you asked?

Sergey Alexandrovich Kryukov 11-Mar-14 16:14pm

Wait, wait, how can you ask anything if you are not sure..? Your application depends on MySQL, this is apparent. But does it need only the client, or server, too? Does it need some predefined database, or should the database be created by the user from scratch? So, which part of it you don't know?

Also, remember, you can always claim that MySQL is the prerequisite for your product and let the user to install what's required.

—SA

Christopher Smit 11-Mar-14 16:18pm

Haha I am very confused by the whole installing the database along with the application and have a hard time trying to explain what I am trying to do. But yes the database should be predefined. The user shouldn't even have to worry about anything, to him the database does not even exist. I'm pretty new to the database development in C#. I only know about databases when it comes to PHP. So I'm still trying to learn. If my database is only a predefined database that the user doesn't even need to know about, how do I do this? A guide that teaches me how and why would be much better than just code or something that does the job for me. So would really appreciate a good explanation :) Thanks so far

Sergey Alexandrovich Kryukov 11-Mar-14 16:39pm

Well, now, do you have a database server side, or is it all on client host?
—SA

Christopher Smit 11-Mar-14 16:53pm

No database on server. Everything should happen on the user's local computer.

Sergey Alexandrovich Kryukov 11-Mar-14 17:29pm

Okay, I basically answered. See MySql documentation I referenced...
—SA

Christopher Smit 12-Mar-14 11:44am

Maybe I'm looking in the wrong place, but that link is giving me a PDF file that is only explaining why I should use MySQL....

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2014-03-11T10:42:00

Everything is covered here: https://www.mysql.com/why-mysql/presentations/effectively-deploy-mysql-applications-on-windows[^].

You can also deploy your database (meaning: predefined database, not the MySQL product itself). How you do it depends on where do you want to have it, on what host, and particular the installer toolkit you are using. Please see my comment to the question. This is a routine feature of the installer. In future, better review and devise your deployment plan and options before you start development of your projects, at least depict such plan.

—SA