I am using CTE with PetaPOCO and getting a strange error SQL Exception: Invalid Object Name PayTransactionForRollingVacationAverage that references the model that the data should map to. The code ...

For while I am trying to call SQL Server 2008 R2 stored procedure using PetaPoco. My stored procedure accepts a table valued parameter. How I can call the stored procedure in petapoco with table...

way to map the following to a Dictionary?? Sql sql = new Sql() .Append("SELECT Count(*) ") .Append("FROM Custumers") .Append("WHERE CustomerId = @0", Id) var result = database.Fetch<Dictionary...

I am trying to use Npoco but running into some problems with FetchOneToMany I have a sql statement that joins 2 tables together and I output all the columns. [TableName("TableA")] [PrimaryKey("...

I just test PetaPoco Transaction in a multithread way... I have a simple test case : -- Simple value object call it MediaDevice -- Insert a record an update it for 1000 times void TransactionThr...

I am using PetaPoco on my current project as a micro ORM and i must say that i like it. However, i found myself struggling with simple scenario - unit testing services that use PetaPoco.Database p...

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

I am using PetaPoco.Core 4.0.3 in a C# app to access a MySql database. I'm trying to create a query that uses variables, but I don't want them to be treated by PetaPoco as input parameters. Here ...

I need to create a DAL and repositories using petapoco. The difficulty that comes in, is that I dont know how it manages its connections. If I was using dapper I know how the connection proc...

I am having an sql statement as follows: SELECT [User].[ID], [User].[Name], [User].[Email] FROM [User] WHERE Email = '[email protected]'' and it's firing an error as follows from pet...

I'm trying to get MVCMiniProfiler to work with PetaPoco I'm trying to set the connection in the creation of the PetaPoco DB, but run into problems (connectionClosed) public class DbHelper { stat...

What is the fastest option for inserting records into the database: using which of these: Database.Insert(poco) Database.Insert(tableName, pkName, poco) Database.Save(poco) Database.Save(tableNa...

In the example given on PetaPoco's web site, this is how to decorate a class: [PetaPoco.TableName("articles")] [PetaPoco.PrimaryKey("article_id")] public class article { public long article_id { ...

I have a table containing service announcements. For this table I have a 1:1 POCO - except that it contains one extra field. In my query this is the joined in username of the author, the table cont...

I have a list objects I use to fill using Petapoco. The class properties and names are maching the database schema. The main class is Issue, and it is related to two other classes which names and ...