02_07A Entity Framework episode 01 to 03

02_07A Entity Framework episode 01 to 03

  
【 Entity Framework第1篇: 基礎入門Code First V.S. DB First 】 Entity Framework episode 1 - Code First V.S. DB First 課程編號: e588db74-5b90-43db-9e1d-434f224acb01 主要講解 EF DB First 和 EF Code First 模式下的 Mapping 開發模式。
並帶您在 DB First 和 Code First 不同的視角下重構同一功能。 此講義目錄Table of Content: https://ithandyguytutorial.blogspot.com/p/entityframework-foundation.html Tutorial 1 ~ 26
此YouTube PlayList: https://www.youtube.com/playlist?list=PLXstZ12GxF9wNrfopLBXFyo_nJIent9IX&disable_polymer=true
-------------------------------------------------------
Pre-Requirement
TSQL
C#
Linq
MVC
======================================

  
【 Entity Framework第2篇: 扎實打底Fluent API V.S. Data Annotation 】
Entity Framework episode 2 - Fluent API V.S. Data Annotation 課程編號: 4956c5dc-482e-434a-a17b-421930000656 了解 Code First 模式下 Migration 開發模式,
熟悉 Code First 底下的 Data Annotations V.S. Fluent API 的差異和比較。
並初步了解 AutoMapper,為下一階段做準備。
此講義目錄Table of Content:  https://ithandyguytutorial.blogspot.com/p/entityframework-foundation.html
Tutorial 27 ~ 35
此YouTube PlayList:   https://www.youtube.com/playlist?list=PLXstZ12GxF9zHKwCIer6s_4jDf4VywNiI&disable_polymer=true
-------------------------------------------------------
Pre-Requirement
TSQL
C#
Linq
MVC
Entity Framework episode 1 - Code First V.S. DB First
Entity Framework第1篇: 基礎入門Code First V.S. DB First
======================================

  
【 Entity Framework第3篇: 熟能生巧Unit of work with Repository 】
Entity Framework episode 3: Unit of work with Repository
課程編號: 97374070-cc70-461e-8b07-f97e4a211b27
初步了解 Code First 和 DB First開發模式下的Unit Of Work搭配Repository和AutoMapper。
此講義目錄Table of Content:  https://ithandyguytutorial.blogspot.com/p/entityframework-foundation.html
Tutorial 36 ~ 39
此YouTube PlayList:   https://www.youtube.com/playlist?list=PLXstZ12GxF9xp9HNVP7s4CcYjnfG7pgVb&disable_polymer=true
-------------------------------------------------------
Pre-Requirement
TSQL
C#
Linq
MVC
Entity Framework episode 1 - Code First V.S. DB First
Entity Framework第1篇: 基礎入門Code First V.S. DB First
Entity Framework episode 2 - Fluent API V.S. Data Annotation
Entity Framework第2篇: 扎實打底Fluent API V.S. Data Annotation
======================================
#IT工具人折價眷官網  http://ithandyguytutorial.obior.cc/
#IT工具人講義部落格  https://ithandyguytutorial.blogspot.com.au
#IT工具人Youtube頻道   https://www.youtube.com/user/lpmplpmp/playlists
#IT工具人課程課後輔導討論版  https://www.facebook.com/groups/934567793358849/
#IT工具人臉書頁  https://www.facebook.com/Ithandyguytutorial-2353578301334227/
如果喜歡我的課程,以下都是鼓勵我繼續寫課程的動力唷。
1. 請訂閱我的Youtube頻道追蹤我的最新消息。私人影片的部分為付費影片,如欲購買,請來「IT工具人折價眷官網」 2. 請「盡量」用 「IT工具人折價眷官網」提供的折價眷,來購買我的課程唷,讓我可以分潤多一點點。 3. 購買課程並且上完課後,如果覺得不錯,請不吝留下您的好評價。
======================================

.NET Framework學習之路.

此為.NET Framework學程中的其中一門課。

Tools

Tools installation and settings instruction.
Please read the following
-->
T000_001_InstallSQLServer2016
T000_003_Install Visual Studio 2017 Offline
T000_004_Install_Postman_Fiddler
T000_005_EnforceDeleteDatabase
T000_007_PocoGenerator_SampleCode
T000_008_NUnit

EF series Preview

EFseries_Preview01
EFseries_Preview01_EF學程簡介

EFseries_Preview02_EntityFrameworkDevelopment
EFseries_Preview02_EntityFramework開發

07B_EFepisode5And6_SampleIntroductionByPoco
07B_EF第5和6篇_Poco範例成品介紹

本篇程導讀

Intro : Entity Framework episode 1 - Code First V.S. DB First
導讀 : Entity Framework第1篇: 基礎入門Code First V.S. DB First

Intro : Entity Framework episode 2 - Fluent API V.S. Data Annotation
導讀 : Entity Framework第2篇: 扎實打底Fluent API V.S. Data Annotation

Intro : Entity Framework episode 3: Unit of work with Repository
導讀 : Entity Framework第3篇: 熟能生巧Unit of work with Repository

Intro : Entity Framework episode 4: POCO generator
導讀 : Entity Framework第4篇: 加速開發POCO generator

Intro : Entity Framework episode 5: Test Unit of work with Repository Part1
導讀 : Entity Framework第5篇: 技術整合Part 1, Test Unit of work with Repository Part1

Intro : Entity Framework episode 6: Test Unit of work with Repository Part2
導讀 : Entity Framework第6篇: 技術整合Part 2, Test Unit of work with Repository Part2

Entity Framework episode 1 - Code First V.S. DB First
Entity Framework第1篇: 基礎入門Code First V.S. DB First


Revise Entity Framework in my MVC Course
複習本學程的MVC課程裡的完全手寫Entity Framework連接資料庫


T001_MVC_Revise
----------------------
Tutorial 01講義: 複習MVC, IIS介紹
Tutorial 01: 複習MVC, IIS介紹


T002_MVC_Revise_EntityFramework
----------------------
Tutorial 02講義: 複習MVC, 關於EntityFramework
Tutorial 02: 複習MVC, 關於EntityFramework


