Introduction

One of the great components of ServiceStack is OrmLite. In this chapter, we will cover some of the functionality OrmLite provides while using practical patterns to keep your code clean and maintainable. OrmLite is a lightweight object-relational mapping framework that focuses on simplicity and performance. We will look at how you can use OrmLite in your application along with some of the common syntax to make queries, including the use of stored procedures and strongly typed SQL expressions. We will also show you how your database can be modeled with POCOs and its attributes, and use OrmLite T4 templates to quickly prototype against an existing database.