Description: Maps a IDataReader or DataTable to a list of plain old CLR objects. It will also map a DataRow to a single plain old CLR object. The column names to be mapped to the POCO must match (case insensitive) the names of the properties in the POCO.

Any properties in the POCO that are DBNull or do not exist in the IDataReader, DataTable, or DataRow the POCO is being mapped to; will be intialized to the default value of the property's .Net data type, with the exception of a string, which will be intailized as an empty string (can be overridden with an optional argument). Any columns in the IDataReader, DataTable, or DataRow that are not in the POCO will be ignored by the MapTo extension method.

One can override a property's default value by passing in a default instance of the POCO intialized with default values set. For instance, you may want to override a null integer value from the data source to a -1 in your POCO.

Efficiency: These extensions use the [FastMember] (https://www.nuget.org/packages/FastMember) NuGet package to iterate through properties using emitted IL instead of reflection, which is considerably faster. The extensions also use a [compiled lambda expression] (http://stackoverflow.com/questions/6582259/fast-creation-of-objects-instead-of-activator-createinstancetype?rq=1) taken from stack overflow (see answer 21) to create objects instead of using Activator.CreateInstance(). This is very close to the speed of using the new operator.

Examples:

IDataReader:

var customerList = reader.MapTo<Customer>();

or

var customerList = reader.MapTo(new Customer { Zip = 0 });

or to return nulls instead of empty strings for null strings in the IDataReader

var customerList = reader.MapTo(new Customer { Zip = 0 }, false);

DataTable:

var customerList = dataTable.MapTo<Customer>();

or

var customerList = dataTable.MapTo(new Customer { FirstName="Please", 
												  LastName = "Enter",
                                                  Zip=0 
                                                 });

or to return nulls instead of empty strings for null strings in the DataTable

var customerList = dataTable.MapTo<Customer>(false);

DataRow:

var customer = row.MapTo<Customer>();

or

var customer = row.MapTo( new Customer { Zip = 0 });

or to return nulls instead of empty strings for null strings in the DataRow

var customerList = row.MapTo(new Customer { FirstName="Please", 
											LastName = "Enter",
                                            Zip=0 
                                          }, false);

Description: This extends DataRow and will convert a column's value to the .Net type specified. One can also pass a default value to return if the column is DBNull. This extension will turn an empty string if the database string value is DBNull.

Examples:

DataRow:

var customerId = row.ConvertTo<long>("CustomerId");

or

var customerId = row.ConvertTo("CustomerId", 0);

These DataExtensions depend on the NuGet package FastMember.

The unit tests are using the NUnit framework.