Click or drag to resize
CommonEngine Class
This class only has static methods to work with files and strings (most of the common tools)
Inheritance Hierarchy
SystemObject
  FileHelpersCommonEngine

Namespace: FileHelpers
Assembly: FileHelpers (in FileHelpers.dll) Version: 3.1.5
Syntax
public static class CommonEngine

The CommonEngine type exposes the following members.

Methods
  NameDescription
Public methodStatic memberCsvToDataTable(String, CsvOptions)
Reads a Csv File and return their contents as DataTable
Public methodStatic memberCsvToDataTable(String, Char)
Reads a CSV File and return their contents as DataTable (The file must have the field names in the first row)
Public methodStatic memberCsvToDataTable(String, String, Char)
Reads a CSV File and return their contents as DataTable (The file must have the field names in the first row)
Public methodStatic memberCsvToDataTable(String, String, Char, Boolean)
Reads a Csv File and return their contents as DataTable
Public methodStatic memberDataTableToCsv(DataTable, String)
Simply dumps the DataTable contents to a delimited file using a ',' as delimiter.
Public methodStatic memberDataTableToCsv(DataTable, String, CsvOptions)
Simply dumps the DataTable contents to a delimited file. Only allows to set the delimiter.
Public methodStatic memberDataTableToCsv(DataTable, String, Char)
Simply dumps the DataTable contents to a delimited file. Only allows to set the delimiter.
Public methodStatic memberMergeAndSortFile(Type, String, String, String)
Merge the contents of 2 files and write them sorted to a destination file.
Public methodStatic memberMergeAndSortFile(Type, String, String, String, String)
Merge the contents of 2 files and write them sorted to a destination file.
Public methodStatic memberMergeAndSortFile(Type, String, String, String, String, Boolean)
Merge the contents of 2 files and write them sorted to a destination file.
Public methodStatic memberMergeFiles
Reads the file1 and file2 using the recordType and write it to destinationFile
Public methodStatic memberRawReadFirstLines
Shortcut method to read the first n lines of a text file.
Public methodStatic memberRawReadFirstLinesArray(String, Int32)
Shortcut method to read the first n lines of a text file as array.
Public methodStatic memberRawReadFirstLinesArray(TextReader, Int32, Encoding)
Shortcut method to read the first n lines of a text file as array.
Public methodStatic memberRawReadFirstLinesArray(String, Int32, Encoding)
Shortcut method to read the first n lines of a text file as array.
Public methodStatic memberReadCsv(String)
A fast way to read record by record a CSV file delimited by ','. The fields can be quoted.
Public methodStatic memberReadCsv(String, Char)
A fast way to read record by record a CSV file with a custom delimiter. The fields can be quoted.
Public methodStatic memberReadCsv(String, Char, Int32)
A fast way to read record by record a CSV file with a custom delimiter. The fields can be quoted.
Public methodStatic memberReadCsv(String, Char, Encoding)
A fast way to read record by record a CSV file with a custom delimiter. The fields can be quoted.
Public methodStatic memberReadCsv(String, Char, Int32, Encoding)
A fast way to read record by record a CSV file with a custom delimiter. The fields can be quoted.
Public methodStatic memberReadFile(Type, String)
Used to read a file without instantiating the engine.
This method has limited features. We recommend using the non static methods.
Public methodStatic memberReadFile(Type, String, Int32)
Used to read a file without instantiating the engine.
This method has limited features. We recommend using the non static methods.
Public methodStatic memberReadFileT(String)
Used to read a file without instantiating the engine.
This method has limited features. We recommend using the non static methods.
Public methodStatic memberReadFileT(String, Int32)
Used to read a file without instantiating the engine.
This method has limited features. We recommend using the non static methods.
Public methodStatic memberReadFileAsDT(Type, String)
Used to read a file as a DataTable without instantiating the engine.
This method has limited features. We recommend using the non static methods.
Public methodStatic memberReadFileAsDT(Type, String, Int32)
Used to read a file as a DataTable without instantiating the engine.
This method has limited features. We recommend using the non static methods.
Public methodStatic memberReadSortedFile
Read the contents of a file and sort the records.
Public methodStatic memberReadString(Type, String)
Used to read a string without instantiating the engine.
This method has limited features. We recommend using the non static methods.
Public methodStatic memberReadString(Type, String, Int32)
Used to read a string without instantiating the engine.
This method has limited features. We recommend using the non static methods.
Public methodStatic memberReadStringT(String)
Used to read a string without instantiating the engine.
This method has limited features. We recommend using the non static methods.
Public methodStatic memberRecordsToDataTable(ICollection)
Converts any collection of records to a DataTable using reflection. WARNING: this methods returns null if the number of records is 0, pass the Type of the records to get an empty DataTable.
Public methodStatic memberRecordsToDataTable(ICollection, Int32)
Converts any collection of records to a DataTable using reflection. WARNING: this methods returns null if the number of records is 0, pass the Type of the records to get an empty DataTable.
Public methodStatic memberRecordsToDataTable(ICollection, Type)
Converts any collection of records to a DataTable using reflection. If the number of records is 0 this methods returns an empty DataTable with the columns based on the fields of the Type.
Public methodStatic memberRecordsToDataTable(ICollection, Type, Int32)
Converts any collection of records to a DataTable using reflection. If the number of records is 0 this methods returns an empty DataTable with the columns based on the fields of the Type.
Public methodStatic memberRemoveDuplicateRecordsT
This method allow to remove the duplicated records from an array.
Public methodStatic memberSortBigFileT(String, String)
A fast way to sort a big file. For more options you need to instantiate the BigFileSorter class instead of using static methods
Public methodStatic memberSortBigFileT(Encoding, String, String)
A fast way to sort a big file. For more options you need to instantiate the BigFileSorter class instead of using static methods
Public methodStatic memberSortFile
Sort the contents of the source file and write them to the destination file.
Public methodStatic memberSortFileByField
Sort the content of a File using the field name provided
Public methodStatic memberSortRecords
Sort the Record Array. The records must be of a Type that implements the IComparable interface.
Public methodStatic memberSortRecordsByField(Object, String)
Sort the Record Array using the field name provided. (for advanced sorting use SortRecords)
Public methodStatic memberSortRecordsByField(Object, String, Boolean)
Sort the Record Array using the field name provided. (for advanced sorting use SortRecords)
Public methodStatic memberTransformFileTSource, TDest
Transform the records of type sourceType in the sourceFile in records of type destType and write them to the destFile. (but returns the transformed records) WARNING: this is a slower method that the TransformFileAssync.
Public methodStatic memberTransformFileFastTSource, TDest
Faster way to Transform the records of type sourceType in the sourceFile in records of type destType and write them to the destFile.
Public methodStatic memberWriteFileT
Used to write a file without instantiating the engine.
This method has limited features. We recommend using the non static methods.
Public methodStatic memberWriteStringT
Used to write a string without instantiating the engine.
This method has limited features. We recommend using the non static methods.
Top
See Also