Click here to Skip to main content
15,887,776 members
Home / Discussions / C#
   

C#

 
QuestionService web inside Windows service Pin
Alvinnne29-Apr-13 0:31
Alvinnne29-Apr-13 0:31 
AnswerRe: Service web inside Windows service Pin
Eddy Vluggen29-Apr-13 0:52
professionalEddy Vluggen29-Apr-13 0:52 
QuestionLogin to windows 7 using fingerprint scanner Pin
gankanda29-Apr-13 0:22
gankanda29-Apr-13 0:22 
AnswerRe: Login to windows 7 using fingerprint scanner Pin
Eddy Vluggen29-Apr-13 0:50
professionalEddy Vluggen29-Apr-13 0:50 
GeneralRe: Login to windows 7 using fingerprint scanner Pin
gankanda29-Apr-13 22:31
gankanda29-Apr-13 22:31 
AnswerRe: Login to windows 7 using fingerprint scanner Pin
Eddy Vluggen29-Apr-13 23:02
professionalEddy Vluggen29-Apr-13 23:02 
QuestionServer Client Arhitecture Pin
Rares T28-Apr-13 22:28
Rares T28-Apr-13 22:28 
AnswerRe: Server Client Arhitecture - Semi-long post. Pin
Keith Barrow28-Apr-13 22:48
professionalKeith Barrow28-Apr-13 22:48 
Rares T wrote:
What technologies should I use.I read many articles but none of them seems to offer me a simple and efficient solution.

There isn't a single solution to this, they'll all bting their own benefits and costs.

I'd suggest using a Web API[^] to upload the documents. You can also take a look at this article[^]. The server can then save (either to filesystem or DB) and upate the Database with the new file information.
If you want a web front end you can use signalr[^] to keep things synchronised. If you are creating a forms app you can use signalr's methodology for long polling to keep things in sync.

Point 3 is simplified if you create a mobile and desktop enabled web front-end, but ultimately any app can consume the web api.


Rares T wrote:
2) Server should have an SQL database that can be accessed by all clients no matter how many clients are.

There is no system on Earth that can handle the italics part of the requirement, the best you can hope for is a highly scalable system. If you design you web api (& web-application) correctly so they can be web-farmed then you'll be pretty much set.


Rares T wrote:
I also had the idea to store everything in the database (data + files) but I don't think this is the best option because there can be almost 100 mb of new files created each day and database backups need to be done every day.

I'd avoid putting the docs in the DB in any case. I'd ferry them off in a rational folder structure and make sure it isn't accessible from the web (downloaded via the web api only). The DB can be used to store the file location, that way you upgrade your file storage as needed without "risking" the database. You can also back up the DB and documents separately.
“Education is not the piling on of learning, information, data, facts, skills, or abilities - that's training or instruction - but is rather making visible what is hidden as a seed”
“One of the greatest problems of our time is that many are schooled but few are educated”


Sir Thomas More (1478 – 1535)

GeneralRe: Server Client Arhitecture - Semi-long post. Pin
Rares T29-Apr-13 0:24
Rares T29-Apr-13 0:24 
GeneralRe: Server Client Arhitecture - Semi-long post. Pin
Keith Barrow29-Apr-13 1:33
professionalKeith Barrow29-Apr-13 1:33 
AnswerRe: Server Client Arhitecture Pin
Eddy Vluggen29-Apr-13 0:58
professionalEddy Vluggen29-Apr-13 0:58 
QuestionHow to Protect the dll or exe Code Pin
kalyanacvk28-Apr-13 22:22
kalyanacvk28-Apr-13 22:22 
AnswerRe: How to Protect the dll or exe Code Pin
harold aptroot28-Apr-13 22:25
harold aptroot28-Apr-13 22:25 
GeneralRe: How to Protect the dll or exe Code Pin
Keith Barrow28-Apr-13 22:33
professionalKeith Barrow28-Apr-13 22:33 
AnswerRe: How to Protect the dll or exe Code Pin
Eddy Vluggen29-Apr-13 0:54
professionalEddy Vluggen29-Apr-13 0:54 
QuestionHow can I get the coordinate in a web game which is develop with flashplayer Pin
Edward_Zhao28-Apr-13 14:36
professionalEdward_Zhao28-Apr-13 14:36 
AnswerRe: How can I get the coordinate in a web game which is develop with flashplayer Pin
Dave Kreskowiak28-Apr-13 15:05
mveDave Kreskowiak28-Apr-13 15:05 
GeneralRe: How can I get the coordinate in a web game which is develop with flashplayer Pin
Edward_Zhao28-Apr-13 15:21
professionalEdward_Zhao28-Apr-13 15:21 
GeneralRe: How can I get the coordinate in a web game which is develop with flashplayer Pin
Dave Kreskowiak28-Apr-13 15:28
mveDave Kreskowiak28-Apr-13 15:28 
GeneralRe: How can I get the coordinate in a web game which is develop with flashplayer Pin
Edward_Zhao28-Apr-13 15:43
professionalEdward_Zhao28-Apr-13 15:43 
Questionhow make a setup for my access database Pin
User349028-Apr-13 11:08
User349028-Apr-13 11:08 
AnswerRe: how make a setup for my access database Pin
Dave Kreskowiak28-Apr-13 15:04
mveDave Kreskowiak28-Apr-13 15:04 
GeneralRe: how make a setup for my access database Pin
User349028-Apr-13 15:38
User349028-Apr-13 15:38 
GeneralRe: how make a setup for my access database Pin
Dave Kreskowiak28-Apr-13 16:00
mveDave Kreskowiak28-Apr-13 16:00 
GeneralRe: how make a setup for my access database Pin
User349028-Apr-13 16:08
User349028-Apr-13 16:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.