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

Aman Ghai

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!

5 Replies

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

Dharmesh Sharma15y ago
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 Ghai15y ago
1. 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?
2. 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 Sharma15y ago
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 Ghai15y ago
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
Dharmesh Sharma15y ago
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.