I have puzzled myself over data communications from winforms to the SQL server database.
Here is the scenario:
I am developing a windows application which I will be publishing via ClickOnce technology.
Therefore, the client resides on user PC and the data will be communicated to a SQL server database on the internet somewhere.
I am concerned for the data security of the data transmitted from the user PC to the database.
Can anyone shed some light on how to secure the data.
FYI: I can implement a data layer which has the connection string to the SQL server. If required, I can also implement web services, etc etc.
I am open to all suggestions.