FileHelpers 1.5.0 Released - Flat File Handling

home
c#
view story

15 Kicks

FileHelpers 1.5.0 Released - Flat File Handling(filehelpers.sourceforge.net)

submitted by patriciaaz(95) 5 years, 7 months ago

The FileHelpers are an easy to use .NET library written in C#. Is designed to read/write data from flat files with fixed length or delimited records (CSV). Also has support to import/export data from different data storages (Excel, Access, SqlServer)

1 comment |category: C# |Views: 22
Tweet

tags: FileHelpers C# OpenSource another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

secretGeek(115) -

nestor(195) -

ColdChilli(55) -

gaech(1240)

More who kicked this story...

Comments:

posted by marcos(2779) 5 years, 7 months ago 0

There are the changed in this version:

Breaking changes:

- Both DataStorages: SqlServerStorage and AccessStorage completely changed, from now you don´t need to override this classes (in fact you can´t because are sealed)
You can use these classes as client and provide the callbacks for the Insert and Fill record methods.(check the examples)
- The FieldQuoted attribute was completely rewritten to support optional quote for read, write or both.
So you need to use now the QuoteMode enum and not only a boolean. (For Excel generated CSV files you must use the QuoteMode.OptionalForBoth value) (check the examples)
- MOD: DataBaseStorage to DatabaseStorage (Case change)
- MOD: Extract and Insert Records now returns the inserted or extracted records

Mayor changes:

- ADD: New FielOptional that allows that the n last fields of a record be optional.
- ADD: Multiline Quoted Field support (with this we finish the support for Excel generated CSV files)
- ADD: Multiline Records supports via the FieldInNewLine attribute to allow records to span multiple lines
- ADD: OleDbStorage thanks to Permjeet Pandha to use with any Data Storage that supports OleDb access.
- ADD: The ReadMethods of the FileHelperEngine can return the data as a DataTable the sufix of this methods are AsDT. That is perfect to load sample data into your NUnit test (examples comming soon)
- ADD: New IgnoreEmptyLines that allows you to mark a record with it to ignore empty lines in the source data.
- ADD: CommonEngine.SortFile and SortRecords by field or using the IComparable interface if the records implement it.
- ADD: New demo code in a Console Application project to make easy to newbies play with the library. (download it from the examples)
- MOD: A lot of refactoring in the source code and changes in the the folder layout.
- MOD: Code in the Docs now highlighted with the excellent dp.SyntaxHighlighter from Alex Gorbatchev

Minor changes:

- FIX: The AsyncEngine could close the File in the BeginWriteFile under some conditions.
- FIX: IO Exception when appending to an empty file.
- FIX: Syntax in some samples and in the Wizard Templates.
- FIX: The notify progress in the DatabaseStorage working fine and tested.
- FIX: A little issue in the DatabaseStorage that can throws InvalidaCastException in the constructor.
- DEL: A lot of properties in the internal classes were deleted (aiming to reduce the dll size and library performance, much better for Compact Framework)
- DEL: The obsolete LastErrors of the ErrorManager. Now is mandatory to use Errors.
- ADD: More and enhaced NUnit tests (more than 260) based in the coverage of clover.net
- ADD: Some new and corrected Usage Examples.
- ADD: Now the Wizard Supports FieldOptional and IgnoreEmptyLines, also you can generate the Properties that maps to the fields (useful for Data Binding the RecordClass to any binding aware control in VS2005)
- ADD: Encoding support for source and destination in the transformation engine.
- ADD: A new feature for the custom converters to allow them to handle the null values
- ADD: More features in the CommonEngine: TransformFile and the fast TransformFileAsync
- ADD: two Easy methods to export/import data to/from a file.
- MOD: Wizard: now use the Beta2 of the excellent FireBall CodeEditor.
- MOD: A lot of doc corrections and adds (my english is now a bit better. I learn english with the write and fix schema =)
- MOD: Demo App rewritten to show some new features and show the syntax changes in the old ones.

Remember that the library is moving forward thanks to the help of all you. Please don't hesitate to contact me and send your ideas, question, problems or any other feedback

Most Active Users

What's this?