.NET 7 Beginner Course 🚀 Web API, Entity Framework 7 & SQL Server

Подписаться 63 тыс.

Просмотров 117 тыс.

50% 1

🚀 Join the .NET Web Academy: learn.dotnetwebacademy.com
💖 Support me on Patreon for exclusive source code access: / _patrickgod
🚀 Get the .NET 8 Web Dev Jump-Start Course for FREE: dotnet8.patrickgod.com
🐦 Let's get social on Twitter/X: / _patrickgod
🔗 Let's connect on LinkedIn: / patrickgod
🚀 .NET Jumpstart Course: www.udemy.com/course/net-core...
💻 GitHub: github.com/patrickgod/dotnet7...
Table of Contents:
00:00:00 .NET 7 Beginner Course 🚀 Web API, Entity Framework 7 & SQL Server
00:01:18 Tools (Visual Studio Code & .NET SDK)
00:02:48 Create a new Web API
00:11:34 First API Call
00:15:23 Git Repository & .gitignore File
00:19:07 Web API Introduction
00:19:42 The Model-View-Controller (MVC) Pattern
00:22:03 New Models
00:26:17 New Controller & GET a New Character
00:36:35 First Steps with Attribute Routing
00:40:52 Routing with Parameters
00:43:34 HTTP Request Methods Explained
00:46:48 Add a New Character with POST
00:50:23 Best Practice: Web API Structure
00:53:42 Character Service
01:02:38 Fix the “Possible ArgumentNullException”
01:04:43 Asynchronous Calls
01:08:53 Proper Service Response with Generics
01:17:06 Data-Transfer-Objects (DTOs)
01:22:58 AutoMapper
01:35:30 Modify a Character with PUT
01:47:40 Modify a Character with AutoMapper
01:49:12 Delete a Character
01:54:15 Web API Summary
01:55:01 Entity Framework 7 Introduction
01:55:50 Object-Relational-Mapping & Code-First Migration Explained
01:57:42 Installing Entity Framework 7
02:00:48 Installing SQL Server Express (with Management Studio)
02:02:04 Implementing the DataContext
02:05:37 ConnectionString & Adding the DbContext
02:10:29 First Migration
02:14:49 GET Implementations
#DotNet #WebAPI #PatrickGod

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 69

@yohanespradono5224 Год назад

wow thanks for this. really straight to the point where beginners need to know on building up a web api. even I ignored my udemy courses for this.

@dr_920 7 месяцев назад

Can't wait to share my experience with this course before finishing the EF. It is zero difficulties of following the tutorial. I also learned a lot from the API section. Thanks for the amazing course.

@heshamabdo6024 Год назад

It is very kind of you to share all this information for free with us , Thank You

@user-tc2wf6wy7m Год назад

Patrick, you are the only person who could explain Web API, EF Core and more to me. At the start of my career, you did more for me than any paid course. And you are also a very nice person, your "Hello Welcome" in English in .Net 6 video will stay with me forever (my first video). I go to your channel, as if visiting a friend with whom we are talking in the attic while the children are sleeping :)) You are the best of the best of the best :)

@PatrickGod Год назад

Hey there! Your message totally made my day! 🥰 So glad my videos have helped you, especially at the start of your career. I love that you feel like you're visiting a friend when coming to my channel. Thanks for the amazing compliment, and let's keep learning together! 😊 Catch you in the next video! 🎉 Cheers, Patrick

@user-bq3gr6mf9i 2 месяца назад

I think this video is fantastic! I've been wanting to learn .NET Core for a while, and this is the most suitable tutorial I've seen so far. It has been very helpful, and I really appreciate it. Thank you!

@brunoichbinfdp 6 месяцев назад

Great lesson , I have just bought the course on udemy, I am looking forward to learning more and more from it.

@Varkeyn Год назад

Waiting for full course with authorization with refresh tokens and angular! You are amazing! Thanks for your work!!!

@costandaniel6024 6 месяцев назад

Really great tutorial, learned a lot, finally understood backend api development, u rock, Keep up the good work. Cheers 😸😼

@nelsonrivers8546 7 месяцев назад

Thank you. As always your videos are much appreciated. Only issue was that cannot carry it through to production, because there is no security part that explains how to secure the web api with jwt token authentication. I don't want to sound like I don't appreciate it though. I'm thankful that instructors like you make the effort.

@mattmccredy3530 9 месяцев назад

Videos like this encourage me to continue challenging myself as I walk this career path. Your flow is inspiring! Subscribed immediately. Keep up the great work. 🙂

