What is the difference between Fetch and Query?
c#, petapoco
Solution
According to the PetaPoco documentation, this is the answer:
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.
Problem
To me, PetaPoco's `Database.Fetch` and `Database.Query` seem to be doing the same thing. For example, ``` var db = new PetaPoco.Database("myDB"); ProductList products = db.Fetch<ProductList>("SELECT * FROM ProductList"); ProductList products = db.Query<ProductList>("SELECT * FROM ProductList"); ``` Is there any significant difference between them?