C# database application
-
Hello, I am building C# desktop application (client) that will connect to SQL Server on remote machine. There will be many clients connecting to the database at the same time. What do you advise me to do? a) Schould every client connect directly to the remote SQL server? b) Should I create some middle-tier between application and the SQL server, for example some webservice? If yes, whats the best way to communicate between the middle tier and the client? SOAP? I'm just new to .NET and I wonder what are drawbacks of either approach. The most important thing for me is simplicity of the solution , I need to finish thins app as soon as possible. Thanx :)
-
Hello, I am building C# desktop application (client) that will connect to SQL Server on remote machine. There will be many clients connecting to the database at the same time. What do you advise me to do? a) Schould every client connect directly to the remote SQL server? b) Should I create some middle-tier between application and the SQL server, for example some webservice? If yes, whats the best way to communicate between the middle tier and the client? SOAP? I'm just new to .NET and I wonder what are drawbacks of either approach. The most important thing for me is simplicity of the solution , I need to finish thins app as soon as possible. Thanx :)
For an internal app, I generally just connect to the database from the client.