@PatrickGod 9 месяцев назад

Awesome! Thank you you so much! ❤

@10Totti Год назад

I bought this course a while ago and it's great thank you!

@codekhalipha7759 9 месяцев назад

Ctrl+D (multiple selection ) would save you a lot of time. Good tutorial 🤝

@NgocDucDo Месяц назад

Thank you very much for your videos.

@realcolormusic Год назад

This quality is the reason why I bought your Blazor course. I learned a lot with this video. Thank you very much.

@PatrickGod Год назад

Thank you so much! Really appreciate it!

@kritsana6170 11 месяцев назад

Thank you for Crash Course for beginner.

@facubazzi Год назад

this video saved my life

@jordansali9435 Год назад

Thank God for you have been a blessing not only to me but also to the people who are new to Blazor. You have been an inspiration to many. May i request Sir Patrick of teaching us the Blazor hybrid with access to sql server. Thank you so much for having you as our inspiration. Pls. keep up your good work because its very uplifting, encouraging for many to continue blazor coding. Salamat kaau (Thank you so much).

@remorcist2499 Год назад

Amen

@ehsanafzal185 Год назад

finally complete the whole tutorial

@MrLgbk Год назад

Amazing knowledge of tech and great teaching skills. Thanks

@PatrickGod Год назад

So nice of you! Thank you so much!

@dm-bn4nq Год назад

Thank you so much, can you make a video about clean architecture , please ?

@reikoleci4689 7 месяцев назад

Perfect

@pcdoctor4395 Год назад

Hi Patrick, Can You do a video where you do .NET, Web API, SQL Database and Entity Framework with N-Layer Architecture(BLL and DAL)? Kind regards

@blackscorpion4709 Год назад

First thank you for the course. A little hint to terminal/console push CTRL - L and cls is not necessary ;-)

@PatrickGod Год назад

You live and learn! Thank you! 😊

@skylycan007 Год назад

Hi Patrick! Do you have a course of how to consume an external Rest API? i would love this video, a content where you need to provide username, password and token in order to post authentication and get the JWT in response... with this JWT then consume a service POST to show results in a table. I'm learning with your videos a lot! thank you su much!

@aikidoshi007 Год назад

Hi there. The Course ends prematurely, half way through adding _context actions to the Service class

@diamondchanelofficial2194 Год назад

Hi. I saw your repo with a lot of updates such as JWT etc. that are not mentioned in this video. Can you, please, tell me if there are additional videos about this.

@andrii.h258 Год назад

what's diff between this video and previous videos about web api?

@AthelstanEngland 11 месяцев назад

Patrick could I ask what spec your development machine is. I realise I am running an old box i5-6400 CPU but it literally takes ten times as long on the build times compared to your demo.

@granitkuqi3338 Год назад

can you upload the full course in Pluralsight also?? plz

@lucasferreira8229 Год назад

26:15 At this moment, in line #16, where you wrote "Class", is that the name you declared?

@DonRyu-kh7gr Год назад

Where can I see the next lecuture?

@yonatangoldin Год назад

hey, im having some issues changing the methods in the character service to suit the db. i want to buy the course (maybe theres more detail or better support there) but i cant get it at discount. i can make a new udemy account but id like to have all my courses in one, could you help with this?

@julioo534 11 месяцев назад

I have one question. In my area is very demanding tecnoligies like Angular, C# and .NET. what version of .NET should i learn? Thanks fors answer

@miguelpayran9509 Год назад

Hi I would like see how you apply clean architecture instead MVC, You explain so good :3

@AhmedAymanM Год назад

They are completely parallel concepts, MVC is for project requests/responds, Clean is for project organization (files).

@de0o0 7 месяцев назад

I am wondering about that part: 1:28:32 . Why do you use select and then tolist methods, can't you just simply map whole list like _mapper.Map(characters); ?

@Weareisreal 7 месяцев назад

at 59:20 couldnt we have did that from the beginning? instead of deleting then adding in new code? it makes it hard to follow when using code then erasing it

@cubbucca Год назад

A God Amoung Men

@SlickVision 11 месяцев назад

Just started watching, but question. Why not just use Visual Studio? It's a lot easier to get up and running than adding plethora of extensions. Or am I wrong in that belief? Edit, this isn't a complaint or whine, curiously asking is all.

@WorstDeveloper Год назад

2:16:55 - Noob question, but why do you have to map and convert to a list when you already have "ToListAsync()" on the line above?

@AhmedAymanM Год назад