Database First/Code First Entity Framework
Database First和Code First的Entity Framework,完全手寫完全理解EF然後自動生成秒殺EF

T003_EF_DataBaseFirst_2Tables_DoubleGridView
----------------------
Tutorial 03講義: 實作Database First自動生成秒殺EF,實作雙層GridView
Tutorial 03-01: 實作Database First自動生成秒殺EF,實作雙層GridView
Tutorial 03-02: 實作Database First自動生成秒殺EF,實作雙層GridView


T004_EF_CodeFirst_2Tables
----------------------
Tutorial 04講義: 實作Code First Entity Framework
Tutorial 04: 實作Code First Entity Framework



----------------------
Tutorial 05講義: 完全手寫Entity Framework,實作雙層GridView



T006_EF_CodeFirst_UpdateDatabaseModel_Table_Column_ForeignKeyAttribute
----------------------
Tutorial 06講義: 徹底理解Table、Column、ForeignKey Attribute,完全手寫EF code first,完全攻略更新資料庫。新增Seeder原始資料
Tutorial 06-01: 徹底理解Table、Column、ForeignKey Attribute,完全手寫EF code first
Tutorial 06-02: 完全手寫EF code first,完全攻略更新資料庫
Tutorial 06-03: 新增Seeder原始資料



T007_EF_DBFirst_StoredProcedure_UpdateDatabase
----------------------
Tutorial 07講義: 徹底理解EF DBFirst底下建立Stored Procedure並且變更資料庫結構
Tutorial 07-01: 徹底理解EF DBFirst底下建立Stored Procedure
Tutorial 07-02: 徹底理解EF DB Fist底下變更資料庫結構



T008_EF_CodeFirst_StoredProcedure
----------------------
Tutorial 08講義: 徹底理解EF Code First底下建立Stored Procedure
Tutorial 08: 徹底理解EF Code First底下建立Stored Procedure



EF Code/DB First Mapping, 1 Entity Map to 2 Tables, 2 Entities Map to 1 Table, ConditionalMapping
完整攻略EF Code/DB First裡的1 Entiy對應到2Tabls。完整解析2 Entities對應到1Table。徹底了解ConditionalMapping


T009_EFDBFist_1EntityMap2Tables
----------------------
Tutorial 09講義: 徹底理解EF DB First底下建立1 Entity Map to 2 Tables
Tutorial 09: 徹底理解EF DB First底下建立1 Entity Map to 2 Tables



T010_EFCodeFist_1EntityMap2Tables
----------------------
Tutorial 10講義: 徹底理解EF Code First底下建立1 Entity Map to 2 Tables
Tutorial 10: 徹底理解EF Code First底下建立1 Entity Map to 2 Tables



T011_EFDBFist_2EntitiesMapTo1Table
----------------------
Tutorial 11講義: 徹底理解EF DB First底下建立2 Entities Map to 1 Table
Tutorial 11: 徹底理解EF DB First底下建立2 Entities Map to 1 Table



T012_EFCodeFist_2EntitiesMapTo1Table
----------------------
Tutorial 12講義: 徹底理解EF Code First底下建立2 Entities Map to 1 Table
Tutorial 12: 徹底理解EF Code First底下建立2 Entities Map to 1 Table



T013_EFDBFirst_ConditionalMapping
----------------------
Tutorial 13講義: 徹底理解EF DB First底下建立Conditional Mapping
Tutorial 13: 徹底理解EF DB First底下建立Conditional Mapping



T014_EFCodeFirst_ConditionalMapping
----------------------
Tutorial 14講義: 徹底理解EF Code First底下建立Conditional Mapping
Tutorial 14: 徹底理解EF Code First底下建立Conditional Mapping



EF Code/DB First Self referencing association
完整攻略EF Code/DB First裡的Self referencing association



T015_EFDBFirst_SelfReferencingAssociation
----------------------
Tutorial 15講義: 徹底理解EF DB First底下建立Self Referencing Association
Tutorial 15: 徹底理解EF DB First底下建立Self Referencing Association



T016_EFCodeFirst_SelfReferencingAssociation
----------------------
Tutorial 16講義: 徹底理解EF Code First底下建立Self Referencing Association
Tutorial 16: 徹底理解EF Code First底下建立Self Referencing Association


EF Code/DB First TablePerHierarchy(TPH)/TablePerType(TPT) Inheritance with Stored Procedure
完整攻略EF Code/DB First裡的TablePerHierarchy(TPH)/TablePerType(TPT) Inheritance搭配Stored Procedure


----------------------
Tutorial 17講義: 徹底理解EF DB First底下建立Table Per Hierarchy(TPH) Inheritance
Tutorial 17-01: 徹底理解EF DB First底下建立Table Per Hierarchy(TPH) Inheritance, Index View
Tutorial 17-02: 徹底理解EF DB First底下建立Table Per Hierarchy(TPH) Inheritance, WarriorsIndex, MagicianIndex
Tutorial 17-03: 徹底理解EF DB First底下建立Table Per Hierarchy(TPH) Inheritance, CreateWarrior, CreateMagician
Tutorial 17-04: 徹底理解EF DB First底下建立Table Per Hierarchy(TPH) Inheritance, EditWarrior, EditMagician
Tutorial 17-05: 徹底理解EF DB First底下建立Table Per Hierarchy(TPH) Inheritance, Details, Delete



----------------------
Tutorial 18講義: 徹底理解EF Code First底下建立Table Per Hierarchy(TPH) Inheritance
Tutorial 18-01: 徹底理解EF Code First底下建立Table Per Hierarchy(TPH) Inheritance, Index View, WarriorsIndex, MagicianIndex
Tutorial 18-02: 徹底理解EF Code First底下建立Table Per Hierarchy(TPH) Inheritance, CreateWarrior, CreateMagician, EditWarrior, EditMagician
Tutorial 18-03: 徹底理解EF Code First底下建立Table Per Hierarchy(TPH) Inheritance, Details, Delete



