SqlDataReaderMapper 1.0.4

SqlDataReader mapper

Simple C# SqlDataReader object mapper. Allows you to map a SqlDataReader to the particular objects.

Supports simple property mapping, property name transformations, string trimming, manual property binding by name, type changing, function binding, etc.

Installing SqlDataReaderMapper

You should install SqlDataReaderMapper:

PM> Install-Package SqlDataReaderMapper

Or via the .NET Core command line interface:

PM> dotnet add package SqlDataReaderMapper

Then, use the library in the project:

    using SqlDataReaderMapper;

Here is an example of the usage:

    var mappedObject = new SqlDataReaderMapper<DTOObject>(reader)
         .NameTransformers("_", "")
         .ForMember<int>("CurrencyId")
         .ForMember("CurrencyCode", "Code")
         .ForMember<string>("CreatedByUser", "User").Trim()
         .ForMemberManual("CountryCode", val => val.ToString().Substring(0, 10))
         .ForMemberManual("ZipCode", val => val.ToString().Substring(0, 5), "ZIP")
         .Build();

Or simply:

    var mappedObject = new SqlDataReaderMapper<DTOObject>(reader)
         .Build();

Either commands, from Package Manager Console or .NET Core CLI, will download and install SqlDataReaderMapper and all required dependencies.

Copyright

Copyright © 2019 Grigory and contributors.

License

SqlDataReaderMapper is licensed under GPL-3.0. Refer to LICENSE for more information.

What's next

I'm planning to make this library static.