C# resuable library to treat a text file like a database table?

Question

I would like to store values in a text file as comma or tab seperated values (it doesn't matter).

I am looking for a reusable library that can manipulate this data in this text file, as if it were a sql table.

I need select * from... and delete from where ID = ...... (ID will be the first column in the text file).

Is there some code plex project that does this kind of thing?

I do not need complex functionality like joining or relationships. I will just have 1 text file, which will become 1 database table.

Answer 1

SQLite

:)

Answer 2

Use LINQ to CSV.

http://www.codeproject.com/KB/linq/LINQtoCSV.aspx

http://www.thinqlinq.com/Post.aspx/Title/LINQ-to-CSV-using-DynamicObject.aspx

If its not CSV in that case

Let your file hold one record per line. Each record at runtime should be read into a Collection of type Record [assuming Record is custom class representing individual record]. You can do LINQ operations on the collection and write back the collection into file.