Re: I need an advice...

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Miha,

yes, there are a few people working on it and it has to run in intranet.
I'm not worried about complexity, since I have already written db
applications and remoting applications too.
I was just asking because I have never combined the 2 things and wanted to
be sure about that being a good idea.
My dubts came out for concurrecy problems, which I think I could handle
better if I had some application running on the server.
And also, since the final price is always important expecially for small
companies I have to check if I can do it the easy way (fat client with
direct connection) with sqlexpress.

Thank you for your advices.

Best regards,
Fabrizio


"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:3E8ECAD8-7801-4B4A-A078-CBB15D79D1E5@xxxxxxxxxxxxxxxx
Hi Fabrizio,

"Fabrizio Romano" <fabriz75@xxxxxx> wrote in message
news:45939c3a$0$4259$4fafbaef@xxxxxxxxxxxxxxxxxxxxxx
Hello,

maybe I'm OT, but I don't know where else I can put this question.
Say you have to write a program for a very small company (5 pc). They
just need to store some data in a database which is on a server and they
need to access this database from some other computers, with client
applications. All these pc are connected in a lan.
What is the best approach I can follow to do this?

Depends on the requirements (security, scalability, etc.). Since there
aren't many users and, I presume application runs on intranet, I would go
with 2-tiers (fat client connects directly to the database) as it is
easiest to build.

I thought about writing 2 applications: the first to be installed on the
server, will deal with the database, and the second, installed on the
other computers, deals with the first one.

This is a better but more complicated/complex approach.

In case this is the right way, what technology should I use? Remoting?
Web service? Windows service? Something else?

If client is always a .net then you should definitely go with remoting. If
you don't know what the client is/would be then web services are way to
go.

Or maybe just forget about the server application and connect to the
database directly through the lan network?

Yep, this is the easiest approach.

Or maybe nothing I just wrote...

Can anyone help me? I just need a guideline, in order to be able to
approach the problem knowing at least what I have to do.
How to do it will come later.

I program in C#2.0 with VS05 and SQLEXPRESS.

Thank you in advance and happy 2007!

:-)
--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/


.

Relevant Pages

  • Re: WebServices and Datasets
    ... And if I call the GetChanges Method on the dataset that only the ... be shown in the dataset and to pass that to the web service, ... "Now to make sure the remote database is updated with changes should I ... client a change as occurred unless the client is constantly polling it. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: WebServices and Datasets
    ... > be shown in the dataset and to pass that to the web service, ... > well ther GetChanges method creates a new dataset object with only rows ... > "Now to make sure the remote database is updated with changes should I ... > client a change as occurred unless the client is constantly polling it. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: Passing Credentials to a Web Service
    ... need to use it with SSL to prevent exposure of credentials). ... This web service is hosted in the ... is the client can be a part of the Corporate Intranet or the client can be ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: When To Use .NET Remoting?
    ... I'm now going to learn .NET Remoting and have a plan to modify my ... Database directly. ... retrieving/formatting of data from the database in the client itself. ... if you create a Web Service that offers functions such as 'int ...
    (microsoft.public.dotnet.distributed_apps)
  • Processing and sending large data using Web Service
    ... database and converts the records into an XML document. ... then be send to the client using ... the web service. ... This is writting to a string only for testing ...
    (microsoft.public.dotnet.framework.aspnet.webservices)