.NET txtReader for Text Files is a set of the classes, designed to help .NET developers to read text files from their applications. To provide familiar feel and look for the developers and allow future extension of the component, current version of the .NET txtReader for Text Files implemented as a .NET Managed Provider with the read-only capabilities and allows to read the data from the text files without using any additional providers. .NET txtReader for Text Files is a 100% .NET managed code and designed to achieve the best performance with the minimal usage of the RAM.
Known issues and limitations
Current version of the .NET txtReader for Text Files has several limitations on how it works and what it supports during reading of the data from text files. Future versions of the component could contain functionality to resolve current limitations. Current limitations are:
- No support for localized numbers and dates.
- No support for different date formats. Date values parsed using local settings of the computer where appliction executes.
- No support for multiple sets of data types when working with multiple files using same connection. When connection is created, developer can specify types of columns inside of the text files and this types will be used by the component to query all the files when working against opened connection. If there are multiple files with different structures and different types of columns, developer needs to open separate connections and work with individual files using those connections.
- Limited support for the SQL statements. Current version of the reader supports only delimited list of the file names in following format: "Filesname1;Filename2;.... FilenameN;" and treats each file as a table. List of the files names should contain at least one file name. See more details inside of examples on how to query data from the files.
- Component does not support updates of the data from the DataTable/DataSet to the underlying text file. TxtDataAdapter allows populating DataTable/DataSet with the data from the file(s), but current version does not support updates.