Top "Petapoco" 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.…

c# .net c#-4.0 .net-4.0 petapoco

Bulk insert/Update with Petapoco

I'm using the Save() method to insert or update records, but I would like to make it perform a bulk …

petapoco

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 …

c# postgresql npgsql petapoco

How do I use the SQL WHERE IN construct with PetaPoco?

I have a database table named Tags (Id, Name) from which I would like to select the ones where the …

orm petapoco npoco

Calling stored procedures with parameters in PetaPoco

I want to be able to call a stored proc with named parameters in PetaPoco. In order to call a …

sql petapoco

Execute stored procedure with PetaPoco

I have a stored procedure which returns back a table value. Here is my stored procedure: PROCEDURE [GetPermitPendingApproval] @permitYear int = …

stored-procedures petapoco

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. …

c# .net orm petapoco

What is the difference between Fetch and Query?

To me, PetaPoco's Database.Fetch and Database.Query seem to be doing the same thing. For example, var db = new …

c# petapoco

Why does PetaPoco return from a db.Insert a ID field of 7 as a decimal

When doing a Insert the variable id is returned as an object. However in my database it is an int …

c# .net petapoco

Exception Details: System.ArgumentNullException: Value cannot be null. Parameter name: meth when running

I am having a project in which I have my API classes and in that project I have generated the …

petapoco