Working with Data and Schemas in Marten
Pluralsight
Course Summary
Marten is an open source library for .NET that enables the use of an underlying PostgreSQL database as a document database. Learn how to work with data and schemas in it!
-
+
Course Description
Marten can be used as a replacement or alternative to other document databases such as MongoDb or RavenDb and can also be an alternative to ORMs such as Entity Framework. While Marten is easy to get started with, it also provides an array of customization, diagnostic, data manipulation, and performance related features that can be additionally employed. In this course, Working with Data and Schemas in Marten, you'll learn how to improve query performance, diagnose and log SQL statements, implement offline optimistic concurrency, and customize PostgreSQL schema objects. First, you'll discover how to log and diagnose SQL queries and DDL commands generated by Marten. Next, you'll learn how to prevent data loss with offline optimistic concurrency and how to soft-delete documents. Then, you'll move on to learning how to reduce database round trips, improve PostgreSQL query performance, and how to reduce client CPU costs. Finally, you'll discover how to take control over the PostgreSQL schema objects that Marten defines and creates. By the end of this course, you'll have a better understanding of how to work with data and schemas in Marten.
-
+
Course Syllabus
Course Overview- 1m 11s
—Course Overview 1m 11sLogging and Diagnosing SQL Commands and Schema Changes- 34m 38s
—Introduction 3m 29s
—Overview of Marten Logging 3m 56s
—Creating a Custom Session Logger 9m 56s
—Creating a Custom Marten Logger 4m 40s
—Refactoring to a Single Logger Class 2m 37s
—Using the Pre-supplied Logger 1m 19s
—Previewing LINQ Generated SQL 2m 45s
—Diagnosing PostgreSQL Query Plan Performance 2m 1s
—Tracking the Number of Issued Session Commands 2m 30s
—Summary 1m 21sModifying Document Data- 28m 7sImproving Query Performance- 33m 2sCustomizing Database Schema Objects- 18m 41s