----------------------
Tutorial 19講義: 徹底理解EF DB  First底下建立Table Per Type (TPT) Inheritance搭配Stored Procedure
Tutorial 19-01: 徹底理解EF DB First底下建立Table Per Type (TPT) Inheritance搭配Stored Procedure, Index View, WarriorsIndex, MagicianIndex
Tutorial 19-02: 徹底理解EF DB First底下建立Table Per Type (TPT) Inheritance搭配Stored Procedure, CreateWarrior, CreateMagician, EditWarrior, EditMagician
Tutorial 19-03: 徹底理解EF DB First底下建立Table Per Type (TPT) Inheritance搭配Stored Procedure, Details, Delete



----------------------
Tutorial 20講義: 徹底理解EF Code First底下建立Table Per Type (TPT) Inheritance搭配Stored Procedure
Tutorial 20-01: 徹底理解EF Code First底下建立Table Per Type (TPT) Inheritance搭配Stored Procedure, Index View, WarriorsIndex, MagicianIndex
Tutorial 20-02: 徹底理解EF Code First底下建立Table Per Type (TPT) Inheritance搭配Stored Procedure, CreateWarrior, CreateMagician, EditWarrior, EditMagician
Tutorial 20-03: 徹底理解EF Code First底下建立Table Per Type (TPT) Inheritance搭配Stored Procedure, Details, Delete


EF Code/DB First Many to Many with/without Bridge Table, using Stored Procedure
完整攻略EF Code/DB First裡的Many to Many with/without Bridge Table更新新增移除,搭配Stored Procedure

T021_EFDBFirst_ManyToMany_StoredProcedure
----------------------
Tutorial 21講義: 徹底理解EF DB First底下實作Many to Many新增移除更新,搭配Stored Procedure
Tutorial 21-01: 徹底理解EF DB First底下實作Many to Many新增移除更新,StoredProcedure
Tutorial 21-02: 徹底理解EF DB First底下實作Many to Many新增移除更新,GamerSkillsIndex.cshtml, Gamer Index, Skill Index
Tutorial 21-03: 徹底理解EF DB First底下實作Many to Many新增移除更新,AssignSkillToGamerIndex.cshtml



T022_EFCodeFirst_ManyToMany_StoredProcedure
----------------------
Tutorial 22講義: 徹底理解EF Code First底下實作Many to Many新增移除更新,搭配Stored Procedure
Tutorial 22-01: 徹底理解EF Code First底下實作Many to Many新增移除更新,StoredProcedure, Gamer Index, Skill Index
Tutorial 22-02: 徹底理解EF Code First底下實作Many to Many新增移除更新,GamerSkillsIndex.cshtml, AssignSkillToGamerIndex.cshtml



T023_EFDBFirst_ManyToManyWithBridgeTable_StoredProcedure
----------------------
Tutorial 23講義: 徹底理解EF DB First底下實作Many to Many With Bridge Table新增移除更新,搭配Stored Procedure
Tutorial 23-01-01: 徹底理解EF DB First底下實作Many to Many With Bridge Table新增移除更新,StoredProcedure, GamerSkillsIndex.cshtml, Gamer Index, Skill Index
Tutorial 23-01-02: 徹底理解EF DB First底下實作Many to Many With Bridge Table新增移除更新,StoredProcedure, GamerSkillsIndex.cshtml, Gamer Index, Skill Index
Tutorial 23-02: 徹底理解EF DB First底下實作Many to Many With Bridge Table新增移除更新,AssignSkillToGamerIndex.cshtml



T024_EFCodeFirst_ManyToManyWithBridgeTable_StoredProcedure
----------------------
Tutorial 24講義: 徹底理解EF Code First底下實作Many to Many With Bridge Table新增移除更新
Tutorial 24-01: 徹底理解EF Code First底下實作Many to Many With Bridge Table新增移除更新,GamerSkillsIndex.cshtml, Gamer Index, Skill Index
Tutorial 24-02: 徹底理解EF Code First底下實作Many to Many With Bridge Table新增移除更新,AssignSkillToGamerIndex.cshtml


EF Code First Migration by command script

使用command script實現EF Code First Migration


T025_EFMigrationByCommandScriptOfPackageManagerConsole
----------------------
Tutorial 25講義: 使用Command Script實現EF Migration
Tutorial 25: 使用Command Script實現EF Migration


More about EF DB First
深入解析EF DB First



T026_01_WhatToDo
T026_02_TSql_EF
T026_03_edmx
T026_04_DatabaseChanges_AddTable
T026_05_DatabaseChanges_UpdateTable_AddColumn
T026_06_DatabaseChanges_UpdateTable_UpdateColumn
T026_07_DatabaseChanges_UpdateTable_DeleteColumn
T026_08_DatabaseChanges_DeleteTable
T026_09_StoredProcedure_Function
T026_10_EFModelEnum
T026_11_MoveEFModelTTFileToOtherFolder
T026_12_DeleteEF_ReCreateEFModel
--------------------------
T026_13_EFDBFirst_ManyToManyCRUD_StoredProcedure_SkillIndex_GamerIndex_GamerSkillIndex_AssignSkillToGamerIndex
T026_13_01_EFDBFirst_ManyToManyCRUD_StoredProcedure_SkillIndex
T026_13_02_EFDBFirst_ManyToManyCRUD_StoredProcedure_GamerIndex
T026_13_03_EFDBFirst_ManyToManyCRUD_StoredProcedure_GamerSkillIndex
T026_13_04_EFDBFirst_ManyToManyCRUD_StoredProcedure_AssignSkillToGamerIndex
T026_13_05_EFDBFirst_ManyToManyCRUD_StoredProcedure_AssignAndUnassignSkillToGamer
--------------------------------------------------------------------
Tutorial 26講義: 深入了解DBFirst,徹底理解EF DB First底下實作Many to Many With Bridge Table新增移除更新,搭配Stored Procedure
Tutorial 26-01: 範例成品展示
Tutorial 26-02: 前置準備
Tutorial 26-03: 深入理解edmx
Tutorial 26-04: 資料庫更改,新增Table
Tutorial 26-05: 資料庫更改,更改Table,新增Column
Tutorial 26-06: 資料庫更改,更改Table,更改Column
Tutorial 26-07: 資料庫更改,更改Table,刪除Column
Tutorial 26-08: 資料庫更改,刪除Table
Tutorial 26-09: 使用Stored Procedure和Function
Tutorial 26-10: 關於EF Model Enum
Tutorial 26-11: 把EF Model TT File移動倒其他資料夾
Tutorial 26-12: 把整個DBFirst的EF Models刪除。重新開始製作DBFirst EF Models。
--------------------------
Tutorial 26-13: 徹底理解EF DB First底下實作Many to Many With Bridge Table的CRUD,StoredProcedure, Skill Index, Gamer Index, GamerSkillsIndex.cshtml,AssignSkillToGamerIndex
Tutorial 26-13-01: 徹底理解EF DB First底下實作Many to Many With Bridge Table的CRUD,StoredProcedure, Skill Index
Tutorial 26-13-02:: 徹底理解EF DB First底下實作Many to Many With Bridge Table的CRUD,StoredProcedure, Gamer Index
Tutorial 26-13-03: 徹底理解EF DB First底下實作Many to Many With Bridge Table的CRUD,StoredProcedure, GamerSkillsIndex.cshtml
Tutorial 26-13-04: 徹底理解EF DB First底下實作Many to Many With Bridge Table的CRUD,AssignSkillToGamerIndex
Tutorial 26-13-05: 徹底理解EF DB First底下實作Many to Many With Bridge Table的CRUD,AssignAndUnassignSkillToGamer


