Really really basic C# and SQL solution

Question

Hi I need to develop simple c# desktop-based software that will execute simple queries on a local SQL database. Another 2 computers in the office must also be able to use this software (where the software will then access the same SQL database on the first computer). QUESTIONS: - What software can I use to host the SQL database? - Is distributing the software over the network going to be a big issue? Is it fairly simple to install on each computer and get it to access the database remotely on two out of the 3 computers? Thanks a lot in advance I appreciate any feedback on this problem Dan

Muralidharan Deenathayalan · Answer

1) To host the sql database you can use sql server 2005 or later. 2) You can install your windows application and they can access the sql from machine 1.That is not an big issue unless you're having heavy data. If you want process lot of data then move the SQL Server into different machine. 3) If you develop a desktop application if you fix any issue  you install the latest version on all (here both ) machines. If you forget install the latest version then there will a problem. To avoid this  you can use clickonce deployment so the user always will take the latest version from the server and it will in their local machine. http://msdn.microsoft.com/en-us/library/t71a733d(v=vs.80).aspx Hope this helps you.

Muralidharan Deenathayalan · Answer

If my post helped you please Mark As Answer !

Dan · Answer

Murali - thanks a LOT for such a prompt and helpful response! The amount of data passed to and from the database will be relatively small so I can't see their being a problem with that. This should be a really simple solution with a bit of luck. Thanks again.