之前操作步骤见《C#-创建Database First Demo》:https://blog.csdn.net/sinat_40003796/article/details/100541514
代码1:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Entity.Infrastructure;//必须添加的命名空间
namespace ConsoleApp1
{
class Program
{
static void Main(string[] args)
{
//简单查询
using (testEntities db = new testEntities())
{
// EF本身查询方法返回的都是IOueryble接口,此时并未查询数据库: 只有当调用接口方法获取数据时,才会查询数据库。
//DbQuery<student> dbQuery = db.student.Where(u => u.name == "star") as DbQuery<student>;
DbQuery<student> dbQuery = db.student.Where(u => u.name == "star").OrderBy(u=>u.name).Take(1) as DbQuery<student>;
//延迟查询数据库,真实查询
student st =dbQuery.FirstOrDefault();
Console.WriteLine(st.name + ","+st.age);
Console.WriteLine("查询成功!");
Console.ReadLine();
}
}
}
}
运行结果:
代码2:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Entity.Infrastructure;//必须添加的命名空间
namespace ConsoleApp1
{
class Program
{
static void Main(string[] args)
{
//简单查询
using (testEntities db = new testEntities())
{
IQueryable<student> list = db.student;
foreach (student s in list)
{
Console.WriteLine(s.name + "," + s.age);
}
Console.WriteLine("查询成功!");
Console.ReadLine();
}
}
}
}