O/R mappers such as Entity Framework or NHibernate have contributed enormously in recent years to simplifying data access in .NET applications for developers. A little Linq is all it takes for data to “fly” from the database into the objects in the source code. But what looks good in the source code makes the database administrator shudder as soon as he takes a look at the automatically generated SQL statement. All too easily, errors creep in that lead to poor-performing SQL statements. And all that just to pack data into objects. In this session, you will learn that there is another way. By using so-called micro ORMs, such as PetaPoco, you can fire highly optimized SQL statements at your database and automatically pack the results into POCO classes. Of course, you also lose some of the features of the “big” ORMs. In this presentation, I will show you which ones these are and whether you really need them.

This talk is also listed on andrekraemer.de.

All talks