Custom EFCore Migrations, Table-Valued Parameters, and Raw SQL Queries
Recording of my lectures at HTL Leonding 2021/22. You can find the course material on GitHub at https://github.com/rstropek/htl-leo-p....
This week, we dive deeper into various aspects of Entity Framework Core. In the third hour, we implement a more advanced search API using raw SQL with Common Table Expressions and Table-Valued Parameters. The sample referenced in the video can be found at https://github.com/rstropek/htl-leo-p....
00:00:00 Intro
00:00:17 Understanding the search query (incl. TVPs, CTEs)
00:15:26 Custom EFCore Migrations for Custom SQL Type
00:25:39 Calling raw SQL with TVP
00:31:01 Wrapping up