How to convert typed DataTable into List of Entity?

c# entity strongly-typed-dataset
Arpit Khandelwal picture Arpit Khandelwal · May 2, 2011 · Viewed 11.2k times · Source

I need to convert the data of a Typed DataTable to List of my entity. I've Mapped all the fields of entity with field of DataTable.

Any ideas?

Answer

Marcus Hammarberg picture Marcus Hammarberg · May 2, 2011

I would check out AutoMapper which is a great tool that focus on these kind of scenarios.

Also here is guy that have done exactly your scenario.

Hope this was helpful!

Related questions

How to load just the last record from entity with LINQ?

I want to fetch value of field named "Gram" from the last record and put its value into a variable, without using any conditions. First I tried int value = int.Parse(Entity.TblGold.LastOrDefault().Gram.ToString()); Second I tried int …

Read More
LINQ to Entities does not recognize the method 'Int32 Parse(System.String)' method, and this method cannot be translated into a store expression

I am using Entity Framework, and I have a line of code that is taking a var and translating it back to an iint for the database. var record = context.enrollments.SingleOrDefault (row => row.userId == int.Parse(UserID) &&…

Read More
Efficient way of updating list of entities

I am working on a project which allows the user to edit a list of entities. I map these entities to view models and display them with editor fields. When the user presses the submit button, I go through each …

Read More