Click here to Skip to main content
11,922,641 members (56,665 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# ADO.NET database

I am developing a Desktop Application,
It is a shop management system.

I want to know which new Item i need to store data of that application.
I mean i don't want to install SQL in my customer PC. this is my first live project for my first customer i just want to give him a application Setup to install the application in his system so how can i use database in this case.

Thank You
Posted 11-Nov-12 5:28am
Nelek 11-Nov-12 10:32am
Do you know how much data volumen will be involve in that application? There could be alternative ways with serialization and exporting/importing to archive files that you generate from the application. But if the data volumen is big, then it is not a good idea 11-Nov-12 10:39am
i want to do this because i want to but this on sell too that y it is good idea

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

If you are only looking at single user systems, then have a look at SqlCE or SqLite - they are both SQL compliant database (with some restrictions) which are designed for a single user environment and do not require SQL Server. You could also look at an Access based solution.

If you are looking at stock management and so on, then a database solution is better than serialization or XML files, as the whole file does not have to be re-written to insert or remove an item.

If you are looking at multiple users, then I would strongly suggest that an MsSql or MySql solution is the best way to go despite the installation problems - they make working with all the major pitfalls of simultaneous updates very, very easy (as they handle all that for you). Multi user working with your own files is a real PITA!

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.151125.1 | Last Updated 11 Nov 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100