Text File DataProvider in .NET

Question

I want to read/write my entities in flat text file, and due to huge amount of data, Serlization/Deserialization is not proper solution.

Is there any data provider to work with text file data source (like csv,...)?

Answer 1

You can use OleDB combined with the Jet-engine:

using (var connection = new OleDbConnection(
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"" + directoryPath 
    + "\";Extended Properties='text;HDR=Yes;FMT=Delimited(,)';"))
using (var command = new OleDbCommand(
    "SELECT * FROM [" + fileName + "]", connection))
{
    connection.Open();
    using (var reader = command.ExecuteReader())
        while (reader.Read())
            ...
}