Entity Framework episode 2 - Fluent API V.S. Data Annotation
Entity Framework第2篇: 扎實打底Fluent API V.S. Data Annotation


EF Code First Migration,Many to Many, One to Many
使用EF Code First Migration實現多對多、一對多


T027_EFCodeFirstMigration_ManytoMany_OneToMany
----------------------
Tutorial 27講義: 了解EF Code First Migration,實現一對多,多對多。
Tutorial 27-01: 成品展示,建立EFModels
Tutorial 27-02: 使用EF Migration Script

EF Code First Migration With ExistingDB
使用現有DB和Migration產生EF Code First,實現對DB的Souce Control。DB也可以有version,並且可以upgrade或downgrade。



T028_01_TSQL
T028_02_EFCodeFirstMigrationWithExistingDB
T028_03_AddMigrationInit
T028_04_AddMigration_AddClassTable
T028_05_AddMigration_EditClassTable_AddPropertyColumn
T028_06_AddMigration_EditClassTable_EditPropertyColumn
T028_07_AddMigration_EditClassTable_DeletePropertyColumn
T028_08_AddMigration_DeleteClass
T028_09_Migration_upgradeDB_DowngradeDB
T028_10_Migration_SeedDB
----------------------
Tutorial 28講義: 使用現有DB和Migration產生EF Code First,實現對DB的Souce Control。DB也可以有version,並且可以upgrade或downgrade。
Tutorial 28-01: 成品展示,執行TSQL
Tutorial 28-02: 把Existing DB使用EF Code First Migration轉成EF models
Tutorial 28-03: 加入第一個EF Code First Migration。init migration
Tutorial 28-04: 使用EF Code First Migration,Add EF Model Class/table。
Tutorial 28-05: 使用EF Code First Migration,Edit EF Model Class/table,Add property/column。
Tutorial 28-06: 使用EF Code First Migration,Edit EF Model Class/table,Edit property/column。
Tutorial 28-07: 使用EF Code First Migration,Edit EF Model Class/table,Delete property/column。
Tutorial 28-08: 刪除一個EF Model Class,使用EF Code First Migration。
Tutorial 28-09: 使用EF Code First Migration來upgrade DB和downgrade DB
Tutorial 28-10: 使用EF Code First Migration來Seed DB



Overriding EF Code First Conventions - Data Annotations V.S. Fluent API
實作Overriding Code-First Conventions。Data Annotations V.S  Fluent API



T029_01_Introduction_DataAnnotations_FluentApi
T029_02_DataAnnotations_SingleTable
T029_03_DataAnnotations_OneToMany1
T029_04_DataAnnotations_OneToMany2
T029_05_DataAnnotations_OneToMany3
T029_06_DataAnnotations_OneToMany4
T029_07_DataAnnotations_ManyToMany
----------------------
Tutorial 29講義: 使用Data Annotations 來 Overriding Code-First Conventions
Tutorial 29: 使用Data Annotations 來 Overriding Code-First Conventions
Tutorial 29-01: 初步認識Data Annotations V.S Fluent API
Tutorial 29-02: Data Annotations實作Single Table
Tutorial 29-03: Data Annotations實作One To Many Relationship 1
Tutorial 29-04: Data Annotations實作One To Many Relationship 2
Tutorial 29-05: Data Annotations實作One To Many Relationship 3
Tutorial 29-06: Data Annotations實作One To Many Relationship 4
Tutorial 29-07: Data Annotations實作Many To Many Relationship



