How to map DataTable to DTO?

sai kumar

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!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
Accepted 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 kumar10y ago
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.