Display Data from a Database in ASP.NET CORE (MVC) and C# | EF Code First | Visual Studio 2022

#AspNetCore #MVC #CodeWithGopi
Display Data from database | ASP .NET CORE (MVC) C# | Visual Studio 2022 | .Net 6.0

In this video explained how to read the data from SQL Server database in Asp Net Core MVC by using Entity Framework Code First approach. We have used Visual Studio 2022 with .Net 6.0 and SQL Server 2019.

Join this channel to get access to perks:

Required Packages:
Install-Package Microsoft.EntityFrameworkCore
Install-Package Microsoft.EntityFrameworkCore.SqlServer
Install-Package Microsoft.EntityFrameworkCore.Tools

For better understanding Please watch the video till the end.

Please subscribe to my channel

⌚ Timestamps

00:00 - Intro
00:30 – Demo
02:55 – Core-MVC Project Creation
04:07 – EF Packages/Bootstrap Installation
06:20 – Create Employee DB Entity Model
09:15 – Create EmployeeDbContext
10:27 – Add ConnectionString
12:02 – Add DI
12:02 – DB Migration
15:50 – Create Controller
20:46 – Create View
34:28 – Final Output

Playlists:

.Net Core :

MVC Examples :

Real Time Examples in Asp .Net :

Asp .Net Tutorial :

RDLC Reports :

SQL Server Tutorial for beginners :

Utilities:

Tags:
#crud #dotnet6 #dotnetcore #CodeFirst #CRUDINMVC #ADONet #aspnetcore #EntityFramework #CRUDINDOTNETCORE #CRUDOperations #WebapiwithEF
Asp net Mvc Full CRUD Operation Using Entity Framework DB First
CRUD Operations using Entity Framework Database-first Approach In ASP.Net MVC
ASP.Net MVC 5 Database First with Entity Framework 6
C# Asp.Net MVC CRUD Operations Using Entity Framework
EntityFramework Db First approach in .NET 5.0 MVC with CRUD operations
ASP.NET MVC CRUD Operations Using Entity Framework | ASP.NET MVC Create, Update, Delete Operations
CRUD operations in ASP.NET MVC5 using Entity Framework Code First and SQL Server database Tutorial
Asp net Mvc Full CRUD Operation Using Entity Framework DB First
Full CRUD operation using datatables in ASP.NET MVC
Asp.Net MVC CRUD Operations Using Datatable
Asp.Net MVC CRUD Without Entity Framework - Create,Update,Delete and View
Insert update delete in mvc using entity framework
Asp.Net MVC CRUD Operations Using Entity Framework
CRUD Operation In ASP.NET Core MVC Application From Scratch VS2019
Create First MVC CRUD Web Application using Visual Studio 2019
bootstrap alert with close button
fetch data with stored procedure
insert data with stored procedure
update data with stored procedure
delete data with stored procedure
crud operations with web api
crud operations with webapi entity framework
repository pattern
crud with repository pattern

[eclairron]

That was excellent! Easy to follow and very informative. It is helping me so much on my project, and I am looking forward to the rest of the videos on this as well. Thank you so much!

[atakanozdemir]

You are perfect, thank you. Your instructions are very clear and informative, this video helped me a great deal on my project.

[stephenzerfas]

I think Microsoft needs to hire you, I could not find this tutorial on their site. :-) Thank you.

[semperfo]

I really like your tutorial; very easy to understand and follow.

[manasabangre]

It worked for me !! Thanks a lot for such detailed video Sir. You have no idea what an help this tutorial has done. Your calm voice can be heard from morning till night. Teacher with great voice and simplicity in teaching has made this tutorial the best. I will watch each and every single video of yours and will gain best wisdom! thanks once again for your valuable time and effort. It means a lot for learners like us.

[emeryswanson]

Excellent training! Thank you! Well done.

[esbdigy]

I have learned a lot from your wonderful lectures. Thank you very much.
I am also looking forward to the course on implementing CURD using jQuery, DataTables with this project.
Thank you for your continued support.

[grant]

Great explanation. Nice and simple, thank you.

[legacy]

Could you please provide a video on how to implement page counter in mvc . Not pagination or number of visitor . I want to know how to calculate page counting in mvc .

[NaeemaAhmed-wmfr]

I am using My SQL (Xamp) for Database and downloaded the required packages as well but My Project is unable to load on the server side. It is not showing me the fields name .I followed the steps you've told except using SqlServer .Kindly tell me where am making mistake .TIA.

[Ravi-guww]

@codewithGopi, I followed your tutorial and here im getting data as UNdefined for some columns. the datatypes are same in sqldatabase and in public class. how can i mitigate this issue! Pls help me on this.

[mabeleain]

Pkg manager console not working in VS 2022 Mac version. How can I add migration?

[manasabangre]

Hi.. I am still getting the same error which you got after adding code in EmployeeController in Index method.
An unhandled exception occurred while processing the request.
InvalidOperationException: The model item passed into the ViewDataDictionary is of type 'System.Collections.Generic.List`1[TechKeeda.Models.DbEntities.Student]', but this ViewDataDictionary instance requires a model item of type Please help.

[dawidolino]

Hi, Im getting an error that multiple constructors cant be passed ( InvalidOperationException: Multiple constructors accepting all given argument types have been found in type There should only be one applicable constructor.) idk whats wrong since I was following your guide literally 1:1 except I have contacts instead of employees

[AlenMagar]

Hi there when adding update-database in the Package Manager Console it says: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 56 - Unable to load the SQLUserInstance.dll from the location specified in the registry. Verify that the Local Database Runtime feature of SQL Server Express is properly installed.) how do i fix this

[manimegalaiap-it]

I have tried this project..but i didnt get the output...only the "No Employees Available" displayed.... no data from database haven't displayed...

[sanchitkulkarni]

Getting error connection string property has not been initialized