ستتعلم في هذا الفيديو إجراء معاملات مع قاعدة بيانات SQL Server باستخدام Entity Framework لإجراء عمليات الإنشاء والقراءة والتحديث والحذف والترتيب والبحث، سنستخدم Visual Studio 2022 و .NET 6 في هذا الفيديو.
نتمنى ان تستمتعوا بهذا الفيديو ولا تنسى الاشتراك بالقناة اضغط اعجاب اذا اعجبك الفيديو وشارك الفيديو مع اصدقائك
يعني ايه البرمجة الشيئية Object-Oriented Programming
/watch/QnVjy8ZNv4SNj
▬▬▬▬▬▬ T I M E S T A M P S ▬▬▬▬▬▬
00:00:00 - What we are going to build
00:01:22 - Prerequisite (Tools and Technologies)
00:03:34 - Create Application Using Visual Studio 2022
00:05:20 - Installing Packages
00:06:41 - Building Department Model
00:12:12 - Building Employee Model
00:22:08 - Creating Context Class
00:25:51 - Connection String
00:28:05 - Add Migration and Update Database
00:30:41 - Check SQL Server Database Using Management Studio
00:32:30 - Create Employee Controller
00:36:26 - Create Index View For Employee Controller
00:38:08 - Changing Default Route in Program.cs
00:39:03 - Retrieving Data From SQL Database (@model)
00:40:52 - Populate Database
00:43:33 - Viewing Data From View
00:45:55 - Building Index View (All Employees Page)
00:55:18 - Adding Item in Menu (Bootstrap Navbar in _Layout)
00:58:44 - Building Add New Employee View
01:19:30 - Adding Validation to Our Application
01:20:38 - Create ActionResult and Save To SQL Database Using Entity Framework
01:25:42 - Inspecting ModelState
01:28:49 - Building Edit ActionResult To Save in SQL Database
01:31:12 - Display Department Name in Index View (All Employees)
01:36:18 - Applying Delete Command
01:37:54 - Display Delete Confirmation Before Deleting Using JavaScript
01:39:43 - Extracting GetEmployees Method
01:40:16 - Building SortEmployees Method
01:47:22 - Adjusting Index ActionResult to Provide New Sorting Parameters
01:50:18 - Adding Sort Functionality in All Employees View
01:54:40 - Adding SortDirection Enumeration and Adjusting SortEmployees Method
01:57:25 - Build Search By Name Functionality
02:03:48 - Epilogue
كورس سي شارب للمبتدئين
/playlist/PLX1bW_GeBRhCU9l7examhVrARmXHHRrLR
▬▬▬▬▬▬ Important Videos? ▬▬▬▬▬▬
HTTPPost and HTTPGet Attributes ► /watch/EU0yMxxvI_Gvy
ASP.NET Core مقدمة في تعلم ► /playlist/PLX1bW_GeBRhAjpkPCTpKXJoFGe2ZpYGUC
Scaffolding CRUD Operations in ASP.NET Core MVC | Entity Framework | Database First Approach | شرح
/watch/gmFsfNlY6idYs
▬▬▬▬▬▬ Subscribe NOW! ▬▬▬▬▬▬
https://cutt.ly/5jib8Fd
▬▬▬▬▬▬ Terms and Abbreviations ▬▬▬▬▬▬
CRUD = Create - Read - Update - Delete
▬▬▬▬▬▬ Resources ▬▬▬▬▬▬
Visual Studio 2022 Community Edition
https://visualstudio.microsoft.com/vs/community/
Visual Studio Code Download
https://code.visualstudio.com/download
SQL Server
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
SQL Server Management Studio (SSMS)
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
▬▬▬▬▬▬ Our Social Media Platforms ▬▬▬▬▬▬
Facebook ► https://www.facebook.com/codographia/
Facebook Group ► https://www.facebook.com/groups/codographia
Instagram ► https://www.instagram.com/codographia/
SkillShare ► https://www.skillshare.com/r/user/ahmadmohey
Buy Me Coffee ► https://www.buymeacoffee.com/codographia