We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Program Data Storage

deedub84
deedub84 asked
on
Medium Priority
719 Views
Last Modified: 2013-12-17
Hi Experts,

I'm new to C#; my experience is primarily with Access VBA.

I have developed an end-user application in Access that may be marketable.  Ideally this application would be 'stand-alone' and not an access mde etc, which would require users to own Access.  What I'm having a hard time understanding is how might a program be designed in C# which would not require a back-end data store such as sql server, access, etc. which would seemingly add to the cost.

So the question is, what is the best way to store 'user' information -- the data of the program -- in a program developed in C#;  also I'd welcome suggestions about any reference books that would cover this topic.

Thanks,
deedub84
Comment
Watch Question

Commented:
You can store it how you like is the real answer here.  Flat file may be an option (ie, serialised objects persisted to file) or maybe XML.  It depends what you want from the application.  Do you need database type functionality?  Indexed retrieval of data?  Referential integrity?

Author

Commented:
Having cut my teeth in the access / sql server world; I'm tempted to say database type functionality.  But the application really is straightforward.  I have a couple of tables that store the data in the Access version.  There is some user selection of certain lines for printing.  Probably the biggest need is some of the data (and therefore probably all) the data would need to be secured in the sense I wouldn't want anyone just to be able to open up the data and be able to read it.  The application is more along the lines of a mini app versus something with full functionality.

Ultimately, I'm so new to this part of the programming world, some pointers to good references or primers (if they exist!) would be great.
Commented:
Isolated storage may be a solution here :

http://msdn.microsoft.com/en-us/library/3ak841sy(VS.80).aspx

This will place the data in an obscure place which is good.  But it won't be encrpyted.  The AesManaged class can do that :

http://msdn.microsoft.com/en-us/library/system.security.cryptography.aesmanaged(VS.95).aspx

If using the AesManaged class, then just using a XML file format will be fine I  think.  Depends how much data you are expecting to handle.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.