[ACCEPTED]-From datatable to Entity-datatable

Accepted answer

Score: 12

I'm not sure this is exactly what you're 7 looking for but it should work; there is 6 a .AsEnumerable() extension method which you can then use 5 to project the row into a new entity.

var products = productTable.AsEnumerable().Select(row => new Product 
{
    ProductID = row.Field<int>("ProductID"),
    Name = row.Field<string>("Name"),
    CreatedDate = row.Field<DateTime>("CreatedDate")
});

As 4 far as I know the .Field<T>() method doesn't do any 3 type conversion so if the column hasn't 2 had the type set you will need to do the 1 conversion yourself.

Score: 4

I believe this is what you are looking for: Converting DataTable to Entities

Source: stackoverflow.com

Convert DbContext to Datatable in Code first entity framework

C# DBNull and nullable Types - cleanest form of conversion

Unable to Copy datacolumn from one data table to another

delete datarow from datatable

Epplus get the column header

Best practice when converting DataColumn values to an array of strings?

DataTable Union

copy a single row from one datatable to other

Converting a DataTable to an CREATE TABLE + INSERT script for SQL in C#

Convert DataTable to JSON with key per row

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.