在下面的示例中,可以更改两个where子句对数据库查找的性能影响的顺序吗?
using (var context = new ModelContext()) { var fetchedImages = (from images in context.Images.Include("ImageSource") where images.Type.Equals("jpg") where images.ImageSource.Id == 5 select images).ToArray(); }
WHERE [condition1] AND [condition2]
此外,您可以编写条件,结合逻辑运算符:
where images.Type.Equals("jpg") && images.ImageSource.Id == 5