C # resuable library for processing a text file like a database table?

Question

I would like to store the values ​​in a text file as values, separated by commas or tabs (this does not 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 any plex code project that does this?

I don’t need complex functions like union or relationships. I will only have 1 text file, which will become 1 database table.

Answer 1

Sqlite

:)

Answer 2

LINQ to CSV.

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

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

CSV

. Record [, Record - , ]. LINQ .

Answer 3

ODBC. Microsoft csv-Files. , . , ODBC, . linq.

Answer 4

FileHelpers? CLR. - LINQ to Objects, .

Answer 5

public class Item
{
    public int ID { get; set; }
    public string Type { get; set; }
    public string Instance { get; set; }
}

class Program
{
    static void Main(string[] args)
    {
        string[] lines = File.ReadAllLines("database.txt");

        var list = lines
                .Select(l =>
                    {
                        var split = l.Split(',');
                        return new Item
                        {
                            ID = int.Parse(split[0]),
                            Type = split[1],
                            Instance = split[2]
                        };
                    });

        Item secondItem = list.Where(item => item.ID == 2).Single();

        List<Item> newList = list.ToList<Item>();
        newList.RemoveAll(item => item.ID == 2);

        //override database.txt with new data from "newList"
    }
}

. LINQ , . List RemoveAll, , :

newList.RemoveAll(item = > item.ID == 2);

"LINQ to Text CSV Files": http://www.codeproject.com/KB/linq/Linq2CSV.aspx

Answer 6

I would also suggest using ODBC. This should not complicate the deployment, the entire configuration can be installed in the connection string, so you do not need a DSN.

Along with the file, schema.iniyou can even set column names and data types; check the KB article from MS .

Answer 7

sqllite or linq to text and csv :)