T030_01_MigrationInit
T030_02_DataAnnotations_AdminMemberTable
T030_03_FluentAPI_AdminMemberTable
T030_04_DataAnnotations_OneToOneManyRelationship_AdminMemberTable_AdminMemberGroupTable
T030_05_FluentAPI_OneToOneManyRelationship_AdminMemberTable_AdminMemberGroupTable
T030_06_DataAnnotations_OneToZeroManyRelationship_AdminMemberTable_AdminMemberAreaTable
T030_07_FluentAPI_OneToZeroManyRelationship_AdminMemberTable_AdminMemberAreaTable
T030_08_FluentAPI_OneToOneRelationship_GamerTable_GamerDetailTable
T030_09_DataAnnotations_OneToZeroOneRelationship_GamerTable_GamerExtraInformationTable
T030_10_FluentAPI_OneToZeroOneRelationship_GamerTable_GamerExtraInformationTable
T030_11_DataAnnotations_ManyToManyRelationship_WithoutMiddleEFModel_GamerTable_MagicTable
T030_12_FluentAPI_ManyToManyRelationship_WithoutMiddleEFModel_GamerTable_MagicTable
T030_13_DataAnnotations_ManyToManyRelationship_WithMiddleEFModel_GamerTable_SkillTable
T030_14_FluentAPI_ManyToManyRelationship_WithMiddleEFModel_GamerTable_SkillTable
T030_15_OrganizingFluentApiEntityConfiguration
----------------------
Tutorial 30講義: DataAnnotatios和FluentAPI的差異比較。
Tutorial 30-01: 初步實作Migration Init
Tutorial 30-02: 使用Data Annotations在AdminMember
Tutorial 30-03: 使用FluentAPI在AdminMember
Tutorial 30-04: One-to-One/Many-Relationship,使用DataAnnotations在AdminMemberTable和AdminMemberGroupTable
Tutorial 30-05: One-to-One/Many-Relationship,使用FluentAPI在AdminMemberTable和AdminMemberGroupTable
Tutorial 30-06: One-to-Zero/Many-Relationship,使用DataAnnotations在AdminMemberTable和AdminMemberAreaTable
Tutorial 30-07: One-to-Zero/Many-Relationship,使用FluentAPI在AdminMemberTable和AdminMemberAreaTable
Tutorial 30-08: One-to-One-Relationship,使用FluentAPI在GamerTable和GamerDetailTable
Tutorial 30-09: One-to-Zero/One-Relationship,使用DataAnnotations在GamerTable和GamerExtraInformationTable
Tutorial 30-10: One-to-Zero/One-Relationship,使用FluentAPI在GamerTable和GamerExtraInformationTable
Tutorial 30-11: Many-to-Many-Relationship Without Middle EF Model,使用DataAnnotations在GamerTable和MagicTable
Tutorial 30-12: Many-to-Many-Relationship Without Middle EF Model,使用FluentAPI在GamerTable和MagicTable
Tutorial 30-13: Many-to-Many-Relationship With Middle EF Model,使用DataAnnotations在GamerTable和SkillTable
Tutorial 30-14: Many-to-Many-Relationship With Middle EF Model,使用FluentAPI在GamerTable和SkillTable
Tutorial 30-15: 整理規劃Fluent API Entity Configuration


TablePerHierarchy(TPH)/TablePerType(TPT)/TablePerConcrete(TPC), Data Annotations V.S. Fluent API
深入理解TablePerHierarchy(TPH)/TablePerType(TPT)/TablePerConcrete(TPC),比較Data Annotations V.S. Fluent API



T031_01_Preparation
T031_02_DataAnnotation_TablePerHierarchyInheritance_TPH
T031_03_MVC_Index_WarriorsIndex_MagicianIndex
T031_04_MVC_EditWarrior_EditMagician
T031_05_MVC_CreateWarrior_CreateMagician
T031_06_MVC_Delete
T031_07_MVC_Details
T031_08_DataAnnotation_TablePerHierarchyInheritance_TPH_OverrideDiscriminatorColumn
T031_09_FluentAPI_TablePerHierarchyInheritance_TPH
T031_10_FluentAPI_TablePerHierarchyInheritance_TPH_OverrideDiscriminatorColumn
T031_11_FluentAPI_TablePerHierarchyInheritance_TPH_OverrideDiscriminatorColumn2
T031_12_EFModelMustNotIncludeDiscriminatorProperty
T031_13_OrganizingFluentAPI
--------------------------------------------------------
Tutorial 31: TablePerHierarchyInheritance_TPH_DataAnnotationVSFluentAPI
Tutorial 31講義: 徹底理解Table Per Hierarchy Inheritance(TPH),比較Data Annotation V.S. Fluent API
Tutorial 31-01: 前置準備
Tutorial 31-02: 使用Data Annotation實現Table Per Hierarchy Inheritance(TPH)
Tutorial 31-03: 實作MVC,實作Index,WarriorsIndex和MagicianIndex
Tutorial 31-04: 實作MVC,實作EditWarrior和EditMagician
Tutorial 31-05: 實作MVC,實作CreateWarrior和CreateMagician
Tutorial 31-06: 實作MVC,實作Delete
Tutorial 31-07: 實作MVC,實作Details
Tutorial 31-08: 使用Data Annotation實作Table Per Hierarchy Inheritance(TPH)並且Override Discriminator Column
Tutorial 31-09: 使用Fluent API實現Table Per Hierarchy Inheritance(TPH)
Tutorial 31-10: 使用Fluent API實作Table Per Hierarchy Inheritance(TPH)並且Override Discriminator Column
Tutorial 31-11: 使用Fluent API實作Table Per Hierarchy Inheritance(TPH)並且Override Discriminator Column2
Tutorial 31-12: 證明EF Model不可以包含Discriminator Property
Tutorial 31-13: 整理Fluent API
--------------------------------------------------------
Please Revise
A_EF01to03課程的
T018_EFCodeFirst_TablePerHierarchyInheritance_TPH
----------------------
T020_EFCodeFirst_TablePerTypeInheritance_TPT_StoredProcedure




T032_01_Preparation
T032_02_DataAnnotation_TablePerTypeInheritance_TPT
T032_03_MVC_Index_WarriorsIndex_MagicianIndex
T032_04_MVC_EditWarrior_EditMagician
T032_05_MVC_CreateWarrior_CreateMagician
T032_06_MVC_Delete
T032_07_MVC_Details
T032_08_FluentAPI_TablePerTypeInheritance_TPT
T032_09_OrganizingFluentAPI
--------------------------------------------------------
Tutorial 32講義: 徹底理解Table Per Type Inheritance(TPT),比較Data Annotation V.S. Fluent API
Tutorial 32-01: 前置準備
Tutorial 32-02: 使用Data Annotation實現Table Per Type Inheritance(TPT)
Tutorial 32-03: 實作MVC,實作Index,WarriorsIndex和MagicianIndex
Tutorial 32-04: 實作MVC,實作EditWarrior和EditMagician
Tutorial 32-05: 實作MVC,實作CreateWarrior和CreateMagician
Tutorial 32-06: 實作MVC,實作Delete
Tutorial 32-07: 實作MVC,實作Details
Tutorial 32-08: 使用Fluent API實現Table Per Type Inheritance(TPT)
Tutorial 32-09: 整理Fluent API
--------------------------------------------------------
Please Revise
A_EF01to03課程的
T018_EFCodeFirst_TablePerHierarchyInheritance_TPH
----------------------
T020_EFCodeFirst_TablePerTypeInheritance_TPT_StoredProcedure



