本文介绍了Peta Poco where子句的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正试图在petapoco中做到这一点
I am trying to do this in petapoco
var people = db.Query<Person>("SELECT * FROM people").Where(p => p.FirstName.Equals("George") && p.LastName.Equals("Clooney")).ToList();问题在于它从数据库中获取了整个记录集,然后对其进行过滤.我尝试使用Fetch而不是查询,结果相同.
the problem is that it gets the entire set of records from the database and then performs the filtration on it. I tried Fetch instead of query, same result.
如何编写查询,以便它发送查询以从数据库中获取过滤后的结果,而不是在Web服务器上进行过滤?
How do I write the query so that it sends the query to get the filtered results from the database, instead of doing the filtering at the webserver?
推荐答案var people = db.Fetch<Person>("where firstname = @0 and lastname = @1", "George", "Clooney");
或使用NPoco(基于PetaPoco)也可以实现
or using NPoco (which which is based off PetaPoco) this is also possible
var people = db.FetchWhere<Person>(x=>x.FirstName == "George" && x.LastName == "Clooney");更多推荐
Peta Poco where子句
发布评论