Really really basic C# and SQL solution

Dan

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

3 Replies

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

15y ago
Accepted 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.
15y ago
If my post helped you please Mark As Answer !
Dan15y ago
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.