0

I have a DataRow object from a dealers DataTable which has columns d_id, d_name, d_contactInfo and a domain class object Dealer that has properties id, name, contactInfo. I am looking for a way to convert this dataRow to the domain class object by using a conversion such as 

DbDataSet.dealers.FindByd_id(id) as Dealer;

Is there some way I can achieve this? because if so, the code would look MUCH cleaner than having to specify attribute mapping one by one. Thanks.

Yasith Jayawardana
  • 85
  • 7
  • 3
    This link is not really an exact duplicate of your question but the answer is one possible solution in your case (use a library like AutoMapper): http://stackoverflow.com/questions/24665660/convert-datarow-to-object-with-automapper – blins Jul 08 '16 at 03:11

1 Answers1

1

You have a couple of options to solve this. One is to create your own data layer object that maps the fields in the DataRow to an object. If you want this more automagic, you can either create a helper routine, or if you can get the data out as XML or JSON, you can use serialization to match the items. This is the harder way to accomplish this.

If you can refactor the code, you can use Entity Framework to match the items. I am not as fond of it in Enterprise scale code, but it works fine with others. There are other OR/M products, many open source, that can do it as well. Chosing the correct one depends on your requirements (some are faster, some have more features, etc.)

There are also products that can map from one shape to another and save you some time, as is mentioned in the comments.

Gregory A Beamer
  • 16,870
  • 3
  • 25
  • 32