Async method for using await so you don't have the warning that "it lacks await operator". Then the whole line to read from DB, and then map them with AutoMapper (line is useless if you don't have automapper and use direct classes).

@abdulmussawir3132 Год назад

Bro Can you tell me how to get only Name by ID ?

@dantrrrrr Год назад

hi sir , i already building api with nodejs, i want to learn this course . I just wanna ask that if i need to know c sharp basic first or what should i know to start this course .Thanks

@PatrickGod Год назад

Hey there! Yes, knowing C# definitely helps here.

@WorstDeveloper Год назад

Why do we install: dotnet add package AutoMapper.Extensions.Microsoft.DependencyInjection --version 12.0.0 instead of: dotnet add package AutoMapper --version 12.0.0

@adelseaux Год назад

hello, at 1:03:00 , I don't understand why this fix, if it returns null, this should mean "not existing caracter". And why saying "Character?", the ? (nullable) is just for types no ? Or if we want an exception why can use First and not FirstOrDefault. Thank you =)

@reikooters Год назад

In older versions of C#, ? (nullable) was only for value types. Nullable reference types is a new feature (enabled by default, introduced in I think .Net 5). When enabled, if you say the function returns "Character" then it means that you promise that your function's returned value will never be null. The caller using this function knows it's safe to use the returned value without first checking if it is null. Returning "Character?" informs the caller of this function that the returned value could possibly be null, so they need to check for null before using the result. The compiler doesn't actually enforce that you don't return null in this case, it just gives you warnings about when a null COULD be returned - as shown in the video, because FirstOrDefault() could return null. The null forgiving operator (adding ! at the end) tells the compiler that you as the programmer know exactly what's going on and you guarantee that it will actually never be null, which suppresses the warning. This feature helps you write safer code (by warning you about code that could produce null reference exceptions) and can be disabled by right clicking on your project > Edit project file, change "enable" to disable. However, in this specific example, you're right - using First instead of FirstOrDefault could've achieved the same outcome as it also would have thrown an exception if the record didn't exist.

@WorstDeveloper Год назад

The "C# Esrensions" extension is no longer under development. Do you know of anther extension with similar functionality?

@alan- Год назад

I installed the one by "JosKreativ" and it works well

@l_y5398 Год назад

how to connect to database? 2:14:27

@SurennBhandari Год назад

First comment 😉

@GabrielGoncalves-ez1iv Год назад

Nice class!! I dont know why he was using VS code, but with ide as visual studio 2022 available, I think that vs code will give to much unecessary work for the developer, and even more for beginners.

@juliandavid333 Год назад

Hello, I followed all your example to the letter, but I have something strange when I try. "return context.Commerce.ToList();" I have an error "The ConnectionString property has not been initialized." I haven't been able to solve it, maybe you have an idea?

@FernandoRuiz-ps2yq 11 месяцев назад

Not very Beginner level. This assumes that you know some stuff. For instance, beginners will not know what is happening behind the scenes with automapper. you gave a description, but that is not enough. It will be best if you give an example or two about how it is manually done, then introduce automapper to assist with the manual work. You skipped other beginner explanations, such as builder.Services.AddAutoMapper(typeof(Program).Assembly). Why type of Program? and why Assembly. When describing something new, don't say, you do this and done. Explain why it is done. Always keep the WHY in mind when describing new concepts.

@PatrickGod 11 месяцев назад

Thanks a lot for your feedback. Appreciate that. I'll keep that in mind for future courses in tutorials. Cheers!

@crackrokmccaib 7 месяцев назад

Note to self: Start at 19:07

@AhmedAymanM Год назад

Is there any good discount ?

@gbmarshall Год назад

I have a large database with 190 tables... I've generated the entity framework model... how do I auto generate the web api from the entity framework model? I don't want to do it buy adding a controller for each table...

@AsakuraAvan 9 месяцев назад

why use VS Code, it adds so much more work unnecessarily

@PatrickGod Год назад

🚀 Get 20% off the .NET Web Academy: www.dotnetwebacademy.com/bundles/net-web-academy?coupon=dnwa2024yt

@user-tz9ov9lh8z Год назад

Too much restriction.... so confusing

@xoreeee Год назад

I get : Severity Code Description Project File Line Suppression State Error CS0246 The type or namespace name 'ServiceResponse' could not be found (are you missing a using directive or an assembly reference?) dotnet-rpg C:\Users\Adrian\Documents\dotnet-rpg\Services\CharacterService\ICharacterService.cs 12 Active why ?