T033_01_Preparation
T033_02_TablePerConcreteTypeInheritance_TPC_FluentAPI
T033_03_OrganizingFluentAPI
----------------------
Tutorial 33講義: 徹底理解使用Fluent API完成Table Per Concrete Type Inheritance (TPC)
Tutorial 33-01: 前置準備
Tutorial 33-02: 使用Fluent API實現Table Per Concrete Type Inheritance (TPC)
Tutorial 33-03: 整理Fluent API
--------------------------------------------------------
Please Revise
A_EF01to03課程的
T018_EFCodeFirst_TablePerHierarchyInheritance_TPH
----------------------
T020_EFCodeFirst_TablePerTypeInheritance_TPT_StoredProcedure


SqlQuery_StoredProcedure
硬幹SqlQuery搭配StoredProcedure



T034_01_Preparation
T034_02_EFMigrationInit
T034_03_MVC
T034_04_SqlQuery_StoredProcedure
----------------------
T034_SqlQuery_StoredProcedure
Tutorial 34講義: 硬幹SqlQuery搭配StoredProcedure
Tutorial 34-01: 前置準備
Tutorial 34-02: EF Migration Init
Tutorial 34-03: 自動生成MVC
Tutorial 34-04: 硬幹SqlQuery搭配StoredProcedure



AutoMapper
使用AutoMapper



T035_AutoMapper
Tutorial 35: 介紹AutoMapper
T035_01_AutoMapper_Person_Member
T035_02_AutoMapper_Person_Gamer
T035_03_AutoMapper_PersonList_MemberList
T035_04_AutoMapper_PersonList_GamerList
----------------------
Tutorial 35講義: 理解AutoMapper
Tutorial 35-01: 介紹AutoMapper,Person和Member
Tutorial 35-02: 介紹AutoMapper,Person和Gamer
Tutorial 35-03: 介紹AutoMapper,PersonList和MemberList
Tutorial 35-04: 介紹AutoMapper,PersonList和GamerList



Entity Framework episode 3: Unit of work with Repository
Entity Framework第3篇: 熟能生巧Unit of work with Repository

Repository_UnitOfWork_AutoMapper
使用Repository Layer搭配Unit of work和AutoMapper


