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 wiki, however if you find something that is missing please let me know and I will endeavour to fix that.
There should be very limited breaking changes in 2.0, but if you have always just passed the connection string to the Database object then nothing will probably change. You can also specify the database type now, by passing ‘DatabaseType.SqlServer2012’ for example into the Database constructor. This will change the way the paging works in this case.
One of the latest features that has made it into 2.0 is the ability to use LINQ to specify simple where clauses, ordering and paging when fetching a single object. For example:
Database.FetchBy<User>(sql => sql.Where(x => x.Name == "Bob") .OrderBy(x => x.UserId) .Limit(10, 10))
There is also a FetchWhere<> which only takes a where expression.
Thanks again to all the contributors and if you have any issues be sure to raise them on github.