Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ADO.NET databse
Hi,
 
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
Comments
Nelek at 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
bikramjeet.sm at 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
good
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!
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 6,569
1 Sergey Alexandrovich Kryukov 6,168
2 DamithSL 5,228
3 Manas Bhardwaj 4,717
4 Maciej Los 4,150


Advertise | Privacy | Mobile
Web02 | 2.8.1411022.1 | Last Updated 11 Nov 2012
Copyright © CodeProject, 1999-2014
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