Category Archives: .NET

Html Conventions in ASP.net MVC

Just today, Jimmy wrote a great post on using HTML conventions in ASP.net MVC using FubuMvc’s core HTML conventions. Go ahead a read it. I’ll wait here. The problem with this is that it heavily relies on StructureMap (FWIW I … Continue reading

Posted in .NET | Tagged , , , | 2 Comments

NPoco 2.0

Today I finally published NPoco 2.0. It has been 6 months in the making and 13 pre-release versions. Thankyou to all who have raised bugs and used it in anger. Most of the documentation has been published to the github … Continue reading

Posted in .NET | Tagged , | 7 Comments

NPoco, PostgreSQL and DateTimeOffset

Setting up PostgreSQL to run with NPoco is very simple. Firstly you need to install the Npgsql driver from NuGet. From the Package Manager Console type: Install-Package Npgsql Once this has been installed, we need to make a change to … Continue reading

Posted in .NET | Tagged , , , | Leave a comment

NPoco and MiniProfiler

Now that you have NPoco installed, being able to see exactly what queries were run and how they performed can make a huge difference in the overall performance of your site. MiniProfiler is an awesome project by Sam Saffron that … Continue reading

Posted in .NET | Tagged , , | Leave a comment

Introducing NPoco

NPoco is the new library from my PetaPoco branch. If you don’t know what PetaPoco is, it is a MicroORM that enables quick and fast database access using raw sql. Why did I create this library? Well there was becoming … Continue reading

Posted in .NET | Tagged | 3 Comments

PetaPoco – Convention Based Fluent Mapping

After using the Fluent Mapping’s I blogged about a few months ago, I started to see patterns occurring. My table names were always the pluralized type and the primary key was the Type name concatenated with “Id”. With all this … Continue reading

Posted in .NET | Tagged , , , | 3 Comments

PetaPoco – Multiple Result Sets

The other day I got enough time to put the ability to fetch multiple result sets into PetaPoco. Its relatively simple to use and works like this. Given these two classes with corresponding tables: public class Table1 { public string … Continue reading

Posted in .NET | Tagged , | 1 Comment