T036_CodeFirst_Repository_UnitOfWork_AutoMapper_MockUpData_MSTest
Tutorial 36講義: CodeFirst底下的Repository搭配UnitOfWork和AutoMapper。在Database建立前先透過MockUpData來建立MVC。EFRepository搭配MSTest。
T036_01_Concept  (想直接實作的人可以跳過)
T036_02_CreateProjects
----------------------
EF Models and DbContext
T036_03_EFModel
T036_04_FFModel_EntityConfiguration
T036_05_DbCContext
----------------------
EFModelRepository_EFModelUnitOfWork
T036_06_EFModelRepositoryInterface_EFModelUnitOfWorkInterface
T036_07_EFModelRepository_EFModelUnitOfWork_Admin
T036_08_EFModelRepository_EFModelUnitOfWork_Gamer
T036_09_EFModelRepository_EFModelUnitOfWork_UIConsoleApp
----------------------
ViewModels
T036_10_viewModels
----------------------
EFAndViewModelRepository_EFAndViewModelUnitOfWork
T036_11_EfAndViewModelRepositoryInterface_EfAndViewModelUnitOfWorkInterface
T036_12_EfAndViewModelRepository_EfAndViewModelUnitOfWork_Admin
T036_13_EfAndViewModelRepository_EfAndViewModelUnitOfWork_Gamer
T036_14_EfAndViewModelRepository_EfAndViewModelUnitOfWork_ConsoleApp
----------------------
ViewModelRepository_ViewModelUnitOfWork
T036_15_ViewModelRepositoryInterface_ViewModelUnitOfWorkInterface
T036_16_ViewModelRepository_ViewModelUnitOfWork_Admin
T036_17_ViewModelRepository_ViewModelUnitOfWork_Gamer
T036_18_ViewModelRepository_ViewModelUnitOfWork_GamerSkill
T036_19_ViewModelRepository_ViewModelUnitOfWork_UIConsoleApp
----------------------
MVC
T036_20_MVC_Admin
T036_21_MVC_Skill
T036_22_MVC_Gamer
----------------------
MockUpData
T036_23_MVC_MockUpData
----------------------
MSTest
T036_24_Data_MSTest
------------------------------------------------------------------
T036_CodeFirst_Repository_UnitOfWork_AutoMapper_MockUpData_MSTest
Tutorial 36講義: CodeFirst底下的Repository搭配UnitOfWork和AutoMapper。在Database建立前先透過MockUpData來建立MVC。EFRepository搭配MSTest。
Tutorial 36-01: 觀念簡介 (想直接實作的人可以跳過)
Tutorial 36-01-01: 觀念簡介
Tutorial 36-01-02: 觀念簡介
----------------------
Tutorial 36-02: 前置作業
----------------------
EF Models 和 DbContext
Tutorial 36-03: 實作Entity Framework Model
Tutorial 36-04: 實作Entity Framework Model搭配Entity Configuration
Tutorial 36-05: 實作DbContext
----------------------
EFModelRepository 和 EFModelUnitOfWork
Tutorial 36-06: 實作Entity Framework Repository Interface 和 Entity Framework UnitOfWork Interface
Tutorial 36-06-01: 實作Entity Framework Repository Interface 和 Entity Framework UnitOfWork Interface
Tutorial 36-06-02: 實作Entity Framework Repository Interface 和 Entity Framework UnitOfWork Interface
Tutorial 36-07: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - AdminMember
Tutorial 36-07-01: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - AdminMember
Tutorial 36-07-02: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - AdminMember
Tutorial 36-07-03: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - AdminMember
Tutorial 36-08: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - Gamer
Tutorial 36-08-01: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - Gamer
Tutorial 36-08-02: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - Gamer
Tutorial 36-09: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - UIConsoleApp
Tutorial 36-09-01: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - UIConsoleApp
Tutorial 36-09-02: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - UIConsoleApp
Tutorial 36-09-03: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - UIConsoleApp
----------------------
ViewModels
Tutorial 36-10: 實作View Models
----------------------
EFAndViewModelRepository 和 EFAndViewModelUnitOfWork
Tutorial 36-11: 實作EfAndViewModel Repository Interface 和 EfAndViewModel UnitOfWork Interface
Tutorial 36-11-01: 實作EfAndViewModel Repository Interface 和 EfAndViewModel UnitOfWork Interface
Tutorial 36-11-02: 實作EfAndViewModel Repository Interface 和 EfAndViewModel UnitOfWork Interface
Tutorial 36-12: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - AdminMember
Tutorial 36-12-01: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - AdminMember
Tutorial 36-12-02: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - AdminMember
Tutorial 36-13: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - Gamer
Tutorial 36-13-01: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - Gamer
Tutorial 36-13-02: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - Gamer
Tutorial 36-13-03: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - Gamer
Tutorial 36-14: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - UIConsoleApp
Tutorial 36-14-01: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - UIConsoleApp
Tutorial 36-14-02: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - UIConsoleApp
Tutorial 36-14-03: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - UIConsoleApp
Tutorial 36-14-04: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - UIConsoleApp
----------------------
ViewModelRepository 和 ViewModelUnitOfWork
Tutorial 36-15: 實作View Model Repository Interface 和 View Model UnitOfWork Interface
Tutorial 36-15-01: 實作View Model Repository Interface 和 View Model UnitOfWork Interface
Tutorial 36-15-02: 實作View Model Repository Interface 和 View Model UnitOfWork Interface
Tutorial 36-16: 實作View Model Repository 和 View Model UnitOfWork - AdminMember
Tutorial 36-16-01: 實作View Model Repository 和 View Model UnitOfWork - AdminMember
Tutorial 36-16-02: 實作View Model Repository 和 View Model UnitOfWork - AdminMember
Tutorial 36-17: 實作View Model Repository 和 View Model UnitOfWork - Gamer
Tutorial 36-17-01: 實作View Model Repository 和 View Model UnitOfWork - Gamer
Tutorial 36-17-02: 實作View Model Repository 和 View Model UnitOfWork - Gamer
Tutorial 36-18: 實作View Model Repository 和 View Model UnitOfWork - GamerSkill
Tutorial 36-19: 實作View Model Repository 和 View Model UnitOfWork - UI Console App
Tutorial 36-19-01: 實作View Model Repository 和 View Model UnitOfWork - UI Console App
Tutorial 36-19-02: 實作View Model Repository 和 View Model UnitOfWork - UI Console App
Tutorial 36-19-03: 實作View Model Repository 和 View Model UnitOfWork - UI Console App
Tutorial 36-19-04: 實作View Model Repository 和 View Model UnitOfWork - UI Console App
Tutorial 36-19-05: 實作View Model Repository 和 View Model UnitOfWork - UI Console App
Tutorial 36-19-06: 實作View Model Repository 和 View Model UnitOfWork - UI Console App
Tutorial 36-19-07: 實作View Model Repository 和 View Model UnitOfWork - UI Console App
----------------------
MVC
Tutorial 36-20: 實作MVC - AdminMember
Tutorial 36-20-01: 實作MVC - AdminMember
Tutorial 36-20-02: 實作MVC - AdminMember
Tutorial 36-20-03: 實作MVC - AdminMember
Tutorial 36-21: 實作MVC - Skill
Tutorial 36-22: 實作MVC - Gamer
Tutorial 36-22-01: 實作MVC - Gamer
Tutorial 36-22-02: 實作MVC - Gamer
----------------------
MockUpData
Tutorial 36-23: 在Database建立前先透過MockUpData來建立MVC
Tutorial 36-23-01: 在Database建立前先透過MockUpData來建立MVC
Tutorial 36-23-02: 在Database建立前先透過MockUpData來建立MVC
----------------------
MSTest
Tutorial 36-24:  實作MS Test 測試 Entity Framework Repository 和 Entity Framework UnitOfWork
------------------------------------------------------------------
Please Revise
A_EF01to03課程的
T024_EFCodeFirst_ManyToManyWithBridgeTable_StoredProcedure
Tutorial 24講義: 徹底理解EF Code First底下實作Many to Many With Bridge Table新增移除更新
----------------------
T030_DataAnnotationVSFluentAPI
Tutorial 30講義: DataAnnotatios和FluentAPI的差異比較。
------------------------------------------------------------------
Please Revise
Linq課程的
T010_AsEnumerableAndAsQueryable_LinqToSQL
Tutorial10講義: 完整比較AsEnumerable()和AsQueryable()。又見Linq to SQL




DB First Repository_UnitOfWork_AutoMapper
DB First使用Repository Layer搭配Unit of work和AutoMapper




T037_DBFirst_Repository_UnitOfWork_AutoMapper_MockUpData_MSTest
Tutorial 37講義: DBFirst底下的Repository搭配UnitOfWork和AutoMapper。
T037_01_Concept
T037_02_CreateProjects
T037_03_EFModel
T037_04_UIConsoleApp
T037_05_EFModelRepositoryInterface_EFModelUnitOfWorkInterface
T037_06_EFModelRepository_EFModelUnitOfWork_Admin
T037_07_EFModelRepository_EFModelUnitOfWork_Gamer
T037_08_EFModelRepository_EFModelUnitOfWork_UIConsoleApp
T037_09_viewModels
T037_10_EfAndViewModelRepositoryInterface_EfAndViewModelUnitOfWorkInterface
T037_11_EfAndViewModelRepository_EfAndViewModelUnitOfWork_Admin
T037_12_EfAndViewModelRepository_EfAndViewModelUnitOfWork_Gamer
T037_13_EfAndViewModelRepository_EfAndViewModelUnitOfWork_UIConsoleApp
T037_14_ViewModelRepositoryInterface_ViewModelUnitOfWorkInterface
T037_15_ViewModelRepository_ViewModelUnitOfWork_Admin
T037_16_ViewModelRepository_ViewModelUnitOfWork_Gamer
T037_17_ViewModelRepository_ViewModelUnitOfWork_GamerSkill
T037_18_ViewModelRepository_ViewModelUnitOfWork_UIConsoleApp
T037_19_MVC_Admin
T037_20_MVC_Skill
T037_21_MVC_MockUpData
T037_22_Data_MSTest
--------------------------------------------------------
T037_DBFirst_Repository_UnitOfWork_AutoMapper_MockUpData_MSTest
Tutorial 37講義: DBFirst底下的Repository搭配UnitOfWork和AutoMapper。
Tutorial 37-01: 觀念簡介 (想直接實作的人可以跳過)
Tutorial 37-02: 前置作業
EF Models 和 DbContext
Tutorial 37-03: 實作Entity Framework Model
Tutorial 37-04: 使用Entity Framework Model - UIConsoleApp
EFModelRepository 和 EFModelUnitOfWork
Tutorial 37-05: 實作Entity Framework Repository Interface 和 Entity Framework UnitOfWork Interface
Tutorial 37-06: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - AdminMember
Tutorial 37-07: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - Gamer
Tutorial 37-08: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - UIConsoleApp
Tutorial 37-08-01: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - UIConsoleApp
Tutorial 37-08-02: 實作Entity Framework Repository 和 Entity Framework UnitOfWork - UIConsoleApp
ViewModels
Tutorial 37-09: 實作View Models
EFAndViewModelRepository 和 EFAndViewModelUnitOfWork
Tutorial 37-10: 實作EfAndViewModel Repository Interface 和 EfAndViewModel UnitOfWork Interface
Tutorial 37-11: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - AdminMember
Tutorial 37-12: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - Gamer
Tutorial 37-13: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - UIConsoleApp
Tutorial 37-13-01: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - UIConsoleApp
Tutorial 37-13-02: 實作EfAndViewModel Repository 和 EfAndViewModel UnitOfWork - UIConsoleApp
ViewModelRepository 和 ViewModelUnitOfWork
Tutorial 37-14: 實作View Model Repository Interface 和 View Model UnitOfWork Interface
Tutorial 37-15: 實作View Model Repository 和 View Model UnitOfWork - AdminMember
Tutorial 37-16: 實作View Model Repository 和 View Model UnitOfWork - Gamer
Tutorial 37-17: 實作View Model Repository 和 View Model UnitOfWork - GamerSkill
Tutorial 37-18: 實作View Model Repository 和 View Model UnitOfWork - UI Console App
Tutorial 37-18-01: 實作View Model Repository 和 View Model UnitOfWork - UI Console App
Tutorial 37-18-02: 實作View Model Repository 和 View Model UnitOfWork - UI Console App
MVC
Tutorial 37-19: 實作MVC - AdminMember
Tutorial 37-20: 實作MVC - Skill
MockUpData
Tutorial 37-21: 在Database建立前先透過MockUpData來建立MVC
MSTest
Tutorial 37-22:  實作MS Test 測試 Entity Framework Repository 和 Entity Framework UnitOfWork
------------------------------------------------------------------
Please Revise
A_EF01to03課程的
T024_EFCodeFirst_ManyToManyWithBridgeTable_StoredProcedure
Tutorial 24講義: 徹底理解EF Code First底下實作Many to Many With Bridge Table新增移除更新
----------------------
T030_DataAnnotationVSFluentAPI
Tutorial 30講義: DataAnnotatios和FluentAPI的差異比較。
------------------------------------------------------------------
Please Revise
Linq課程的
T010_AsEnumerableAndAsQueryable_LinqToSQL
Tutorial10講義: 完整比較AsEnumerable()和AsQueryable()。又見Linq to SQL




Code First Stored Procedure


T038_CodeFirstStoredProcedure
----------------------
Tutorial 38講義: 關於Code First的Stored Procedure
Tutorial 38: 關於Code First的Stored Procedure




T039_AutomatedMigration
----------------------
Tutorial 39講義: 關於Automated Migration
Tutorial 39: 關於Automated Migration




師資介紹

Kevin Lin

技術移民到澳洲的.NET Developer,對於.NET領域的相關技術與各式開發方式、多種前後端框架與工具、版控系統,皆有深入的研究。畢業於澳洲多個大學,其中2所全校第1名畢業,最高學歷為碩士。現任HiSKIO線上課程特約講師,以及IT工具人學院創辦人。以一門銜接一門的扎實打底學程,幫助許多想成為.NET Developer的朋友們,繞過彎路,快速學習。

2013 Certificate I in Hospitality (Provide Responsible Service of Alcohol) QHA QLD,酒精飲料服務責任執照, 昆士蘭餐飲協會。
2011 Graduate Diploma in IT Management CQU QLD,IT管理研究生文憑, 中央昆士蘭大學,該屆全校第1名畢業。
2010 Certificate IV in Property (Real Estate) Professional Real Estate Training QLD,專業昆士蘭房地產培訓4級證書。
2010 Master of Information System Griffith QLD,信息系統碩士,格里菲斯大學。
2008 Bachelor of IT Software Architecture QUT QLD,IT軟件架構學士,昆士蘭科技大學。
2005 Diploma in Information Technology QIBT QLD,IT專業文憑證書,昆士蘭商業技術學院,該屆全校第1名畢業。
















留言

這個網誌中的熱門文章

T000_011_Install Visual Studio 2019 Offline

T006_20201105_六角學院_C#的Type和Operator

T020_CreateLargeData_SubQuery_Join_Performance