Desktop app (SAAS) safe connection with AWS SQL server database?

Question

5.00/5 (1 vote)

See more:

Hello,

Would like some feedback as per the method I would like to connect to AWS (Amazon Web Services) with a possible commercial software developed as a desktop software.
The idea is to encrypt the data source connection in the App.config file in the .Net application to AWS SQL Server database. Would there be any security concerns with this method?

Thanks many!

What I have tried:

I am unsure if this is the best method to secure my connection to AWS SQL Server database from the App.config file in .Net app for possible SAAS commercial application.

Posted 21-Jan-18 10:23am

.NetDev_1012

Add a Solution

Comments

David_Wimbley 21-Jan-18 22:09pm

An alternative idea if you are concerned about connection strings on tons of desktops...I would just create an API that sits on EC2 to expose the various data feeds your desktop app needs so that way your desktop app just connects to the API rather than having tons of individual connections to your DB.

This also provides a maintenance relief, if you ever change the user/pass to your DB...or change your DB server all together you dont have to worry about deploying a new app.config out to all the client machines.

.NetDev_1012 22-Jan-18 10:47am

Thanks for this insightful feedback David. I've never engaged in EC2's API. Would this be functional for a CRUD .Net app with entity framework (ADO.NET Entity Data Model)?
Thanks again.

David_Wimbley 22-Jan-18 11:09am

EC2 is amazons virtualized servers. I was just saying you could create say...a web API project (restful web service) that exposes your database/necessary actions/data feeds of your database to any desktop apps without having to deploy app.config updates if you change servers on RDS.

But if you aren't familiar with web api, I'd start with a simple google search as there are tons of tutorials but in short...you can do all CRUD actions using web api.

.NetDev_1012 22-Jan-18 11:26am

I believe this method may be best given those points you mentioned.
Thanks again David.
Will keep you in mind if I ever need your employed service in this endeavour.
Thank you.

David_Wimbley 22-Jan-18 11:38am

Happy to help!

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)