.NET 6 Web API 🚀 EF Core Pagination (Entity Framework Core 6 & SQL Server)

Table of Contents:
00:00:00 Intro
00:02:09 Solution Overview
00:04:09 Add an API Controller
00:08:27 Add a Response DTO
00:09:19 Implement Pagination
00:16:51 Outro

🙏MANY THANKS TO THESE LOVELY PEOPLE:
Thomas Werner
István Csibor
Grant Burdon
@gianluigiconti
Gerrit Esmeijer
Illia
Németh-Pók István
Michael Mel
Marko Zdilar
GerryB
@DADA_universe
Domen Hren
@heroesch
Carey
Peter De Tender
Baris Keskin
Someone
@Big_Bear_27390
Mathias
walter e watkins
Günther Dassel
Axel
Josh
Daniel Huber
Fredric Adell
Juan Carlos
Manolis
Pajani
P.
Jonas Granlund
Someone
Bobby
Kristina
@xamarin007

#DotNet #WebAPI #PatrickGod

[BrokenSword]

Patrick I want to thank you for being a vital member of the blazor community. Thank you so so much for your help in learning these topics. They make me a super star at work.

[hermannrosch]

Well structured and clearly explained Patrick. You deserve another coffee.

[rentozoid]

Nice thank you man, please keep up the great work!!!

[kamajo]

Hi Patrick, thanks for your video. It helped me!

[kjellberstad]

Nice and clear. Can you make a video about errorhandling? Especially handling an exception from the api in a blazor wa app.

[billxenakis]

Thx for the video ... One little question :
ActionResult type is a List of Products but you return a ProductResponse Dto which includes a list of Products. Why it works ?

[LuigiZambetti]

Why don't you make a playlist also for C# 10 Patrick? Starting from beginner level until advanced.

[pxp]

Great explaining and calm and clear voice.

I like the Video and Sound. Can you share which products you use regarding video and microphone?

[hammadarshad]

please make video on clean architecture using solid principle and cqrs patterns in .net core web api

[tamilselvanpanneerselvam]

Patrik could you please make a video about sorting and searching in EF

[SuperHesni]

thank you so much for the tutorials i wish i could buy you a coffe but my stupid country doesnt have global banks, some people are going to write exactly what you wrote, so it would be alot better if you teach them better, for example you need to make a class for pagination and just pass the parameters to that method in the class so they wont repeat the codes, can you please make a video about message brokers such as redis and etc, and in memory databases, and signal R 😁 your the best teacher i ever had <3

[brotindash]

Thanks for the video explanation. One thing to note is database is being hit twice, wont it slow down the application? Also how fast will this be when record count will be huge, say over 1M ?

skip / take makes the app very slow when the database is too large

[alexpermenev]

I’m looking for the answer long time: “how can I load full next page without duplicates if new data is inserted to previous pages in the database?”
Nothing, nothing… No one can do this. I thought that I could create new table in the database when first page is requested and load data just from this database view but this solution would take memory a lot… HOW? Please, tell me how?(
Another my thought was to send loaded ids from front to back to ignore these, but the request would have been expanding every next page…

[dfytq]

This is very inefficient because suppose you have a very complex query that will be required to execute twice which will reduce the performance a lot.