-
Course
- Core Tech
Working with Data and Schemas in Marten 1
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!
What you'll learn
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 1, 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.
Table of contents
- Version Check | 20s
- 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 21s
About the author
With over 15 years experience, Jason Roberts is a Microsoft .NET MVP, freelance developer, and author.
More Courses by Jason