NPoco
NPoco copied to clipboard
Simple microORM that maps the results of a query onto a POCO object. Project based on Schotime's branch of PetaPoco
Hello, I have two tables with a reference by two fields. I put the following attribute to my reference property: ``` [Reference(ReferenceType.OneToOne, ColumnName = "col1,col2", ReferenceMemberName = "col1,col2")] public Invoice...
Consider an example like this: ``` var res = await Database.Query() .IncludeMany(i => i.Labels) .ToPageAsync(1, 1); ``` This returns one Component (as it should) but it also returns only the...
With this optional configuration you can disable the the case sensitivity of PostgreSQL. Users have to ensure valid table, column, and alias names (e.g. without SQL keywords, white space, etc.)...
With NPoco 5.7.1, I used to be able do the following. (This is a dumbed-down example, the real query is more complex.) ```c# await db.ExecuteAsync(@"; select @created, @modified, @id", new...
We have started to migrate our repos to .NET10 and some of our projects rely on NPoco. As .NET10 comes with `System.Linq.Async` inbuilt it would preferably, if there existed a...
That does not depend on `System.Linq.Async` Needed to make type explicit in `QueryWithProjectionAndEnclosedMethod1`. Otherwise, we would get an `CS9226` as the new compiler would prefer another overload - see e.g....
For a while now we've been seeing occasional freezes in our ASP.NET Core 9 application in producation. First we suspected some deadlocking issue (see https://github.com/schotime/NPoco/issues/717 and https://github.com/schotime/NPoco/pull/716). However, that was...
Currently, Snapshot exposes Changes() and UpdatedColumns(), but there’s no direct way to check if any changes exist without calling Changes().Count > 0 or Changes().Any(). - This PR adds a convenience...