Communicating with database
I am writing an small membership application. The program will probably run an a single machine but I need to way to allow any user that logs on to access the underlying database. I have heard that I could implement this feature through a windows service and use remoting. Could anyone give me a head start on this issue? BTW the program wil be distributed via CD-ROM so the installation needs to be as simple as possible.
Mahesh ChandPosted Jul 8, 2008, 6:50 PM
You probably heard of using a Webservice (not Windows service) and remoting.
If I have a choice and since it looks like it's just accessing data, I would create a Web application, not a Windows application, unless there is some functionality you can't implement in a Web application (ASP.NET). The advantage of creating a Web application is you don't have to worry about creating an installer and giving CDs to all of your users. You simply have to give them the URL of your website and they can access it from anywhere in the world.
A Webservice or Remoting and two ways to access some remote data. Once you use a Webservice, you won't have to worry about Remoting.
To start with how to create a WebService and access it from an ASP.NET application, start with this chapter: Chapter 31:Creating Web Services by Praveen Moosad on Apr 29, 2008
More articles and tutorials on Web services can be found here:
http://www.c-sharpcorner.com/Articles/ArticleListing.aspx?SectionID=1&SubSectionID=133