DataTableMapper

KO | EN

gitlite — search

#python #hacktoberfest #react #ai #llm #android #rust #deep-learning #macos #nodejs #awesome #cli #kubernetes #security

DataTableMapper

(★ 12)

Map a DataTable to a class instance via MapTo<T>() extension method

DataTableMapper Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# DataTableMapper [![NuGet version](https://badge.fury.io/nu/DataTableMapper.svg)](https://badge.fury.io/nu/DataTableMapper)

Map a DataTable to a class instance via `MapTo<T>()` extension method. The table's columns will automatically map to the class' properties by name. There are some Attributes available for mapping to a column with a different name and for default values as well as converting one value to another before setting the property.

#Nuget

Install-Package DataTableMapper

# Usage

The extension method interface is as follows

public static IEnumerable<T> MapTo<T>(this System.Data.DataTable table) where T : new()

and call the extension method

IEnumerable<MyClass> x = table.MapTo<MyClass>();
	
#Mapping

The `MapTo` method attempts to find a value for each property of the class in the following steps in order:

1. ColumnMappingAttributes - Map the property to a column with another name (NOT case sensitive)
2. Property Name - Search for columns with the property's name (NOT case sensitive)
3. DefaultValueAttributes - Set a default value in the case where both steps above were not able to get a value for the property

##Column Mapping

By default the `MapTo` function will attempt to map a property to the table's column with the same name.

Decorate properties with the `ColumnMappingAttribute` to map a property to a column with another name. The `MapTo` function will still fall back to property-name mapping if no match is found. e.g. The `MapTo` function will look for a column named "Id" to set the following property named "MyClassId"

public class MyClass
	{
		[ColumnMapping("Id")]
		public int MyClassId { get; set; }
	}	
	
The `ColumnMappingAttribute` class can be inherited for custom functionality.
		
##Default Values

Decorate a property with the `DefaultValueAttribute` to assign a value to the property in the case where no mapping can be done OR the mapping yields a `DBNull`.

class Person
        {
            [DefaultValue(99)]
            public int Id { get; set; }

[DefaultValue("Johnny")]
            public string Name { get; set; }

[DefaultValue(true)]
            public bool IsGreat { get; set; }
        }

#Conversion

For columns returning a different type to the property type. The `BoolValueConversionAttribute` comes with the library for converting columns returning `Integer` and converts it to a `Boolean` with C-like rules.

class MyClass
        {
            //Looks for column named "val" and if the value for that row is > 0 then the property will be set to true, else false
            [BoolValueConversion]
            public bool Val { get; set; } 
        }

#Extensibility

For your own custom conversion (e.g. Decryption) create an Attribute implementing the `IValueConversion` interface.

N.B. Also inherit the `ColumnMappingAttribute` class to have column mapping with the attribute.

DataTableMapper

DataTableMapper Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

DataTableMapper

DataTableMapper Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README