What would you recommend for this project?

Question

I need to create an application using C # for the Windows platform.

Usually all the work that I did was on the same machine: it had Visual Studio 2010, Microsoft SQL Server, and a number of other tools.

If I use the Entity Framework, for example, I know that this will work because I have the SQL engine installed.

Here is my problem and the gist of this question:

• What would you use to save information? This software will be sold to various third-party companies, and I can’t imagine how the company is going to install SQL Server, then tables , and then finally it will work. It is necessary for Just Work ™

• I need to be able to search by "records"; by dates, identifiers, names, locations, etc. Using SQL would be pretty simple, but I come back to the problem of numbers 1.

I am sure that I am missing something that each of them will find out at some point, so thanks in advance for the leadership.

Edit: missed the most important part of the question, what is the project?

This basically stores the information from the receipt, then you can scan the receipt (I will use the Office API for this) and match this scan with the entry I entered earlier. So it will be ID, Name, Amount, ScannedImage. In a nutshell.

Edit 2: Another important information:

, , , . , ocassional , , .

Answer 1

SQLite. , , ORM.

Answer 2

- SQL Server SQL . .

SQL-, SQL compact edition. , ..

SQLite

SQL express 4gb. , - SQL , SQL Server, ( )

, , ..

Answer 3

- SQL, , , ​​ RavenDB MongoDB

.

Answer 4

Firebird . xcopy , , . Linux MacOSX, ( Mono .Net).

. SQLite .

Answer 5

.

XML ? LINQ to XML . . Just Just Works ™. .

. , , , , , .

, ( ).

.

Answer 6

.net, , - Sql Server Compact, sqlite, microsoft, VS.Net.

http://www.microsoft.com/sqlserver/2008/en/us/compact.aspx, .

Microsoft SQL Server Compact - SQL Server, , -.

• ,
• ClickOnce, XCopy, MSI, CAB -admin
• , , Microsoft Windows.
• Transact-SQL SQL Server
• Microsoft Visual Studio 2008
• Supports ADO.NET, LINQ to SQL, LINQ to Entities, and the Entity Framework ADO.NET
• Support for multiple concurrent local connections

Answer 7

With all the details you provide, embedded databases will be the best solution, use System.Data.SQLite .