.net MVC LINQ查询

public List<DeliveryVehiclesInfo> GetDeliveryShow()
{
string str = "Select * from DeliveryVehiclesInfo ";
SqlDataAdapter sda = new SqlDataAdapter(str, connStr);
DataTable dt = new DataTable();
sda.Fill(dt);
List<DeliveryVehiclesInfo> list = dt.AsEnumerable().Select(p => new DeliveryVehiclesInfo()
{
ID = p.Field<int>("ID"),
CarFrame = p.Field<string>("CarFrame"),
DepartureCity = p.Field<string>("DepartureCity"),
ReachTheCity = p.Field<string>("ReachTheCity"),
VehicleTypeId = p.Field<int>("VehicleTypeId"),
DriverNameId = p.Field<int>("DriverNameId"),
StartStateId = p.Field<int>("StartStateId"),
GpsId = p.Field<int>("GpsId")
}).ToList();
return list;
}

 

各位同学也可以调用帮助类比如DBhelp 这种  我这是通过数据适配器 将数据表填充当中