SqlDataReaderMapper 1.0.2

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<DBClass>(reader)
     .NameTransformers("_", "")
     .ForMember("CurrencyId", typeof(int))
     .ForMember("CurrencyCode", "Code")
     .ForMember("CreatedByUser", typeof(String), "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<DBClass>(reader)
     .Build();

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

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 get rid of the external dependencies to make this mapper much simpler and more lightweight.