課程時間
🔧【Tools工具安裝】3:30:56
🎬【Preview導讀】6:16:30
🎬【EntityFrameworkEpisode2(第2篇)-FluentAPI、DataAnnotation】13:15:51
課程章節
請按「Preview」預覽章節。
- FAQ-Handout,SampleCode(常見問題-講義、範例程式碼)
- (P1-1)導讀EF(1to6)(.NetFramework) (25:25)
- (P1-2)導讀EF(1)(.NetFramework) (30:56)
- (P1-3)導讀EF(2)(.NetFramework) (28:37)
- (P1-4)導讀EF(3)(.NetFramework) (18:26)
- (P1-5)導讀EF(4)(.NetFramework) (19:34)
- (P1-6)導讀EF(5)(.NetFramework) (21:43)
- (P1-7)導讀EF(6)(.NetFramework) (13:22)
- (P2-1)討論Tsql和工具 (22:31)
- (P2-2)討論EfDBFirst (15:06)
- (P2-3)使用EfPocoGenerator,討論EfDbFirst的Mapping模式 (22:37)
- (P2-4)討論EfDBFirst的Mapping模式和Migration模式 (62:02)
- (P2-5)結論 (15:23)
- (P3-1)導讀EF(5to6)(.NetFramework)程式碼 (35:28)
- (P3-2)設定EF(5to6)(.NetFramework)程式碼 (35:11)
- (T27-1)討論EfCodeFirst的Migration子開發模式搭配DataAnnotations語法。實作OneToMany和ManyToMany (18:18)
- (T27-2)討論EfCodeFirst的Migration子開發模式。實作MigrationScript來UpdateDatabase(更新資料庫) (8:20)
- (T28-1)建立Database,安裝EF (13:46)
- (T28-2)討論EfCodeFirst (4:57)
- (T28-3)討論EfCodeFirst-Migration,InitExistingDatabase(初始化現有資料庫) (13:59)
- (T28-4)討論EfCodeFirst-Migration,AddTable(新增資料表) (9:26)
- (T28-5)討論EfCodeFirst-Migration,AddColumn(新增欄位) (9:02)
- (T28-6)討論EfCodeFirst-Migration,EditExistingTable(修改現有資料表),AddColumn(新增欄位) (10:36)
- (T28-7)討論EfCodeFirst-Migration,EditExistingTable(修改現有資料表),DeleteColumn(刪除欄位) (2:51)
- (T28-8)討論EfCodeFirst-Migration,DeleteTable(刪除資料表) (9:00)
- (T28-9)討論EfCodeFirst-Migration,DowngradeDatabase(資料庫降版)和UpgradeDatabase(資料庫升版) (7:46)
- (T28-10)討論EfCodeFirst-Migration,Seeding(種子資料) (25:00)
- (T29-1)初步認識DataAnnotations、FluentApi (23:30)
- (T29-2)DataAnnotations實作SingleTable (23:38)
- (T29-3)DataAnnotations實作OneToManyRelationshipPart1 (9:47)
- (T29-4)DataAnnotations實作OneToManyRelationshipPart2 (4:41)
- (T29-5)DataAnnotations實作OneToManyRelationshipPart3 (4:48)
- (T29-6)DataAnnotations實作OneToManyRelationshipPart4 (5:45)
- (T29-7)DataAnnotations實作ManyToManyRelationship (9:34)
- (T30-1)討論MigrationInit (36:17)
- (T30-2)DataAnnotations語法對應AdminMemberTable (9:13)
- (T30-3)FluentApi語法對應AdminMemberTable (12:43)
- (T30-4)OneToOneOrMany-DataAnnotations語法對應AdminMemberTable和AdminMemberGroupTable (10:14)
- (T30-5)OneToOneOrMany-FluentApi語法對應AdminMemberTable和AdminMemberGroupTable (10:34)
- (T30-6)OneToZeroOrMany-DataAnnotations語法對應AdminMemberTable和AdminMemberAreaTable (15:27)
- (T30-7)OneToZeroOrMany-FluentApi語法對應AdminMemberTable和AdminMemberAreaTable (14:18)
- (T30-8)強制OneToOne-FluentApi語法對應GamerTable和GamerDetailTable (24:07)
- (T30-9)強制OneToZeroOrOne-DataAnnotations語法對應GamerTable和GamerExtraInformationTable (18:46)
- (T30-10)強制OneToZeroOrOne-FluentApi語法對應GamerTable和GamerExtraInformationTable (10:40)
- (T30-11)ManyToManyWithoutMiddleEfModel-DataAnnotations語法對應GamerTable和MagicTable (13:42)
- (T30-12)ManyToManyWithoutMiddleEfModel-FluentAPI語法對應GamerTable和MagicTable (11:42)
- (T30-13)ManyToManyWithMiddleEfModel-DataAnnotations語法對應GamerTable和SkillTable (10:51)
- (T30-14)ManyToManyWithMiddleEfModel-FluentAPI語法對應GamerTable和SkillTable (15:32)
- (T30-15)整理規劃FluentApi的EntityConfiguration (41:50)
- (T31-1)前置準備 (8:17)
- (T31-2)DataAnnotation語法實作TablePerHierarchy(TPH)Inheritance (18:01)
- (T31-3)實作MVC的Index、WarriorsIndex、MagicianIndex (22:40)
- (T31-4)實作MVC的EditWarrior、EditMagician (14:33)
- (T31-5)實作MVC的CreateWarrior、CreateMagician (9:02)
- (T31-6)實作MV的Delete (11:43)
- (T31-7)實作MVC的Details (8:26)
- (T31-8)DataAnnotation語法實作TablePerHierarchy(TPH)Inheritance並且OverrideDiscriminatorColumn (9:10)
- (T31-9)FluentApi語法實作TablePerHierarchy(TPH)Inheritance (15:24)
- (T31-10)FluentApi語法實作TablePerHierarchy(TPH)Inheritance並且OverrideDiscriminatorColumnPart1 (7:36)
- (T31-11)FluentApi語法實作TablePerHierarchy(TPH)Inheritance並且OverrideDiscriminatorColumnPart2 (5:22)
- (T31-12)證明EfModel不可包含DiscriminatorProperty (6:06)
- (T31-13)整理FluentApi (10:18)
- (T32-1)前置準備 (6:45)
- (T32-2)DataAnnotation語法實作TablePerType(TPT)Inheritance (13:04)
- (T32-3)實作MVC的Index、WarriorsIndex、MagicianIndex (13:44)
- (T32-4)實作MVC的EditWarrior、EditMagician (10:18)
- (T32-5)實作MVC的CreateWarrior、CreateMagician (9:45)
- (T32-6)實作MVC的Delete (7:46)
- (T32-7)實作MVC的Details (4:11)
- (T32-8)FluentApi語法實作TablePerType(TPT)Inheritance (9:22)
- (T32-9)整理FluentApi (7:59)
- (T33-1)前置準備 (6:38)
- (T33-2)FluentApi語法實作TablePerConcreteType(TPC)Inheritance (12:29)
- (T33-3)整理FluentApi (4:13)
🔴如果您在HiSKIO上購買了課程,則無需在Teachable重新購買相同課程。
請注意,Teachable Pay的發票無法提供給台灣公司報稅,如果需要台灣發票報稅,請去HiSKIO購買。
Teachable可能會產大約5%的「海外交易費」(詳情請諮詢您的發卡機構),為了學生權益,請使用「10%off」折價券
「Bundle」(組合包)更划算!
#「.Net Framework」相關系列「Bundle」(組合包)
- 🚀「包含5堂課」B-2-TSQL、C#、Linq、MVC、API同步攻略(Click here)
- 🚀「包含6堂課」B-3-EF(.NetFramework)學程第1-6篇(Click here)
- 🚀「包含5堂課」B-4-單元整合測試學程第1-5篇(Click here)
- 🚀「包含16堂課」B-5-扎實打底.NetFramework學程-TSQL、C#、LINQ、MVC、API、EF第1-6篇、測試第1-5篇(Click here)
-
🚀「IT工具人學院全部課程」B-1-1-All Course Membership全能學生證(Click here)
.Net Framework Serious(學程)
注意: 因為此系列已經沒有新東西可以教了,所以這個學程不會再加入新內容了!
#請來這邊看「.Net Framework Serious(學程)」簡介(Click here)
- 🚀2-1-TSQL(.NetFramework)扎實打底(Click here)
- 🚀2-2-C#(.NetFramework)深入解析(Click here)
- 🚀2-3-Linq(.NetFramework)完全攻略(Click here)
- 🚀2-4-Asp.NetMVC(.NetFramework)完全精通(Click here)
- 2-5A-EF(1to3)(.NetFramework)
- 🚀2-5A-1-EntityFrameworkEpisode1(第1篇)-CodeFirst、DBFirst(Click here)
- 🚀2-5A-2-EntityFrameworkEpisode2(第2篇)-FluentAPI、DataAnnotation(Click here)(👈😁你現在在此!)
- 🚀2-5A-3-EntityFrameworkEpisode3(第3篇)-UnitOfWorkWithRepository(Click here)
- 2-6B-Test(1to5)(.NetFramework)
- 🚀2-6B-1-TestEpisode1(第1篇)-TestFramework(測試框架)-MSTest、NUnit(Click here)
- 🚀2-6B-2-TestEpisode2(第2篇)-MockingFramework(隔離框架)-NSubstitute、Moq(Click here)
- 🚀2-6B-3-TestEpisode3(第3篇)-UnitTest(單元測試)、IntegrationTest(整合測試)(Click here)
- 🚀2-6B-4-TestEpisode4(第4篇)-FluentAssertionsPart1(Click here)
- 🚀2-6B-5-TestEpisode5(第5篇)-FluentAssertionsPart2(Click here)
- 2-7B-EF(4to6)(.NetFramework)PocoGenerator
- 🚀2-7B-4-EntityFrameworkEpisode4(第4篇)-PocoGenerator(Click here)
- 🚀2-7B-5-EntityFrameworkEpisode5(第5篇)-Test、UnitOfWorkWithRepositoryPart1(Click here)
- 🚀2-7B-6-EntityFrameworkEpisode6(第6篇)-Test、UnitOfWorkWithRepositoryPart2(Click here)
-
🚀2-8-Asp.NetMvcApi(.NetFramework)(VS2017)扎實打底(Click here)
本課簡介
Hi My name is Kevin. 我是一名移民到澳大利亞的軟體工程師,個人專注於各種技術和使用者界面的開發與研究。
【EntityFrameworkEpisode2(第2篇)-FluentAPI、DataAnnotation】是一門銜接一門的「.Net Framework學程」中其中一個課程。
此篇會深入"EfCodeFirst-Migration"子開發模式下,有關"Relationship"的語法,分為"DataAnnotations"語法和"FluentAPI"語法。
Course Highlight(本課魔王)
😈第一魔王,(T28)討論EfCodeFirst的Migration子開發模式搭配DataAnnotations語法。討論InitExistingDatabase、AddTable、DeleteTable、AddColumn、DeleteColumn、DowngradeDatabase、UpgradeDatabase。
😈第二魔王,(T29)使用DataAnnotations來OverridingCodeFirstConventions。(T30)比較DataAnnotatios、FluentApi。
😈第三魔王,(T31)討論TablePerHierarchy(TPH)Inheritance,比較DataAnnotation、FluentApi。(T32)討論TablePerType(TPT)Inheritance,比較DataAnnotation、FluentApi。(T33)討論FluentApi語法實作TablePerConcreteType(TPC)Inheritance。
😈第四魔王,(T34)Ef連接到StoredProcedure。
😈第五魔王,(T35)理解AutoMapper。
想朝軟體工程師之路前進嗎?受夠了像是文字天書,艱深難懂的工具文件嗎?對自己的底子沒信心嗎?若你想扎實打底,本課程將讓你收穫滿滿!歡迎加入「IT工具人學院,帶你學到會」,一起練功吧!!顆顆。
工具安裝
🔧Microsoft SQL Server
🔧Visual Studio
課前技能
✍HTML 5 CSS3
✍Javascript
✍TSQL
✍C#
✍Linq
✍Asp . Net MVC (. Net Framework)
單元簡介
導讀
- (P1)導讀EF(1to6)(.NetFramework)
- (P2)開發EF
- (P3)EF(5to6)(.NetFramework)程式碼
討論EfCodeFirst的Migration子開發模式搭配DataAnnotations語法
- (T27)討論EfCodeFirst的Migration子開發模式搭配DataAnnotations語法。實作OneToMany和ManyToMany
- (T27-1)討論EfCodeFirst的Migration子開發模式搭配DataAnnotations語法。實作OneToMany和ManyToMany
- (T27-2)討論EfCodeFirst的Migration子開發模式。實作MigrationScript來UpdateDatabase(更新資料庫)
- (T28)討論EfCodeFirst的Migration子開發模式搭配DataAnnotations語法。討論InitExistingDatabase、AddTable、DeleteTable、AddColumn、DeleteColumn、DowngradeDatabase、UpgradeDatabase
- (T28-1)建立Database,安裝EF
- (T28-2)討論EfCodeFirst
- (T28-3)討論EfCodeFirst-Migration,InitExistingDatabase(初始化現有資料庫)
- (T28-4)討論EfCodeFirst-Migration,AddTable(新增資料表)
- (T28-5)討論EfCodeFirst-Migration,AddColumn(新增欄位)
- (T28-6)討論EfCodeFirst-Migration,EditExistingTable(修改現有資料表),AddColumn(新增欄位)
- (T28-7)討論EfCodeFirst-Migration,EditExistingTable(修改現有資料表),DeleteColumn(刪除欄位)
- (T28-8)討論EfCodeFirst-Migration,DeleteTable(刪除資料表)
- (T28-9)討論EfCodeFirst-Migration,DowngradeDatabase(資料庫降版)和UpgradeDatabase(資料庫升版)
- (T28-10)討論EfCodeFirst-Migration,Seeding(種子資料)
討論OverridingCodeFirstConventions-DataAnnotations、FluentApi
- (T29)使用DataAnnotations來OverridingCodeFirstConventions
- (T29-1)初步認識DataAnnotations、FluentApi
- (T29-2)DataAnnotations實作SingleTable
- (T29-3)DataAnnotations實作OneToManyRelationshipPart1
- (T29-4)DataAnnotations實作OneToManyRelationshipPart2
- (T29-5)DataAnnotations實作OneToManyRelationshipPart3
- (T29-6)DataAnnotations實作OneToManyRelationshipPart4
- (T29-7)DataAnnotations實作ManyToManyRelationship
- (T30)比較DataAnnotatios、FluentApi
- (T30-1)討論MigrationInit
- (T30-2)DataAnnotations語法對應AdminMemberTable
- (T30-3)FluentApi語法對應AdminMemberTable
- (T30-4)OneToOneOrMany-DataAnnotations語法對應AdminMemberTable和AdminMemberGroupTable
- (T30-5)OneToOneOrMany-FluentApi語法對應AdminMemberTable和AdminMemberGroupTable
- (T30-6)OneToZeroOrMany-DataAnnotations語法對應AdminMemberTable和AdminMemberAreaTable
- (T30-7)OneToZeroOrMany-FluentApi語法對應AdminMemberTable和AdminMemberAreaTable
- (T30-8)強制OneToOne-FluentApi語法對應GamerTable和GamerDetailTable
- (T30-9)強制OneToZeroOrOne-DataAnnotations語法對應GamerTable和GamerExtraInformationTable
- (T30-10)強制OneToZeroOrOne-FluentApi語法對應GamerTable和GamerExtraInformationTable
- (T30-11)ManyToManyWithoutMiddleEfModel-DataAnnotations語法對應GamerTable和MagicTable
- (T30-12)ManyToManyWithoutMiddleEfModel-FluentAPI語法對應GamerTable和MagicTable
- (T30-13)ManyToManyWithMiddleEfModel-DataAnnotations語法對應GamerTable和SkillTable
- (T30-14)ManyToManyWithMiddleEfModel-FluentAPI語法對應GamerTable和SkillTable
- (T30-15)整理規劃FluentApi的EntityConfiguration
深入理解TablePerHierarchy(TPH)/TablePerType(TPT)/TablePerConcrete(TPC),比較Data Annotations V.S. Fluent API
- (T31)討論TablePerHierarchy(TPH)Inheritance,比較DataAnnotation、FluentApi
- (T31-1)前置準備
- (T31-2)DataAnnotation語法實作TablePerHierarchy(TPH)Inheritance
- (T31-3)實作MVC的Index、WarriorsIndex、MagicianIndex
- (T31-4)實作MVC的EditWarrior、EditMagician
- (T31-5)實作MVC的CreateWarrior、CreateMagician
- (T31-6)實作MV的Delete
- (T31-7)實作MVC的Details
- (T31-8)DataAnnotation語法實作TablePerHierarchy(TPH)Inheritance並且OverrideDiscriminatorColumn
- (T31-9)FluentApi語法實作TablePerHierarchy(TPH)Inheritance
- (T31-10)FluentApi語法實作TablePerHierarchy(TPH)Inheritance並且OverrideDiscriminatorColumnPart1
- (T31-11)FluentApi語法實作TablePerHierarchy(TPH)Inheritance並且OverrideDiscriminatorColumnPart2
- (T31-12)證明EfModel不可包含DiscriminatorProperty
- (T31-13)整理FluentApi
- (T32)討論TablePerType(TPT)Inheritance,比較DataAnnotation、FluentApi
- (T32-1)前置準備
- (T32-2)DataAnnotation語法實作TablePerType(TPT)Inheritance
- (T32-3)實作MVC的Index、WarriorsIndex、MagicianIndex
- (T32-4)實作MVC的EditWarrior、EditMagician
- (T32-5)實作MVC的CreateWarrior、CreateMagician
- (T32-6)實作MVC的Delete
- (T32-7)實作MVC的Details
- (T32-8)FluentApi語法實作TablePerType(TPT)Inheritance
- (T32-9)整理FluentApi
- (T33)討論FluentApi語法實作TablePerConcreteType(TPC)Inheritance
- (T33-1)前置準備
- (T33-2)FluentApi語法實作TablePerConcreteType(TPC)Inheritance
- (T33-3)整理FluentApi
Ef連接到StoredProcedure
- (T34)Ef連接到StoredProcedure
- (T34-1)前置準備
- (T34-2)EfMigrationInit
- (T34-3)自動生成MVC
- (T34-4)Ef連接到StoredProcedure
討論AutoMapper
- (T35)理解AutoMapper
- (T35-1)討論AutoMapper的Person對應Member
- (T35-2)討論AutoMapper的Person對應Gamer
- (T35-3)討論AutoMapper的PersonList對應MemberList
- (T35-4)討論AutoMapper的PersonList對應GamerList