.NET Data Community Standup - Window and binary functions using Zomp EF Core extensions

From the creator

Window functions are one of the most powerful features of SQL. Did you know that you can use Window Functions in EF Core today instead of writing raw SQL? Victor Irzak joins Shay and Arthur to explore real use cases of window functions with EF Core. ⌚ Chapters: 00:00 Countdown 02:36 Welcome to the .NET Data Community Standup 03:16 State of the Unicorn 04:18 On Today's show 08:51 Window Functions - Intro 09:15 Data set 09:29 Demo: count 18:07 Demo: minimum so far 22:53 How to set up the extension 26:48 Demo 39:59 API Design 40:51 Functions and Providers supported 41:58 Windowing clause schema 43:35 Use restrictions 45:50 Row # window function 58:39 Expression tree modification 01:09:43 Closing remarks 01:11:35 Wrap https://github.com/zompinc/efcore-extensions Featuring: Victor Irzak, Arthur Vickers, Shay Rojansky #EFCore #DotNet #SQL

Published 2024-02-22 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.