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