Convert C# single-user application with MySQL DB to multiuser application

Question

I am experienced enough with single user desktop application in C# with MySQL. Now, I have a requirement to develop a mulituser desktop application with MySQL. I need to know a few things here:
- Given that i am using MySQL DB, do i need to programmatically take care of data corruption/integrity /locking issues in my code in multi-user environment?
- When the application is ready, I will create setup project of my app using Visual Studio. My question is: will the server only have database & the client application will be installed on all computers? Is that correct? All the client software will use the central database residing on a different location.
- How do i create Visual studio setup project to create the MySQL database on the central location?

Is there anything else I need to take care in a multi-user environment?

Please advise!

Dharmesh sharma · Answer

hi Aman your single user application can work on multi user environment but problem is which u can may be face on the use of this application 1. some user permission which us allow or how much permission u allowed in your application 2. your sql server data insertion may be unique for example is two user access same the data at same time then changes only one allow ok. this is for Sql database U no need to install the any component of Sql on the every client system just install the your application i u use the local area network then simple u install the sql full and get the sql access string and alow this system TCP/IP or remote services simple u can create the admin user which has all permission and create a user with permission your sql query simply same.

Dharmesh sharma · Answer

what u want? 1. if u use Mysql then purchase the hosting any type of windfow or linux then u can aacess the mysql or MSsql 2. if put the connection string the nobody access your db only which person use which have your c# application if u not geeting me u can free to call me any time 9873790576

Aman Ghai · Answer

I visited WWW.znetindia.com but i did not find a place to buy SQL space. Do i need to buy normal Linux web Hosting & then create a MySQL database in that? Is there anything else like IP restrictions that i need to take care of? Because my C#.Net application is installed in user's local machine & they will access MySQL DB from their local machines. Please help me! Thanks Amandeep

Dharmesh sharma · Answer

now u want to put the database on internet server for this u need Here is two things 1. u can take webspaces or sql spaces on the any hosting server like WWW.znetindia.com that provide the hosting and sql spaces then u can upload the backup file to the internet and get the inter net connection string and put the this string into the project code 2. you can percuse a dadicate IP or server and install the sql to the server then this server provide the sql server online but its so coustly i thing first one is better if u get my answer then accept th my ancswe

Aman Ghai · Answer

Great Thx for your reply. Just a few last questions. - I need to put this MySQL database on internet server. How do i go about it? - Also how do i access this DB on internet server from my code? Thanks Aman