Geek Answers Handbook

.NET Data Storage - Single File Database

I have a C # application that allows one user to enter information about clients and jobs. The information is very simple.

  • Client: name, number, address, email address, linked site.
  • Place of work: name, location.

Here are my specifications that I need for this program.

  • There is no limit to the amount of data entered.
  • One user for each application. No simultaneous activity or multiple users.
  • Allow export of user records / data to an external file that can be easily shared between applications / users.
  • Allows user queries to display customers based on various combinations of customer information / job information.
  • Data will never be viewed or processed outside the application.
  • The program will work almost always comes down to the taskbar.
  • Startup time is not very important, but I would like the requests to be significantly fast.

All this seems to point me to a database, but very light. However, I also need it to have no data storage restrictions. If you agree that I should use the database, please let me know what works best for my needs. If you don’t think I should use a database, make a few other suggestions about what you think is best.

+5
source share
6 answers

, 100% . , ( ), ( , ).

SQLite ( "SQL Lite";)). google , , #. this # SQLite, !

+3

- SQLite. : http://sqlite.org/. #: http://sqlite.phxsoftware.com/

SQLite . , , - Microsoft Access.

+4

SQLite? , .

System.Data.SQLite .NET.

+3

:)

: " , ?"

, . , , .

, :

. XML , , ( , ). XML- ..

Distributable DB - SQLite SQL Compact ;

- SQL Express - . , , . , MS Office ( ), - , Access, , SQL Express.

DB - MySql, SQL Server, PostGreSQL .

, XML, , , ( , XML, , ). ​​

/ :

  • .
    • XML , . 10- , 100 ( ), , " ?".

Pros

  • . .
    • XML (AppDomain, ). , concurrency .
  • / / , /.
    • XML , Excel, ..
  • / .
    • Linq-to-XML - : D
  • .
    • .... , , .
  • , .
    • XML , ( , )
  • , ,
    • XML ; , . , , /-/ , ( ) ..
+3

SQL Server Express . , , , ? - , , SQL Server - , , - , , .

0

. SQLite , .

SQL Server Express, Microsoft ( #).

The third option is a document database such as Raven , which can match the sounds of your data.

change
The fourth option is to try Lightswitch when the beta comes out in a few days. (8-23-2010)
/ change

There will always be a restriction on data storage (empty space on the hard disk). According to Wikipedia, SQL Express is limited to 10 GB for SQL Server Express 2008 R2

0
source

More articles:


All Articles