Micro database for .Net application?

Question

.NET

Desktop application. To work, you need to search and select a table (DB, array, XML, etc) for a thousand other lines, this is the maximum. The table must be stored locally.
The situation is not exactly typical, but certainly not rare. Using a mature *SQL server for this seems insane. I would like to ask how you act, so to speak, best practice.
What to store? XML, Access MDB?
What are the interaction interfaces? ADO.NET? LINQ?
I would like the possibility of RegExp, a minimum of code and not cycling.

Answer 1

Microsoft SQL Server Compact + Entity Framework.

Answer 2

Everything is already native there, learn the materiel.
System.Data.DataTable, System.Data.DataView, System.Data.DataSet.
DataTable should come up, you can make a selection by filter, serialize everything in XML and put it in a file, and then count it back.
System.Data.DataTable.Select(String, String), msdn.microsoft.com/ru-ru/library/way3dy9w
If you're into sorting stuff, use DataView.
If you do not like DataTable and want data in the form of a tree, then use System.Xml.XmlDocument, you can select data through XPath in it.
In general, the system already has almost everything for working with data.

Answer 3

1000 lines? Can you serialize it to a file?

Answer 4

I agree with z130.
You can also do it through Access, everything is simple there, I remember when I did it even without special knowledge, and there are enough examples on the Internet.