.NET txtReader for Text Files
This .NET Framework Class Library is provided by xPortTools.
The main functionality of the class library is contained in the file xPortTools.TxtClient.dll.
Add a reference to the assembly xPortTools.TxtClient and include the xPortTools.TxtClient namespace. Instantiate a new TxtConnection connection object. Set the connection string and open the connection.
VB.NET code sample
Imports xPortTools.TxtClient
Dim myConnection As TxtConnection = New TxtConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()C# code sample
using xPortTools.TxtClient;
TxtConnection myConnection = new TxtConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();Description
.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.
There are some limitations with this provider...
- 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.
More info about this class library can be found at the xPortTools product page.
Download
This .NET Framework Class Library, .NET txtReader for Text Files, can be downloaded here.
Connection Strings
The .NET txtReader for Text Files class library can be used to connect to the following data sources by using the following connection string references: