This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 80%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Hello everyone,
I'm at beginner level of programming. Not much experienced but I'm fast learner.
1- I have some data that 10 different people need in the world. Like a person in France 1 in Italy 1 in Japan etc.
2- There will be more data.
3- When Italy adds new data France also should see it instantly or same day or 1 week later. Eventually everyone needs to see the changes.
4- Visual Studio windows form application for this program I'm using. Coding with C#. but I'm open for more options to do this.
5- I don't have a server connection. Maybe later. For now, I want a backdoor solution that not required server.
6- Data is personal, so security is important.
7- I can collect all data from people and update the program myself. but this is another work that time consuming. we are trying to speed up things here. So no.
8- we have a shared file that everyone can add some things. But I don't have the authority and experience to connect that server into my app. It has its own security connection.
Q1- How can I keep this data in windows form app. basicaly without setup more program. Everyone should have a simple exe. not more. SQLite maybe?
Q2- Any idea for backdoor solution? Is there a way to do this without using a server connection?
thanks.
@Saeneshteas, Welcome to Microsoft Q&A,
Q1- How can I keep this data in windows form app. basicaly without setup more program. Everyone should have a simple exe. not more. SQLite maybe?
Do you mean that you just want to have a single exe? If so, have you considered using Publish a single-file app?
Q2- Any idea for backdoor solution? Is there a way to do this without using a server connection?
As you mentioned in Q1, you could try to save your data to sqlite database, which is different from other database, it is available as a file and does not require any additional software to be installed.
The following link has a good example and you could have a look:
https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/?tabs=netcore-cli
The common approach for most of your requirements is to build a web app. Web apps can be secure as you are using modern solutions like online banks.
Whether you build such a web app or a client side solution with WinForms, you will need to hire a security professional to assist you along the design and development, as the earlier you put security consideration into the design and implementation, the more likely you put security risks under control. That's not something you can easily get from an online forum like this.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
To store data locally you can use SQLite or Sqlserver LocalDb. But how are you going to share the data? Email the data (encrypted), mail a thumb drive, etc.
the typical approach would a shared cloud based server or cloud data storage.
Seems SqlLite or SQL-Server Express would be the best options using Entity Framework Core. One advantage that SQL-Server Express has over SqlLite is robust security.
See some simple examples here.