.NET 6 Web API with Entity Framework Core and SQL Server. Angular 13 CRUD App. Full stack.

preview_player
Показать описание
Build a full-stack CRUD app.
Back end: .NET 6, Entity Framework Core, SQL Server Express. Visual Studio 2022 Community Edition
Front end: Angular 13, Bootstrap 5. Visual Studio Code

GitHub

0:00:00 - Intro and project setup
0:02:50 - New ASP.NET Core Web API project
0:05:00 - Create Models
0:11:02 - Create Data Context
0:11:52 - Install dependencies
0:20:30 - Create database migration
0:24:45 - Add migration/update database
0:25:18 - Open SQL Server Management Studio
0:28:00 - Create Controllers
0:30:08 - Test API with Swagger
0:36:36 - Create Angular 13 App
0:39:35 - Add Bootstrap 5
0:40:54 - Create Components
0:42:17 - Create Service
0:45:07 - Add methods to API service
0:53:58 - Begin updating the Typescript files and html template files of the inspection components
1:01:00 - Create table to display inspections
1:12:26 - Create Map for inspection types
1:23:45 - Create form for updating and deleting inspections
1:44:20 - addInspection() method
1:51:33 - Add alerts and custom CSS
2:00:57 - updateInspection() method
2:14:16 - delete() method

Sharing data between child and parent components with @Input and @Output decorators (Angular 12)

Рекомендации по теме
Комментарии
Автор

People who share thier knowledge are like hero's who save universe...you are one such hero. Thank you very much.

dineshoduri
Автор

22:00 Use dotnet tool install --global dotnet-ef if you are getting error >> dotnet : Could not execute because the specified command or file was not found.

RAvinderNathan
Автор

Just Subscribed to your channel, Honestly, I do love your skills and how you type in your codes instead of copy and paste-like most tutors, that gives me time to think about what you are doing. Thank you for the video

timothyobidike
Автор

Hi James!. Great video, very clear and concise, thanks for posting it! I added a couple of modifications:
1) In the inspections controller, added the Include method, to show the type name right from the server:
// GET: api/Inspections
[HttpGet]
public async GetInspections()
{
return await
}
Then, in the show component: you ca use any of these options:
<td>{{
or
<td>{{ item.inspectionType.name }}</td>

In order to get this to work, it's necessary to add a line in
ngOnInit(): void {
...

this.inspectionType =
...
2) In the same order of ideas, did this to show the type when editing:
in
<input type="text" class="form-control" name="inspectionTypeId" <-- instead of inspectionTypeId
*ngIf="inspection.id!=0" disabled>

Thanks again for the inspiration!

mpadierna
Автор

Thank you for the lesson. I'm looking for good C# tutorials.
I've been working with Angular for over a year.
In Angular it is very bad to specify types as any.
But as for the introduction, the lesson is very well built.

AndrewYurchenko
Автор

great video tutorial. James is a very patient instructor who goes through everything. really learned a lot. thank you James

danielgoldin
Автор

Great video ! I'm really glad we've got people like you who share knowledge in such a good way ! Everything is explained when you're not a newbie. Good job. Looking forward for next video !

michaszura
Автор

congratulations! I haven't looked at a better and clearer coding process in a long time!!! 🥰 a thousand stars for this man! ⭐⭐⭐⭐⭐

nastasjabakovic
Автор

dotnet ef database update (result in an error in my case)

At 24:52 if someone has: "A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"


The solution is changing the ConnectionString adding TrustServerCertificate=Yes; at the end

lorenzovarese
Автор

I want to thank you with all my feelings, really really really thank you

saladenomilad
Автор

Followed through each second! Great tutorial! Thanks for this

DNCharLeys
Автор

very very useful, actually this is what i was looking for.

jeyaseelanjaandukondaan
Автор

Thanks for the video! Clear and Simple!

HiroonWijekoon
Автор

Great concise and to the point project. BTW @24:00 VS didn't do weird thing, James you forgot to build/ save the project .

usernotfound
Автор

At 22:00 the cmd line did not work, because you did benefit from autosave, which is triggered when you start the build within studio...

fgfgd
Автор

It feels like the last 40 minutes of the tutorial you just stopped really explaining what you're doing and started mostly reciting the code that you're writing. The whole forms part is very confusing how it ended up working

FishJokes
Автор

Thank you James! this is very helpful video with clear explanations, really learned a lot from this video. thank you very much again! keep it up!!!!

AddisInfo
Автор

This was very helpful and enjoyable. You are awesome. God bless you!

LeonardoJrUy
Автор

amazing tutorial, it came out exactly when I needed it!!

andreeacojo
Автор

Thanks for this updated tutorial wish you best luck

mohamedatia