What is the difference between Fetch and Query?

c# petapoco
jkl picture jkl · Jun 5, 2014 · Viewed 10.8k times · Source

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?

Answer

Complexity picture Complexity · Jun 5, 2014

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.

Related questions

How to check a var for null value?

I am using PetaPoco Micro-ORM with C# 4.0. The code below retrieves a single row from the database: var result = db.SingleOrDefault<TdUsers>(getUserQuery); I would like to check whether or not the result contains any rows, and whether …

Read More
PostgreSQL: 42883 Operator does not exist: timestamp without time zone = text

I am using Npgsql 3.0.3.0 and PetaPoco latest version. When I run this command: var dateCreated = DateTime.Now; // just an example var sql = new Sql("WHERE date_created = @0", dateCreated.ToString("yyyy-MM-dd HH:00:00")); var category = db.SingleOrDefault<Category>(sql); I …

Read More
How to automatically create model from database using PetaPoco library?

I have a table in my database for which I want to create a model class with getters and setters. For most of the tasks in my project, I am using PetaPoco. I created models manually, but few tables have …

Read More