wpf connect to mysql database - C#

Abhilash J A

Please advise me. I am trying to develop Windows Application in WPF with Mysql server database.

Which approach I have to use to create connection establish on the Mysql database?

1) Entity Framework

2) ADO.NET

3) Other one

One of other matter is, the client demanding that, when installing .exe file on client machine, then should have to automatically install mysql server database (ie, xampp or other ect..) also.

How can I do this?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Deployment, whichever way you look at it, is a complicated business. Unfortunately, I don't know much about xampp deployments.

From Microsoft perspective, I was referring to an installer package, which will do the installment. But I don't know the details, sorry!

You may have to look into .msi installer, which can be seamlessly integrated inside the installer package.

https://dev.mysql.com/downloads/installer/
Abhilash J A9y ago
Hello Nithin,

With all due respect, your advice. I am already implemented ADO.NET C# instead EF to connect mysql for wpf windows application. like that :-
public void AddUserList( UserSetUp user)
        {

            dbConnection.Open();
            string query = "INSERT INTO Tble_UserSetUp (FirstName, SurName, Email, PhoneNumber, UserName, Password,Computer_Name,IP_Address,CreatedBy, CreatedDate,IsActive,Function,Department) VALUES (@FirstName, @SurName, @Email, @PhoneNumber, @UserName, @Password,@Computer_Name,@IP_Address,@CreatedBy, @CreatedDate,@IsActive,@Function,@Department)";
            MySqlCommand insertSQL = new MySqlCommand(query, (MySqlConnection)dbConnection);
            insertSQL.Parameters.AddWithValue("@FirstName", user.FirstName);
            insertSQL.Parameters.AddWithValue("@SurName", user.SurName);
            insertSQL.Parameters.AddWithValue("@Email", user.Email);
            insertSQL.Parameters.AddWithValue("@PhoneNumber", user.PhoneNumber);
            insertSQL.Parameters.AddWithValue("@UserName", Encrypt(user.UserName));
            insertSQL.Parameters.AddWithValue("@Password", Encrypt(user.Password));
            insertSQL.Parameters.AddWithValue("@Computer_Name", user.Computer_Name);
            insertSQL.Parameters.AddWithValue("@IP_Address", user.IP_Address);
            insertSQL.Parameters.AddWithValue("@CreatedBy", user.CreatedBy);
            insertSQL.Parameters.AddWithValue("@CreatedDate", user.CreatedDate);
            insertSQL.Parameters.AddWithValue("@IsActive", user.IsActive);
            insertSQL.Parameters.AddWithValue("@Function", user.Function);
            insertSQL.Parameters.AddWithValue("@Department", user.Department);
            try
            {
                insertSQL.ExecuteNonQuery();
                dbConnection.Close();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Is it bad idea? And, Did you mean, automatically install mysql database (ie, XAMPP or other one ..) also when I can create .exe file both are at the same time ?
Nitin Sontakke9y ago
Got it. You will need into installer package. Previously these were slightly easier, now very complicated. You may also look into .msi file, if available, for MySQL.

With respect to, technology, you can use whatever you are comfortable with MySQL supports EF. If you have already used EF you can use that.

https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html

I am not seeing any problem as such. You will need to go by your comfort level and quicker execution of project.
Abhilash J A9y ago
Just one MySql database inside admin computer only ! And All client machines are access that MySql by admin's pc IP address.

Sorry sir. I mean the 'client' is customer.
Nitin Sontakke9y ago
Perfect, so from whatever you are saying, assuming there are 100 clients will you have 100 db installations or just 1?

Please answer above question and we will take it from there.

If you choose 1 as an answer, please re-read your question and you will understand what I am trying to say. I am referring to the following portion of your question:

"One of other matter is, the client demanding that, when installing .exe file on client machine, then should have to automatically install mysql server database (ie, xampp or other ect..) also. How can I do this?"
Abhilash J A9y ago
Hello Nitin,

Thanks for replay me sir.

Actually client wants to use open-source relational database like MySQL. The Admin need to install mysql on his computer and then network connected other client system are needed to access the mysql database through the IP connection string
using like @"Data Source=10.0.0.101
So, I am storing information.

Please advise me.
Nitin Sontakke9y ago
This is slightly confusing to me. Why would you need a mysql server database on the client machine?

You will be storing information centrally isn't it?

Please elaborate on the requirement.