EntitySampleList:
namespace xxx_H.Models
{
using System;
using System.Collections.Generic;
public partial class EntitySampleClass
{
public string SampleClass_No { get; set; }
public string SampleClass_F_1 { get; set; }
public string SampleClass_F_2 { get; set; }
}
}
-----------------------------------------------------------------------
{
List<EntitySampleClass> list = null;
//创建表结构
DataTable dt = new DataTable();
dt.Columns.Add("No");
dt.Columns.Add("F_1");
dt.Columns.Add("F_2");
//向表中插入数据
for (int i = 0; i <= 10 - 1; i++)
{
DataRow dr = dt.NewRow();
dr = dt.NewRow();
dr["No"] = (i + 1).ToString();
dr["F_1"] = "F_1" + i.ToString(); ;
dr["F_2"] = "F_2" + i.ToString();
dt.Rows.Add(dr);
}
//将表中数据放入对应的Entity类中
list = (from x in dt.AsEnumerable()
select new EntitySampleClass
{
SampleClass_No = x.Field<string>("No"),
SampleClassSC_F_1= x.Field<string>("F_1"),
SampleClassSC_F_2= x.Field<string>("F_2")
}).ToList();
//返回EntitySampleList
return list;
}