Thursday, August 4th, 2011 #development
Sunday, July 31st, 2011 #petatest
In the spirit of PetaPoco, PetaTest is a tiny, embeddable, self-contained, dependency free unit testing framework for .NET and Mono.
PetaPoco now supports partial record updates where you can specify a subset of columns to update. What's more, the T4 template generated classes can now track and update just the columns that have been modified.
Friday, June 3rd, 2011 #petapoco
PetaPoco now supports Multi-Poco mapping where one row in a result set can be mapped onto two or more POCOs. But how do we handle one-to-many and many-to-one relationships?
PetaPoco v4 is almost ready. Here's a write up on what's new and changed.
Piehead recently blogged "Why startups could use .NET but don't". Since Showcase Lane is written in ASP.NET MVC I thought I'd share why I chose this route and and how it turned out in the end.
I've been testing Showcase Lane on a production server for about a week now and it's starting to build up some content. Here's some more screen shots.
PetaPoco now has experimental support for mapping result sets onto more than one POCO type, giving yet another way to handle SQL joins.
I've just pushed the first beta version of Showcase Lane. There's also some more information in the form of frequently asked questions.
Showcase Lane - a new site for web designers and developers - is getting very close.
PetaPoco version 3 is now available incorporating lots of minor changes - one of which is not backwards compatible requiring clocking the major version number.
PetaPoco now supports queries on single column scalar values - eg:
db.Query<long>(...). And some minor bug fixes.
PetaPoco - Support for non-identity primary keys, T4 template schema tweaking, improved stored proc support and SQL Server geometry types.
PetaPoco 2.1 is now available in Nuget including support for dynamics, columns with spaces, ansi strings and a few other bits and pieces.
Tuesday, April 19th, 2011 #petapoco
PetaPoco's main focus is obviously to work with POCO objects. Sometimes though you just want to run query and not have to worry about declaring an object for results. C#'s 4.0's new dynamic support is perfect for this.
PetaPoco now has support for Oracle (including sequences), simpler primary key versions of SingleOrDefault, some new SQL builder bits, support for enum property types and more...
Showcase Lane has been progressing fabulously. Still not ready to talk too much about it, but here's another sneek peek.
Today I received an email asking how to do SQL joins with PetaPoco. Since this is not entirely obvious and there's a couple of ways of doing it I thought I'd write it up...
I've been getting some great feedback on PetaPoco, all very positive. There's also been some great suggestions including these little tweaks...
Thursday, April 7th, 2011 #petapoco
Today I updated PetaPoco to support PostgreSQL database, tweaked some implementation details to yield better query plan caching and added the ability to query page or records without querying the total record count.