Blazor Server Database First Approach Entity Framework Core Tutorial

Asp.Net Blazor Server Database First Approach using Entity Framework core
Packages to add
Microsoft.EntityFrameworkCore
Microsoft.EntityFrameworkCore.SqlServer
Microsoft.EntityFrameworkCore.Tools
Scaffold-DbContext "Server=DbServerName;Database=DemoDB;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -force

[@qyounus]

I was precisely searching for this standard of Tutorial from 6 to 8 months. This is the best one which matches my requirement. I come from DB background. This tutorial really helps. There is no tutorial on RUclips which has Blazor+Web API +Business Layer+ EF DB first Approach. Most of them are Code First approach. Really Thanks.

[@CodingJackpot]

Glad it helped!

[@darklen14]

Which is like 99% of the time the case for a business. I am not sure why code first is the focus when it’s not realistic. Completely backwards in my experience.

[@nmarks]

I agree very much with Younus. This video is a real help.

[@Vimalkumar-gp7xt]

Perfect Design & descirption

[@CodingJackpot]

Thanks for the feedback ...also checkout the shopping cart project developed using the same approach
ruclips.net/p/PLWpvttYT5mY4Z_GJJULctGOFO-His_w1S

[@mrt7948]

thank you , this is so good. part two please crude operation, part 3 please authentication with token.

[@CodingJackpot]

Sure i will create a video for authentication with token

[@tokzhee]

Can we have just download the project... I love this

[@la-ki5wd]

Hi, thank you for this resource. What is the reason for unchecking "Configure for Https"?

[@khalifehamin]

well done. thanks

[@CodingJackpot]

Thanks for watching!

[@aakashgaur7661]

Very good tutorial

[@CodingJackpot]

Thanks for watching subscribe for more such videos

[@varnika5368]

Hi,
Is it necessary to create a API?
can I create the 3 projects as you created and is there a way to get access to models using the UI project?

[@CodingJackpot]

it is recommended to create different layers and good code maintaince and for better scalablity in future if the project grows and becomes large ERP .. you can add a reference to UI project of Models Project

[@ez3170]

Hi I have probleem when I publish application cannot Connect Sql server but when I run in VS2022 it works fine , van you help me please

[@CodingJackpot]

Where are you publishing the source code on azure ? Did you change the connection string to point to your server instead of local SQL instance ?

[@ez3170]

@@CodingJackpot My problem is in the mean time solved, probably a bug, but I had other question, I don't see the file startup any more, how can I make auto migrations ?

[@neenuvarghese8694]

Sir if i have more than one getfunction in api then how it will work.

[@CodingJackpot]

As per the project requirement any number of functions can be called .. not only get functions .. post delete ... all can be used .. you can refer our complete shopping cart project developed using the same approach ...
ruclips.net/video/JBXv3Vq4sLE/видео.html
Dont forget to subscribe for upcoming videos ..
Thanks

[@rvixay236]

I run this
Scaffold-DbContext "Server=DESKTOP-71FLHB7\SQLEXPRESS01;Database=DemoDB;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -force
then got this
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

[@munnamalaysia]

Hi @Coding Jackpot, This is a very favorable video. By the way
when I am fetching data then
getting null value below line on DataView.razor page
Data = await _frontEndService.GetProductDetails();
Any Advice plz.

[@CodingJackpot]

Try to put break point in the api method GetProductDetails and see whether data is getting returned or not