hello. how are you?
Making windows application server app and client apps. that is, client programs need to do the data in the Sql Server not directly, but through the Server App.
For example, there is a login form at the client's opening. By typing the server ip and port on the form, it will connect to the Server App. Then it will type the user name and password and open the program.
In other words, all clients will connect to the Server App and direct their queries to it, and the Server App will process the data from sql and recycle it. You entered an incorrect password or user, or returning true to allow the client's main form to be opened, and any other conceivable action. In other words, clients will carry out all their operations (select, insert, update, delete) over the Server App.
Assuming that there may be a large number of clients and a large number of queries from them, some of the clients will be connected locally, and some will be connected over the Internet, what would be the best way to do this?
Following a gentle way and method creates a fast, continuous and flexible infrastructure.