How to map DataTable to DTO?

Question

string connString = @ "server =.; database =appsword; uid = madhubaabu; pwd = Welcome@123; " ; string query = "SELECT distinct TOP 5 ISNULL(C.Name, 'Others') AS 'Company',A.Name AS 'Customers', O.Fee AS 'Amount' FROM ClientCursor.Opportunity AS O INNER JOIN Common.Company AS C ON C.Id = O.ServiceCompanyId INNER JOIN [ClientCursor].[Account] AS A ON A.Id = O.AccountId order by O.Fee DESC" ; SqlConnection conn = new SqlConnection(connString); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da= new SqlDataAdapter(cmd); DataSet ds = new DataSet(); //conn is opened by dataadapter da.Fill(ds, "newtbale" ); return ds; I'm new to AutoMapper and have couple of questions regarding datatable to object mapping.I have sqlquery code and sql result like above. I want to do object to object map with automapper, i.e,transfer datatable to Class object(viewmodel) by using ado.net. can anybody help on this!

Manas Mohapatra · Answer

Try with below code: SqlConnection conn = new SqlConnection(connString); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da= new SqlDataAdapter(cmd); DataSet ds = new DataSet(); //conn is opened by dataadapter da.Fill(ds, "newtbale" ); System.Data.DataTable people = ds.Tables[0]; AutoMapper.Mapper.Reset(); AutoMapper.Mapper.CreateMap (); List results = AutoMapper.Mapper.Map >(people.CreateDataReader()); return results; https://github.com/AutoMapper/AutoMapper

sai kumar · Answer

Thanku for your answer .but what i have to write code if i have different column names in my dto. i.e in customers place i have customer property in person class then how to map with different property names.