Convert my C#.Net desktop aplication 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!

2 Replies

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

Umer Ali8y ago
hello sir , i need ur contact no , i am not able to make multiuser application
0
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.
+1