.NET Micro ORMs

Pluralsight

Course Summary

.NET Micro ORMs will introduce you to what a Micro ORM is and will demonstrate the details of five different .NET Micro ORMs.

+
Course Description

Do you want a data ORM that is simple and lightweight but also is powerful and provides incredible performance? If so, a Micro ORM is for you! This course will provide background for what a Micro ORM is and why you might want to use one. It will then dive into specific details of five .NET Micro ORMs: Dapper, OrmLite, Massive, PetaPoco, and Simple.Data. This demo-heavy course will show the simple elegance of Micro ORMs while providing performance faster than any other "full" ORM available today.

Course Description

Do you want a data ORM that is simple and lightweight but also is powerful and provides incredible performance? If so, a Micro ORM is for you! This course will provide background for what a Micro ORM is and why you might want to use one. It will then dive into specific details of five .NET Micro ORMs: Dapper, OrmLite, Massive, PetaPoco, and Simple.Data. This demo-heavy course will show the simple elegance of Micro ORMs while providing performance faster than any other "full" ORM available today.

+
Course Syllabus

Introduction
- 22m 36s

—Introduction 1m 13s
—What is A Micro ORM? 5m 55s
—Counter Arguments 2m 55s
—Your First Dapper Query 4m 3s
—Your First OrmLite Query 2m 3s
—Your First PetaPoco Query 1m 36s
—Your First Massive Query 2m 22s
—Your First Simple.Data Query 1m 43s
—Summary 0m 43s

Dapper
- 57m 6s

—Introduction 1m 31s
—Key Features 1m 5s
—Database Setup 2m 13s
—Installing Dapper 2m 33s
—First Repository and Test 7m 40s
—Basic List Query 2m 42s
—Inserting Data 2m 57s
—Retrieving a Single Item 2m 5s
—Updating Data 2m 17s
—Deleting Data 1m 23s
—CRUD with Complex Objects 11m 1s
—Stored Procedures 1m 42s
—Dynamic Parameters 5m 45s
—Putting a UI on Top 4m 27s
—Bulk Insert 2m 38s
—List Support 1m 57s
—Dynamic Capabilities 2m 34s
—Summary 0m 30s

OrmLite
- 51m 5s

—Introduction 2m 5s
—Key Features 1m 12s
—Installing OrmLite 1m 4s
—Basic List Query 7m 35s
—Inserting Data 3m 34s
—Retrieving A Single Item 4m 38s
—Updating Data 4m 15s
—Deleting Data 2m 5s
—CRUD with Complex Objects with Explicit Children 6m 14s
—Creating and Dropping Tables 5m 28s
—CRUD with Complex Objects with Blobbed Children 5m 30s
—Stored Procedures 1m 42s
—SELECT Expression Support 5m 7s
—Summary 0m 28s

Massive
- 34m 50s

—Introduction 2m 0s
—Key Features 1m 11s
—Installing Massive 1m 47s
—Basic List Query with DynamicModel 8m 47s
—Inserting Data 1m 57s
—Retrieving A Single Item 3m 51s
—Updating Data 1m 22s
—Deleting Data 1m 4s
—Paging 2m 1s
—Named Arguments 2m 44s
—Aggregates with Named Arguments 2m 36s
—Metadata 1m 26s
—Validations 1m 34s
—Callbacks 2m 0s
—Summary 0m 23s

PetaPoco
- 41m 51s

—Introduction 1m 55s
—Key Features 1m 24s
—Installing PetaPoco 1m 22s
—Basic List Query 6m 32s
—Inserting Data 2m 59s
—Retrieving A Single Item 2m 43s
—Updating Data 1m 58s
—Deleting Data 1m 53s
—Using T4 Templates 3m 23s
—CRUD with Complex Objects 6m 38s
—Paging 2m 44s
—SQLBuilder 4m 54s
—SQL Command Tracking 2m 45s
—Summary 0m 34s

Simple.Data
- 40m 52s

—Introduction 2m 9s
—Key Features 1m 29s
—Be Blown Away By Simple.Data.Pad 9m 51s
—Installing Simple.Data 1m 4s
—Basic List Query 4m 8s
—Inserting Data 1m 28s
—Retrieving A Single Item 2m 1s
—Updating Data 1m 49s
—Deleting Data 1m 10s
—Moving From Dynamic to Static 5m 46s
—Column Selection 3m 15s
—Aggregates: Count 1m 23s
—Getting Distinct Data 1m 43s
—Joins 2m 29s
—Summary 1m 0s