c# - Fetch 和 Query 有什么区别？

Question

对我来说，PetaPoco 的 Database.Fetch 和 Database.Query 似乎在做同样的事情。

例如，

var db = new PetaPoco.Database("myDB");
ProductList products = db.Fetch<ProductList>("SELECT * FROM ProductList");
ProductList products = db.Query<ProductList>("SELECT * FROM ProductList");

它们之间有什么显着的区别吗？

Answer 1

根据PetaPoco documentation ，这是答案:

Query vs Fetch

The Database class has two methods for retrieving records Query and Fetch. These are pretty much identical except Fetch returns a List<> of POCO's whereas Query uses yield return to iterate over the results without loading the whole set into memory.