CommonEngine Methods |
The CommonEngine type exposes the following members.
Methods| Name | Description | |
|---|---|---|
  | CsvToDataTable(String, CsvOptions) | Reads a Csv File and return their contents as DataTable |
| CsvToDataTable(String, Char) |
Reads a CSV File and return their contents as DataTable (The file
must have the field names in the first row)
|
| CsvToDataTable(String, String, Char) |
Reads a CSV File and return their contents as DataTable (The file
must have the field names in the first row)
|
| CsvToDataTable(String, String, Char, Boolean) | Reads a Csv File and return their contents as DataTable |
| DataTableToCsv(DataTable, String) |
Simply dumps the DataTable contents to a delimited file using a ','
as delimiter.
|
| DataTableToCsv(DataTable, String, CsvOptions) |
Simply dumps the DataTable contents to a delimited file. Only
allows to set the delimiter.
|
| DataTableToCsv(DataTable, String, Char) | Simply dumps the DataTable contents to a delimited file. Only allows to set the delimiter. |
| MergeAndSortFile(Type, String, String, String) |
Merge the contents of 2 files and write them sorted to a
destination file.
|
| MergeAndSortFile(Type, String, String, String, String) |
Merge the contents of 2 files and write them sorted to a destination file.
|
| MergeAndSortFile(Type, String, String, String, String, Boolean) |
Merge the contents of 2 files and write them sorted to a destination file.
|
| MergeFiles |
Reads the file1 and file2 using the recordType and write it to
destinationFile
|
| ReadCsv(String) |
A fast way to read record by record a CSV file delimited by ','.
The fields can be quoted.
|
| ReadCsv(String, Char) |
A fast way to read record by record a CSV file with a custom
delimiter. The fields can be quoted.
|
| ReadCsv(String, Char, Int32) |
A fast way to read record by record a CSV file with a custom
delimiter. The fields can be quoted.
|
| ReadCsv(String, Char, Encoding) |
A fast way to read record by record a CSV file with a custom
delimiter. The fields can be quoted.
|
| ReadCsv(String, Char, Int32, Encoding) |
A fast way to read record by record a CSV file with a custom
delimiter. The fields can be quoted.
|
| ReadFile(Type, String) |
Used to read a file without instantiating the engine. This method has limited features. We recommend using the non static methods. |
| ReadFile(Type, String, Int32) |
Used to read a file without instantiating the engine. This method has limited features. We recommend using the non static methods. |
| ReadFileT(String) |
Used to read a file without instantiating the engine. This method has limited features. We recommend using the non static methods. |
| ReadFileT(String, Int32) |
Used to read a file without instantiating the engine. This method has limited features. We recommend using the non static methods. |
| ReadFileAsDT(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. |
| ReadFileAsDT(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. |
| ReadSortedFile |
Read the contents of a file and sort the records.
|
| ReadString(Type, String) |
Used to read a string without instantiating the engine. This method has limited features. We recommend using the non static methods. |
| ReadString(Type, String, Int32) |
Used to read a string without instantiating the engine. This method has limited features. We recommend using the non static methods. |
| ReadStringT(String) |
Used to read a string without instantiating the engine. This method has limited features. We recommend using the non static methods. |
| RecordsToDataTable(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.
|
| RecordsToDataTable(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.
|
| RecordsToDataTable(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.
|
| RecordsToDataTable(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.
|
| RemoveDuplicateRecordsT |
This method allow to remove the duplicated records from an array.
|
| SortBigFileT(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
|
| SortBigFileT(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
|
| SortFile |
Sort the contents of the source file and write them to the destination file.
|
| SortFileByField |
Sort the content of a File using the field name provided
|
| SortRecords |
Sort the Record Array. The records must be of a Type that
implements the IComparable interface.
|
| SortRecordsByField(Object, String) |
Sort the Record Array using the field name provided. (for
advanced sorting use SortRecords)
|
| SortRecordsByField(Object, String, Boolean) |
Sort the Record Array using the field name provided. (for
advanced sorting use SortRecords)
|
| TransformFileTSource, 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.
|
| TransformFileFastTSource, TDest | Faster way to Transform the records of type sourceType in
the sourceFile in records of type destType and write them to the
destFile.
|
| WriteFileT |
Used to write a file without instantiating the engine. This method has limited features. We recommend using the non static methods. |
| WriteStringT |
Used to write a string without instantiating the engine. This method has limited features. We recommend using the non static methods. |
See Also