Use AutoMapper to map IDataReader, DataSet, and able to object class, And automapperdatatable

Use AutoMapper to map IDataReader, DataSet, and able to object class, And automapperdatatable

AutoMapper is A. NET object ing tool.

Project address: https://github.com/automapper/automapper.

Help document: https://github.com/AutoMapper/AutoMapper/wiki

 

Main Purpose

The conversion between the domain object and DTO, and the database query result are mapped to the object.

The following describes how to convert IDataReader, DataSet, and able into entities using AutoMapper.

Dependent files: AutoMapper. dll and AutoMapper. Net4.dll

The AutoMapper. Net4.dll file can be downloaded and compiled by itself. This file encapsulates support for IDataReader.

To put it simply, use AutoMapper

Step 1: declare a ing Convention

Mapper. CreateMap <IDataReader, menuModel> (); // map IDataReader to menuModel object

Step 2: Convert objects

// IDataReader => menuModel

Using (IDataReader dr =...) {var list = Mapper. Map <List <menuModel> (dr); dr. Close ();}

The following is a self-encapsulated AutoMapper help class

Usage:

Step 1: Specify the model to be converted in the static constructor.

/// <Summary> // register the Mapper conversion rule Convention // </summary> static void Configure () {Mapper. CreateMap <IDataReader, menuModel> ();

...

Mapper. CreateMap <IDataReader, xxxxxModel> ();}

Step 2: Apply the assembly in the project and use the extension method that has been written

 

[Csharp]View plaincopy

1. Using Utitity. AutoMapper

 

IDataReader dr = ...; var list1 = dr. getEntity <List <menuModel> (); DataSet ds = ...; var list2 = ds. getEntity <List <menuModel> (); DataTable dt = ...; var list3 = dt. getEntity <List <menuModel> ();

MapperHelper source code

 

[Csharp]View plaincopy

1. Using AutoMapper;
2. Using System. Data;
4. Namespace Utitity. AutoMapper
5. {
6. /// <Summary>
7. /// Entity ing help class
8. /// </Summary>
9. Public static class MapperHelper
10. {
11. # Region configuration ing rules
12. /// <Summary>
13. /// Make sure that the ing configuration is registered only once
14. /// </Summary>
15. Static MapperHelper ()
16. {
17. Configure ();
18. }
19. /// <Summary>
20. /// Register the Mapper conversion rule Convention
21. /// </Summary>
22. Static void Configure ()
23. {
24. Mapper. CreateMap <IDataReader, xxxxModel> (); // you only need to specify the basic type. Do not write it as List <xxxxModel>.
25. }
26.  
27. # Endregion
28.  
29.  
30. # Region object ing Extension Method
31. /// <Summary>
32. /// Convert IDataReader into an object
33. /// </Summary>
34. /// <Typeparam name = "T"> </typeparam>
35. /// <Param name = "dr"> </param>
36. /// <Returns> </returns>
37. Public static T GetEntity <T> (this IDataReader dr)
38. {
39. Return Mapper. Map <T> (dr );
40. }
41. /// <Summary>
42. /// Convert DataSet into an object
43. /// </Summary>
44. /// <Typeparam name = "T"> </typeparam>
45. /// <Param name = "ds"> </param>
46. /// <Returns> </returns>
47. Public static T GetEntity <T> (this DataSet ds)
48. {
49. If (ds = null | ds. Tables. Count = 0 | ds. Tables [0]. Rows. Count = 0)
50. Return default (T );
51. Var dr = ds. Tables [0]. CreateDataReader ();
52. Return Mapper. Map <T> (dr );
53. }
54. /// <Summary>
55. /// Convert the DataTable object
56. /// </Summary>
57. /// <Typeparam name = "T"> </typeparam>
58. /// <Param name = "dt"> </param>
59. /// <Returns> </returns>
60. Public static T GetEntity <T> (this DataTable dt)
61. {
62. If (dt = null | dt. Rows. Count = 0)
63. Return default (T );
64. Var dr = dt. CreateDataReader ();
65. Return Mapper. Map <T> (dr );
66. }
67.  
68. # Endregion
69. }