How do I make software that preserves database integrity and correctness? Please help, confused.
- by user287745
i have made an application project in vs 08 c#, sql server from vs 08.
the database has like 20 tables and many fields in each
have made an interface for adding deleting editting and retrieving data according to predefined needs of the users.
now i have to
1) make to project in to a software which i can deliver to professor. that is he can just double click the icon and the software simply starts. no vs 08 needed to start the debugging
2) the database will be on one powerful computer (dual core latest everything win xp) and the user will access it from another computer connected using LAN i am able to change the connection string to the shared database using vs 08/ debugger whenever the server changes but how am i supposed to do that when its a software?
3)there will by many clients am i supposed to give the same software to every one, so they all can connect to the database, how will the integrity and correctness of the database be maintained? i mean the db.mdf file will be in a folder which will be shared with read and write access. so its not necessary that only one user will write at a time. so is there any coding for this or?
please help me out here i am stuck do not know what to do i have no practical experience, would appreciate all the help thank you