使用EF5.0查询数据库
开发环境:VS2010,
开发语言:C#
实现功能:从数据库查询结果。
方法1,Linq To Entity表达式:
//eg1-1:查询到新建对象
List<DeviceLocation> list =
(
from d in db.DeviceInfoes
where d.DevID == deviceID
select new DeviceLocation
{ DevID = d.DevID, PosLng = d.PosLng, PosLat = d.PosLat }
).ToList();
//eg1-2:遍历打印内容
using (var db = new AdventureWorksContext())
{
var persons = from p in db.People
where p.LastName == "Stevens"
orderby p.FirstName
select p;
foreach (var p in persons)
{
Console.WriteLine("FirstName:{0},LastName:{1}", p.FirstName, p.LastName);
}
}