Click here to Skip to main content
12,299,821 members (58,030 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# ADO.NET database
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 4:28am
Comments
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
bikramjeet.sm 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
Top Experts
Last 24hrsThis month


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