02_07B Entity Framework POCO episode 04 to 06

02_07B Entity Framework POCO episode 04 to 06


  
【 Entity Framework第4篇: 加速開發POCO generator 】 Entity Framework episode 4: POCO generator 課程編號: a0711472-3f86-4f54-9c46-6b4158b1af93 熟悉 EF Poco Generator 這項工具來加速開發工作。
此講義目錄Table of Content:   https://ithandyguytutorial.blogspot.com/p/07bentityframeworkreversepocogenerator.html
Tutorial 1 ~ 06
此YouTube PlayList:   https://www.youtube.com/playlist?list=PLXstZ12GxF9w-dZhXssGOBu8EdOGsi9hb&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
Entity Framework episode 3: Unit of work with Repository
Entity Framework第3篇: 熟能生巧Unit of work with Repository
======================================
  
  
【 Entity Framework第5篇: 技術整合Part 1, Test Unit of work with Repository Part1 】 Entity Framework episode 5: Test Unit of work with Repository Part1 課程編號: 2fcfbe01-e249-4057-a5a7-0d567eb693a8 整合我們目前所學技術包括 TSQL、C#、Linq,Unit Test、HTML CSS、MVC、EF,手寫出一個完整的範例。 此講義目錄Table of Content: https://ithandyguytutorial.blogspot.com/p/07bentityframeworkreversepocogenerator.html Tutorial 7 ~ 36
此YouTube PlayList: https://www.youtube.com/playlist?list=PLXstZ12GxF9x_OiP4Tr89QCDHpdFQcnMY&disable_polymer=true ------------------------------------ 【 Entity Framework第6篇: 技術整合Part 2, Test Unit of work with Repository Part2 】 Entity Framework episode 6: Test Unit of work with Repository Part2 課程編號: 6756936e-d0a4-4552-8010-d5269622010a 繼續在同一個範例把 Unit Of Work 和 Repository 搭配 AutoMapper 連接到 MVC。
並建立 Search bar 搭配 AutoComplete,Sorting,分頁,Caching,
還有delete multiple等各種 MVC 精華重點。 此講義目錄Table of Content: https://ithandyguytutorial.blogspot.com/p/07bentityframeworkreversepocogenerator.html Tutorial 37 ~ 75
此YouTube PlayList: https://www.youtube.com/playlist?list=PLXstZ12GxF9zI-rhy0kMXu4G9RdZWoiSf&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
Entity Framework episode 3: Unit of work with Repository
Entity Framework第3篇: 熟能生巧Unit of work with Repository
Entity Framework episode 4: POCO generator
Entity Framework第4篇: 加速開發POCO generator
------------------------------------
#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

Please read the following
-->

EF series Preview

EFseries_Preview01_EF學程簡介

EFseries_Preview02_EntityFramework開發

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

本篇程導讀

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

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

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

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

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

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

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

EF Poco Generator Introduction
簡單理解EF Poco Generator



T001_PocoGeneratorIntroduction
----------------------
Tutorial 01講義: 簡單理解EF Poco Generator
Tutorial 01: 簡單理解EF Poco Generator

Poco Generator to EF Code First
使用Poco Generator將現有的DB轉成EF Code First程式碼



T002_01_Tsql
T002_02_PocoGeneratorFromAnExistingDB
T002_03_ConnectionStringName
T002_04_DBContextName
T002_05_TTtoOtherFolder_NameSpace
T002_06_MakeClassesPartial
T002_07_MakeClassesPartial_DbContextInterfaceBaseClasses_DbContextBaseClasses
T002_08_ConfigurationClassName_EntityTypeConfigurationByFluentAPI
T002_09_UsePascalCase
T002_10_IncludeViews
T002_11_IncludeTableValuedFunctions
T002_12_CollectionType_EFModelNavigationPropertyCollectionType
T002_13_AddUnitTestingDbContext_FakeDbContext.cs_FakeDbSet.cs_UnitTesting
T002_14_AdditionalNamespaces
T002_15_AdditionalContextInterfaceItems
T002_16_IncludeComments_AtEndOfField_InSummaryBlock_None
T002_17_IncludeComments, IncludeExtendedPropertyComments_ColumnDescription
T002_18_DisableGeographyTypes
T002_19_IncludeQueryTraceOn9481Flag
T002_20_GenerateSeparateFiles
----------------------
Tutorial 02講義: 使用Poco Generator將現有的DB轉成EF Code First程式碼
Tutorial 02-01: T-SQL建立資料庫
Tutorial 02-02: 使用POCO Generator將現有的DB轉成EF
Tutorial 02-03: 討論Connection String Name
Tutorial 02-04: 討論DBContextName
Tutorial 02-05: 討論把TT檔案移到其他資料夾,討論NameSpace
Tutorial 02-06: 討論MakeClassesPartial
Tutorial 02-07: 討論MakeClassesPartial搭配DbContextInterfaceBaseClasses和DbContextBaseClasses
Tutorial 02-08: 討論ConfigurationClassName也就是EntityTypeConfiguration by Fluent API
Tutorial 02-09: 討論UsePascalCase
Tutorial 02-10: 討論IncludeViews
Tutorial 02-11: 討論IncludeTableValuedFunctions
Tutorial 02-12: 討論CollectionType也就是EF Model Navigation Property Collection Type
Tutorial 02-13: 討論AddUnitTestingDbContext,也就是FakeDbContext.cs搭配FakeDbSet.cs寫unit testing
Tutorial 02-14: 討論AdditionalNamespaces
Tutorial 02-15: 討論AdditionalContextInterfaceItems
Tutorial 02-16: 討論IncludeComments。討論CommentsStyle.AtEndOfField和InSummaryBlock和None
Tutorial 02-17: 討論IncludeComments和IncludeExtendedPropertyComments。討論ColumnDescription
Tutorial 02-18: 討論DisableGeographyTypes
Tutorial 02-19: 討論IncludeQueryTraceOn9481Flag
Tutorial 02-20: 討論GenerateSeparateFiles


Poco Generator to different folders and projects
分散到不同的資料夾。分散到不同的Project



T003_01_Tsql_NewProject
T003_02_PocoGeneratorFromAnExistingDB
T003_03_PocoGenerator_SeparateFolder
T003_04_PocoGenerator_SeparateProject
----------------------
Tutorial 03講義: 分散到不同的資料夾。分散到不同的Project。
Tutorial 03-01: T-SQL建立資料庫。建立新的Project
Tutorial 03-02: 使用POCO Generator將現有的DB轉成EF
Tutorial 03-03: 使用POCO Generator,分散到不同的資料夾。
Tutorial 03-04: 使用POCO Generator,分散到不同的Project。


Poco Generator Setting
認識Poco Generator Setting


T004_01_TSQL
T004_02_PocoGenerator
T004_03_TableRename
T004_04_UpdateColumn
T004_05_EnumDefinitions
T004_06_StoredProcedureRename
T004_07_WritePocoClassAttributes
T004_08_WritePocoBaseClasses
T004_09_WritePocoBaseClassBody
T004_10_WritePocoColumn
T004_11_EnglishPluralizationService
----------------------
Tutorial 04講義: 認識Poco Generator Setting
Tutorial 04-01: 認識TSQL
Tutorial 04-02: 使用Poco Generator
Tutorial 04-03: 認識TableRename
Tutorial 04-04: 認識UpdateColumn
Tutorial 04-05: 認識EnumDefinitions
Tutorial 04-06: 認識StoredProcedureRename
Tutorial 04-07: 認識WritePocoClassAttributes
Tutorial 04-08: 認識WritePocoBaseClasses
Tutorial 04-09: 認識WritePocoBaseClassBody
Tutorial 04-10: 認識WritePocoColumn
Tutorial 04-11: 認識EnglishPluralizationService


Poco Generator Automated Migration
認識Poco Generator Automated Migration


T005_01_PocoGenerator_Setup
T005_02_WhatToDo
T005_03_AutomaticMigrationsEnabled_false
T005_04_AutomaticMigrationsEnabled_true
T005_05_Migration_AutomaticMigrations
----------------------
Tutorial 05講義: 認識Poco Generator Automated Migration
Tutorial 05-01: 初始設定Poco Generator
Tutorial 05-02: 本Tutorial的目的
Tutorial 05-03: 設定AutomaticMigrationsEnabled為false
Tutorial 05-04: 設定AutomaticMigrationsEnabled為true
Tutorial 05-05: 實作Migration和Automatic Migrations



Filtering
關於Filtering


T006_Filtering
----------------------
Tutorial 06講義: 認識Filtering
Tutorial 06-01: 基本設定
Tutorial 06-02: 認識Filtering



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


Data Models and DbContext
Data Model和DbContext



T007_01_Revise
T007_02_ConnectionString_UnitOfWork_Repository_Concept
T007_03_DatabaseDiagram
T007_04_All_Demo_TSQL_CreateTable_InsertData
--------------
T007_05to07_All_Demo_TSQL_View_StoredProcedure_TableValuedFunction
T007_05_All_Demo_TSQL_View
T007_06_All_Demo_TSQL_StoredProcedure
T007_07_All_Demo_TSQL_TableValuedFunction
--------------
T007_08_All_Insert_TSQL
T007_09_All_TestData_TSQL
T007_10_WhatToDo
--------------------------------------------
Tutorial 07講義: 認識UnitOfWork和Repository觀念
Tutorial 07-01: 複習
Tutorial 07-02: 一些ConnectionString和UnitOfWork和Repository觀念
Tutorial 07-03: Database圖表
Tutorial 07-04: All_Demo的TSQL,討論Create Table和Insert Data
--------------
Tutorial 07_05to07: 討論TSQL的View和Stored Procedure和Table Valued Function
Tutorial 07-05: All_Demo的TSQL,討論TSQL View
Tutorial 07-06: All_Demo的TSQL,討論TSQL Stored Procedure
Tutorial 07-07: All_Demo的TSQL,討論TSQL Table Valued Function
--------------
Tutorial 07-08: All_Insert的TSQL
Tutorial 07-09: All_TestData的TSQL
Tutorial 07-10: WhatToDo



T008_01_PoCoGenerator_OnlineGameTwoSolution
T008_02to03_OnlineGameSolution
T008_02_OnlineGameSolution_Data
T008_03_OnlineGameSolution_UiData
----------------------
Tutorial 08講義: 用PoCoGenerator來加速開發EF
Tutorial 08-01: 用PoCoGenerator製造OnlineGameTwo Solution
Tutorial 08-02: 準備OnlineGame Solution,Data
Tutorial 08-03: 準備OnlineGame Solution,UiData



T009_01_DomainEntity
T009_02_EntityConfiguration
T009_03_MigrationInit
T009_04_ViewEntity
T009_05_ViewEntityConfiguration
T009_06_MigrationView
T009_07_UiConsoleApp_StaticMethod
T009_08_UiConsoleApp_DbContextWay
T009_09_ViewSummary
----------------------
Tutorial 09講義: PoCoGenerator加速開發EF的Table和View
Tutorial 09-01: 理解Domain Entity
Tutorial 09-02: 理解Entity Configuration
Tutorial 09-03: 製作Migration Init
Tutorial 09-04: 理解View Entity
Tutorial 09-05: 理解View Entity Configuration
Tutorial 09-06: 製作Migration View
Tutorial 09-07: UiConsoleApp中的一些StaticMethod
Tutorial 09-08: UiConsoleApp中的DbContextWay
Tutorial 09-09: View Summary



T010_01_TSQL_StoredProcedure
T010_02_DynamicTSQL_PocoGenerator
T010_03_StoredProcedureEntity
T010_04_DbContextInterface
T010_05_DbContext
T010_06_StaticMethodPrint
T010_07_DbContextWay.Sp
T010_08_MigrationStoredProcedure
T010_09_TestConnectionString
----------------------
Tutorial 10講義: PoCoGenerator加速開發EF的StoredProcedure
Tutorial 10-01: 理解TSQL Stored Procedure
Tutorial 10-02: 理解DynamicTSQL製造PocoGenerator
Tutorial 10-03: 理解StoredProcedureEntity
Tutorial 10-04: 理解DbContextInterface
Tutorial 10-05: 理解DbContext
Tutorial 10-06: 理解StaticMethodPrint
Tutorial 10-07: 製作DbContextWay.Sp
Tutorial 10-08: 理解MigrationStoredProcedure
Tutorial 10-09: 製作TestConnectionString



T011_01_EF_TableValuedFunction
T011_02_UiConsoleApp_TableValuedFunction
T011_03_AddMigration_TableValuedFunctionMapping
T011_04_TableValuedFunctionSummary
----------------------
Tutorial 11講義: PoCoGenerator加速開發EF的TableValuedFunction
Tutorial 11-01: 理解EF的TableValuedFunction
Tutorial 11-02: UiConsoleApp使用EF的TableValuedFunction
Tutorial 11-03: 理解EF的TableValuedFunctionMigration
Tutorial 11-04: EF的TableValuedFunction結論


DataModelRepository_DataModelUnitOfWork
DataModelRepository 和 DataModelUnitOfWork



T012_01_ReviseDbContext
T012_02_EntityValidator
----------------------
Tutorial 12講義: Data Repository層的Validator
Tutorial 12-01: 複習DbContext
Tutorial 12-02: 理解Entity Validator




T013_01_DataRepository_GenericRepositoryInterface
T013_02_DataRepository_GenericRepository
----------------------
Tutorial 13講義: Data Repository層的Generic Repository
Tutorial 13-01: 理解Data Repository層的Generic Repository Interface
Tutorial 13-02: 理解Data Repository層的Generic Repository



T014_01_DataRepository_GamerRepository
T014_02_DataRepository_DataRepositoryWay_GamerValidator
----------------------
Tutorial 14講義: Data Repository層的Gamer Repository
Tutorial 14-01: 製作Gamer Repository
Tutorial 14-02: DataRepositoryWay理解GamerValidator



T015_01_DataRepository_EntityRepositoryInterface
T015_02_DataRepository_ViewRepositoryInterface
T015_03_DataRepository_StoredProcedure_UnitOfWorkInterface
----------------------
Tutorial 15講義: Data Repository層的Repository Interface和UnitOfWork Interface
Tutorial 15-01: Data Repository層的Entity Repository Interface
Tutorial 15-02: Data Repository層的View Repository Interface
Tutorial 15-03: Data Repository層的Stored Procedure和UnitOfWork Interface



T016_01_DataRepository_EntityRepository
T016_02_DataRepository_ViewRepository
T016_03_DataRepository_StoredProcedure_UnitOfWork
----------------------
Tutorial 16講義: Data Repository層的Repository和UnitOfWork
Tutorial 16-01: Data Repository層的Entity Repository
Tutorial 16-02: Data Repository層的View Repository
Tutorial 16-03: Data Repository層的StoredProcedure和UnitOfWork



----------------------
Tutorial 17講義: 使用Data Repository層的OnePk Repository



----------------------
Tutorial 18講義: 使用Data Repository層的TwoPk Repository



----------------------
Tutorial 19講義: 使用Data Repository層的View Repository



----------------------
Tutorial 20講義: 使用Data Repository層的UnitOfWork的Stored Procedure



----------------------
Tutorial 21講義: 使用Data Repository層的UnitOfWork的Table Valued Function


Data Repository Unit Test by NUnit
NUnit的Unit Test測試Data Repository



----------------------
Tutorial 22講義: 使用FakeDbContext



----------------------
Tutorial 23講義: 使用FEntityValidator




T024_01_TestDataNUnitRepository_AreaRepositoryTest
T024_02_TestDataNUnitRepository_GamerDetailRepositoryTest
T024_03_TestDataNUnitRepository_GamerRepositoryTest
T024_04_TestDataNUnitRepository_GamerSkillRepositoryTest
T024_05_TestDataNUnitRepository_MagicRepositoryTest
T024_06_TestDataNUnitRepository_SkillRepositoryTest
T024_07_TestDataNUnitRepository_TeamRepositoryTest
----------------------
Tutorial 24講義: NUnit的Unit Test測試TestDataNUnitRepository的EntityRepository
Tutorial 24-01: 理解TestDataNUnitRepository的AreaRepositoryTest
Tutorial 24-02: 理解TestDataNUnitRepository的GamerDetailRepositoryTest
Tutorial 24-03: 理解TestDataNUnitRepository的GamerRepositoryTest
Tutorial 24-04: 理解TestDataNUnitRepository的GamerSkillRepositoryTest
Tutorial 24-05: 理解TestDataNUnitRepository的MagicRepositoryTest
Tutorial 24-06: 理解TestDataNUnitRepository的SkillRepositoryTest
Tutorial 24-07: 理解TestDataNUnitRepository的TeamRepositoryTest



----------------------
Tutorial 25講義: NUnit的Unit Test測試TestDataNUnitRepository的ViewRepository



Data Repository Integration Test by NUnit
NUnit的Integration Test測試Data Repository


T026_01_IntegrationTestDataNUnitRepository_AreaRepositoryTest
T026_02_IntegrationTestDataNUnitRepository_GamerDetailRepositoryTest
T026_03_IntegrationTestDataNUnitRepository_GamerRepositoryTest
T026_04_IntegrationTestDataNUnitRepository_GamerSkillRepositoryTest
T026_05_IntegrationTestDataNUnitRepository_MagicRepositoryTest
T026_06_IntegrationTestDataNUnitRepository_SkillRepositoryTest
T026_07_IntegrationTestDataNUnitRepository_TeamRepositoryTest
----------------------
Tutorial 26講義: NUnit的Integration Test測試TestDataNUnitRepository的EntityRepository
Tutorial 26-01: 理解IntegrationTestDataNUnitRepository的AreaRepositoryTest
Tutorial 26-02: 理解IntegrationTestDataNUnitRepository的GamerDetailRepositoryTest
Tutorial 26-03: 理解IntegrationTestDataNUnitRepository的GamerRepositoryTest
Tutorial 26-04: 理解IntegrationTestDataNUnitRepository的GamerSkillRepositoryTest
Tutorial 26-05: 理解IntegrationTestDataNUnitRepository的MagicRepositoryTest
Tutorial 26-06: 理解IntegrationTestDataNUnitRepository的SkillRepositoryTest
Tutorial 26-07: 理解IntegrationTestDataNUnitRepository的TeamRepositoryTest



----------------------
Tutorial 27講義: NUnit的Integration Test測試TestDataNUnitIntegration的EntityRepository



----------------------
Tutorial 28講義: NUnit的Integration Test測試TestDataNUnitIntegration的Table Valued Function



----------------------
Tutorial 29講義: NUnit的Integration Test測試TestDataNUnitIntegration的Stored Procedure



Data Repository Unit Test by MSTest
MSTest的Unit Test測試Data Repository


----------------------
Tutorial 30講義: MSTest的Unit Test測試TestDataNUnitRepository的EntityValidator



T031_01_TestDataRepository_AreaRepositoryTest
T031_02_TestDataRepository_GamerDetailRepositoryTest
T031_03_TestDataRepository_GamerRepositoryTest
T031_04_TestDataRepository_GamerSkillRepositoryTest
T031_05_TestDataRepository_MagicRepositoryTest
T031_06_TestDataRepository_SkillRepositoryTest
T031_07_TestDataRepository_TeamRepositoryTest
--------------------------------------------
Tutorial 31講義: MSTest的Unit Test測試TestDataNUnitRepository的EntityRepository
Tutorial 31-01: 理解TestDataNUnitRepository的AreaRepositoryTest
Tutorial 31-02: 理解TestDataNUnitRepository的GamerDetailRepositoryTest
Tutorial 31-03: 理解TestDataNUnitRepository的GamerRepositoryTest
Tutorial 31-04: 理解TestDataNUnitRepository的GamerSkillRepositoryTest
Tutorial 31-05: 理解TestDataNUnitRepository的MagicRepositoryTest
Tutorial 31-06: 理解TestDataNUnitRepository的SkillRepositoryTest
Tutorial 31-07: 理解TestDataNUnitRepository的TeamRepositoryTest
---------------------------------------------------
Please revise
Test測試課程
T004_CodeCoverage_TestPrivateMethod_Exception_Order_GenericTest_CommandLine copy
---------------------
T015_SortingTest
---------------------
有些"測試執行順序"的觀念這裡講的並不完全正確
觀念澄清的部分請參考"測試課程"T004,T015
請參考"課前補充單元測試冷門知識"



----------------------
Tutorial 32講義: MSTest的Unit Test測試TestDataNUnitRepository的ViewRepository


Data Repository Integration Test by MSTest
MSTest的Integration Test測試Data Repository


T033_01_IntegrationTestDataRepository_AreaRepositoryTest
T033_02_IntegrationTestDataRepository_GamerDetailRepositoryTest
T033_03_IntegrationTestDataRepository_GamerRepositoryTest
T033_04_IntegrationTestDataRepository_GamerSkillRepositoryTest
T033_05_IntegrationTestDataRepository_MagicRepositoryTest
T033_06_IntegrationTestDataRepository_SkillRepositoryTest
T033_07_IntegrationTestDataRepository_TeamRepositoryTest
---------------------------------------------------
Tutorial 33講義: MSTest的Integration Test測試TestDataNUnitIntegration的EntityValidator
Tutorial 33-01: 理解IntegrationTestDataNUnitRepository的AreaRepositoryTest
Tutorial 33-02: 理解IntegrationTestDataNUnitRepository的GamerDetailRepositoryTest
Tutorial 33-03: 理解IntegrationTestDataNUnitRepository的GamerRepositoryTest
Tutorial 33-04: 理解IntegrationTestDataNUnitRepository的GamerSkillRepositoryTest
Tutorial 33-05: 理解IntegrationTestDataNUnitRepository的MagicRepositoryTest
Tutorial 33-06: 理解IntegrationTestDataNUnitRepository的SkillRepositoryTest
Tutorial 33-07: 理解IntegrationTestDataNUnitRepository的TeamRepositoryTest
---------------------------------------------------
Please revise
Test測試課程
T004_CodeCoverage_TestPrivateMethod_Exception_Order_GenericTest_CommandLine copy
---------------------
T015_SortingTest
---------------------
有些"測試執行順序"的觀念這裡講的並不完全正確
觀念澄清的部分請參考"測試課程"T004,T015
請參考"課前補充單元測試冷門知識"



----------------------
Tutorial 34講義: MSTest的Integration Test測試TestDataNUnitIntegration的EntityRepository



----------------------
Tutorial 35講義: MSTest的Integration Test測試TestDataNUnitIntegration的Table Valued Function



----------------------
Tutorial 36講義: MSTest的Integration Test測試TestDataNUnitIntegration的Stored Procedure



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


UiDataModelRepository_UiDataModelUnitOfWork
UiDataModelRepository 和 UiDataModelUnitOfWork


T037_01_UiDomainEntity_UiModel
T037_02_UiDomainEntity_StoredProcedure
T037_03_UiDomainEntity_ViewEntity
T037_04_UiDomainEntity_TableValuedFunction
----------------------
T037_UiDomainEntity
Tutorial 37-01: UiDomain Entity的UiModel
Tutorial 37-02: UiDomain Entity的Stored Procedure
Tutorial 37-03: UiDomain Entity的View Entity
Tutorial 37-04: UiDomain Entity的Table Valued Function



----------------------
Tutorial 38講義: UiDomainEntity搭配AutoMapper



T039_01_UiDataRepository_GenericRepositoryInterface
T039_02_UiDataRepository_GenericRepository
----------------------
Tutorial 39講義: UiDataRepository的Generic Repository
Tutorial 39-01: UiDataRepository的GenericRepository Interface
Tutorial 39-02: UiDataRepository的GenericRepository



T040_01_UiDataRepository_EntityRepositoryInterface
T040_02_UiDataRepository_EntityRepository
----------------------
Tutorial 40講義: UiDataRepository的Entity Repository
Tutorial 40-01: UiDataRepository的Entity Repository Interface
Tutorial 40-02: UiDataRepository的Entity Repository



----------------------
Tutorial 41講義: UiDataRepository的View Repository



----------------------
Tutorial 42講義: UiDataRepository搭配UnitOfWork使用StoredProcedure



----------------------
Tutorial 43講義: UiDataRepository搭配UnitOfWork使用TableValuedFunction



T044_01_UiConsoleApp_StaticMethod_Entity
T044_02_UiConsoleApp_StaticMethod_ViewEntity
T044_03_UiConsoleApp_StaticMethod_StoredProcedure
T044_04_UiConsoleApp_StaticMethod_TableValuedFunction
T044_05_UiConsoleApp_UiDataRepositoryWay_GamerValidator
----------------------
Tutorial 44講義: UiDataRepository使用GamerValidator
Tutorial 44-01: UiConsoleApp的StaticMethod的Print Entity
Tutorial 44-02: UiConsoleApp的StaticMethod的Print ViewEntity
Tutorial 44-03: UiConsoleApp的StaticMethod的Print StoredProcedure
Tutorial 44-04: UiConsoleApp的StaticMethod的Print TableValuedFunction
Tutorial 44-05: UiConsoleApp的UiDataRepositoryWay執行GamerValidator



----------------------
Tutorial 45講義: UiDataRepository搭配UnitOfWork使用1個PK的Entity



----------------------
Tutorial 46講義: UiDataRepository搭配UnitOfWork使用2個PK的Entity



----------------------
Tutorial 47講義: UiDataRepository搭配UnitOfWork使用View



----------------------
Tutorial 48講義: UiDataRepository搭配UnitOfWork使用Stored Procedure



----------------------
Tutorial 49講義: UiDataRepository搭配UnitOfWork使用Table Valued Function



UiData Repository Unit Test by NUnit
NUnit的Unit Test測試UiData Repository



T050_01_NUnit_OneTimeSetUp_OneTimeTearDown
T050_02_TestUiDataNUnitRepository_VmAreaRepositoryTest
T050_03_TestUiDataNUnitRepository_VmGamerDetailRepositoryTest
T050_04_TestUiDataNUnitRepository_VmGamerRepositoryTest
T050_05_TestUiDataNUnitRepository_VmGamerSkillRepositoryTest
T050_06_TestUiDataNUnitRepository_VmMagicRepositoryTest
T050_07_TestUiDataNUnitRepository_VmSkillRepositoryTest
T050_08_TestUiDataNUnitRepository_VmTeamRepositoryTest
T050_09_OneTimeSetUp_OneTimeTearDown
----------------------
Tutorial 50講義: TestUiDataNUnitRepository的VmEntityRepository
Tutorial 50-01:  NUnit的OneTimeSetUp和OneTimeTearDown
Tutorial 50-02: 理解TestUiDataNUnitRepository的VmAreaRepositoryTest
Tutorial 50-03: 理解TestUiDataNUnitRepository的VmGamerDetailRepositoryTest
Tutorial 50-04: 理解TestUiDataNUnitRepository的VmGamerRepositoryTest
Tutorial 50-05: 理解TestUiDataNUnitRepository的VmGamerSkillRepositoryTest
Tutorial 50-06: 理解TestUiDataNUnitRepository的VmMagicRepositoryTest
Tutorial 50-07: 理解TestUiDataNUnitRepository的VmSkillRepositoryTest
Tutorial 50-08: 理解TestUiDataNUnitRepository的VmTeamRepositoryTest
Tutorial 50-09: 理解OneTimeSetUp和OneTimeTearDown



T051_01_TestUiDataNUnitRepository_VmVwGamerAndDetailAndTeamAndAreaAndMagicRepositoryTest
T051_02_TestUiDataNUnitRepository_VmVwGamerAndDetailAndTeamAndAreaAndSkillRepositoryTest
T051_03_TestUiDataNUnitRepository_VmVwGamerAndDetailAndTeamAndAreaRepositoryTest
T051_04_TestUiDataNUnitRepository_VmVwGamerSkillCountRepositoryTest
T051_05_TestUiDataNUnitRepository_VmVwTeamAndGamerCountRepositoryTest
----------------------
Tutorial 51講義: TestUiDataNUnitRepository的VmViewRepository
Tutorial 51-01: 理解TestUiDataNUnitRepository的VmVwGamerAndDetailAndTeamAndAreaAndMagicRepositoryTest
Tutorial 51-02: 理解TestUiDataNUnitRepository的VmVwGamerAndDetailAndTeamAndAreaAndSkillRepositoryTest
Tutorial 51-03: 理解TestUiDataNUnitRepository的VmVwGamerAndDetailAndTeamAndAreaRepositoryTest
Tutorial 51-04: 理解TestUiDataNUnitRepository的VmVwGamerSkillCountRepositoryTest
Tutorial 51-05: 理解TestUiDataNUnitRepository的VmVwTeamAndGamerCountRepositoryTest



UiData Repository Integration Test by NUnit
NUnit的Integration Test測試UiDataRepository



T052_01_NUnit_OneTimeSetUp_OneTimeTearDown
T052_02_IntegrationTestUiDataNUnitRepository_VmAreaRepositoryTest
T052_03_IntegrationTestUiDataNUnitRepository_VmGamerDetailRepositoryTest
T052_04_IntegrationTestUiDataNUnitRepository_VmGamerRepositoryTest
T052_05_IntegrationTestUiDataNUnitRepository_VmGamerSkillRepositoryTest
T052_06_IntegrationTestUiDataNUnitRepository_VmMagicRepositoryTest
T052_07_IntegrationTestUiDataNUnitRepository_VmSkillRepositoryTest
T052_08_IntegrationTestUiDataNUnitRepository_VmTeamRepositoryTest
----------------------
Tutorial 52講義: IntegrationTestUiDataNUnitRepository的VmEntityRepository
Tutorial 52-01:  NUnit的OneTimeSetUp和OneTimeTearDown
Tutorial 52-02: 理解IntegrationTestUiDataNUnitRepository的VmAreaRepositoryTest
Tutorial 52-03: 理解IntegrationTestUiDataNUnitRepository的VmGamerDetailRepositoryTest
Tutorial 52-04: 理解IntegrationTestUiDataNUnitRepository的VmGamerRepositoryTest
Tutorial 52-05: 理解IntegrationTestUiDataNUnitRepository的VmGamerSkillRepositoryTest
Tutorial 52-06: 理解IntegrationTestUiDataNUnitRepository的VmMagicRepositoryTest
Tutorial 52-07: 理解IntegrationTestUiDataNUnitRepository的VmSkillRepositoryTest
Tutorial 52-08: 理解IntegrationTestUiDataNUnitRepository的VmTeamRepositoryTest




T053_01_IntegrationTestUiDataNUnitRepository_VmVwGamerAndDetailAndTeamAndAreaAndMagicRepositoryTest
T053_02_IntegrationTestUiDataNUnitRepository_VmVwGamerAndDetailAndTeamAndAreaAndSkillRepositoryTest
T053_03_IntegrationTestUiDataNUnitRepository_VmVwGamerAndDetailAndTeamAndAreaRepositoryTest
T053_04_IntegrationTestUiDataNUnitRepository_VmVwGamerSkillCountRepositoryTest
T053_05_IntegrationTestUiDataNUnitRepository_VmVwTeamAndGamerCountRepositoryTest
----------------------
Tutorial 53講義: IntegrationTestUiDataNUnitRepository的VmViewRepository
Tutorial 53-01: 理解IntegrationTestUiDataNUnitRepository的VmVwGamerAndDetailAndTeamAndAreaAndMagicRepositoryTest
Tutorial 53-02: 理解IntegrationTestUiDataNUnitRepository的VmVwGamerAndDetailAndTeamAndAreaAndSkillRepositoryTest
Tutorial 53-03: 理解IntegrationTestUiDataNUnitRepository的VmVwGamerAndDetailAndTeamAndAreaRepositoryTest
Tutorial 53-04: 理解IntegrationTestUiDataNUnitRepository的VmVwGamerSkillCountRepositoryTest
Tutorial 53-05: 理解IntegrationTestUiDataNUnitRepository的VmVwTeamAndGamerCountRepositoryTest



T054_01_IntegrationTestUiDataNUnitRepository_VmSpGamerDetailTest
T054_02_IntegrationTestUiDataNUnitRepository_VmSpGamerMagicTest
T054_03_IntegrationTestUiDataNUnitRepository_VmSpGamerSkillTest
T054_04_IntegrationTestUiDataNUnitRepository_VmSpOutputGamerCountByGenderTest
T054_05_IntegrationTestUiDataNUnitRepository_VmSpSelectGamersTest
----------------------
Tutorial 54講義: IntegrationTestUiDataNUnitRepository的VmViewRepository
Tutorial 54-01: 理解IntegrationTestUiDataNUnitRepository的VmSpGamerDetailTest
Tutorial 54-02: 理解IntegrationTestUiDataNUnitRepository的VmSpGamerMagicTest
Tutorial 54-03: 理解IntegrationTestUiDataNUnitRepository的VmSpGamerSkillTest
Tutorial 54-04: 理解IntegrationTestUiDataNUnitRepository的VmSpOutputGamerCountByGenderTest
Tutorial 54-05: 理解IntegrationTestUiDataNUnitRepository的VmSpSelectGamersTest



----------------------
Tutorial 55講義: 理解IntegrationTestUiDataNUnitRepository的VmTableValuedFunction


UiData Repository Unit Test by MSTest
MSTest的Unit Test測試UiData Repository



T056_01_MSTest_AssemblyInitialize_AssemblyCleanup
T056_02_TestUiDataMSTestRepository_VmAreaRepositoryTest
T056_03_TestUiDataMSTestRepository_VmGamerDetailRepositoryTest
T056_04_TestUiDataMSTestRepository_VmGamerRepositoryTest
T056_05_TestUiDataMSTestRepository_VmGamerSkillRepositoryTest
T056_06_TestUiDataMSTestRepository_VmMagicRepositoryTest
T056_07_TestUiDataMSTestRepository_VmSkillRepositoryTest
T056_08_TestUiDataMSTestRepository_VmTeamRepositoryTest
----------------------
Tutorial 56講義: TestUiDataMSTestRepository的VmEntityRepository
Tutorial 56-01:  MSTest的AssemblyInitialize和AssemblyCleanup
Tutorial 56-02: 理解TestUiDataMSTestRepository的VmAreaRepositoryTest
Tutorial 56-03: 理解TestUiDataMSTestRepository的VmGamerDetailRepositoryTest
Tutorial 56-04: 理解TestUiDataMSTestRepository的VmGamerRepositoryTest
Tutorial 56-05: 理解TestUiDataMSTestRepository的VmGamerSkillRepositoryTest
Tutorial 56-06: 理解TestUiDataMSTestRepository的VmMagicRepositoryTest
Tutorial 56-07: 理解TestUiDataMSTestRepository的VmSkillRepositoryTest
Tutorial 56-08: 理解TestUiDataMSTestRepository的VmTeamRepositoryTest
---------------------------------------------------
Please revise
Test測試課程
T004_CodeCoverage_TestPrivateMethod_Exception_Order_GenericTest_CommandLine copy
---------------------
T015_SortingTest
---------------------
有些"測試執行順序"的觀念這裡講的並不完全正確
觀念澄清的部分請參考"測試課程"T004,T015
請參考"課前補充單元測試冷門知識"



T057_01_TestUiDataMSTestRepository_VmVwGamerAndDetailAndTeamAndAreaAndMagicRepositoryTest
T057_02_TestUiDataMSTestRepository_VmVwGamerAndDetailAndTeamAndAreaAndSkillRepositoryTest
T057_03_TestUiDataMSTestRepository_VmVwGamerAndDetailAndTeamAndAreaRepositoryTest
T057_04_TestUiDataMSTestRepository_VmVwGamerSkillCountRepositoryTest
T057_05_TestUiDataMSTestRepository_VmVwTeamAndGamerCountRepositoryTest
----------------------
Tutorial 57講義: TestUiDataMSTestRepository的VmViewRepository
Tutorial 57-01: 理解TestUiDataMSTestRepository的VmVwGamerAndDetailAndTeamAndAreaAndMagicRepositoryTest
Tutorial 57-02: 理解TestUiDataMSTestRepository的VmVwGamerAndDetailAndTeamAndAreaAndSkillRepositoryTest
Tutorial 57-03: 理解TestUiDataMSTestRepository的VmVwGamerAndDetailAndTeamAndAreaRepositoryTest
Tutorial 57-04: 理解TestUiDataMSTestRepository的VmVwGamerSkillCountRepositoryTest
Tutorial 57-05: 理解TestUiDataMSTestRepository的VmVwTeamAndGamerCountRepositoryTest



UiData Repository Integration Test by MSTest
MSTest的Integration Test測試UiData Repository



T058_01_MSTest_AssemblyInitialize_AssemblyCleanup
T058_02_IntegrationTestUiDataMSTestRepository_VmAreaRepositoryTest
T058_03_IntegrationTestUiDataMSTestRepository_VmGamerDetailRepositoryTest
T058_04_IntegrationTestUiDataMSTestRepository_VmGamerRepositoryTest
T058_05_IntegrationTestUiDataMSTestRepository_VmGamerSkillRepositoryTest
T058_06_IntegrationTestUiDataMSTestRepository_VmMagicRepositoryTest
T058_07_IntegrationTestUiDataMSTestRepository_VmSkillRepositoryTest
T058_08_IntegrationTestUiDataMSTestRepository_VmTeamRepositoryTest
----------------------
Tutorial 58講義: IntegrationTestUiDataMSTestRepository的VmEntityRepository
Tutorial 58-01:  MSTest的AssemblyInitialize和AssemblyCleanup
Tutorial 58-02: 理解IntegrationTestUiDataMSTestRepository的VmAreaRepositoryTest
Tutorial 58-03: 理解IntegrationTestUiDataMSTestRepository的VmGamerDetailRepositoryTest
Tutorial 58-04: 理解IntegrationTestUiDataMSTestRepository的VmGamerRepositoryTest
Tutorial 58-05: 理解IntegrationTestUiDataMSTestRepository的VmGamerSkillRepositoryTest
Tutorial 58-06: 理解IntegrationTestUiDataMSTestRepository的VmMagicRepositoryTest
Tutorial 58-07: 理解IntegrationTestUiDataMSTestRepository的VmSkillRepositoryTest
Tutorial 58-08: 理解IntegrationTestUiDataMSTestRepository的VmTeamRepositoryTest




T059_01_IntegrationTestUiDataMSTestRepository_VmVwGamerAndDetailAndTeamAndAreaAndMagicRepositoryTest
T059_02_IntegrationTestUiDataMSTestRepository_VmVwGamerAndDetailAndTeamAndAreaAndSkillRepositoryTest
T059_03_IntegrationTestUiDataMSTestRepository_VmVwGamerAndDetailAndTeamAndAreaRepositoryTest
T059_04_IntegrationTestUiDataMSTestRepository_VmVwGamerSkillCountRepositoryTest
T059_05_IntegrationTestUiDataMSTestRepository_VmVwTeamAndGamerCountRepositoryTest
----------------------
Tutorial 59講義: IntegrationTestUiDataMSTestRepository的VmViewRepository
Tutorial 59-01: 理解IntegrationTestUiDataMSTestRepository的VmVwGamerAndDetailAndTeamAndAreaAndMagicRepositoryTest
Tutorial 59-02: 理解IntegrationTestUiDataMSTestRepository的VmVwGamerAndDetailAndTeamAndAreaAndSkillRepositoryTest
Tutorial 59-03: 理解IntegrationTestUiDataMSTestRepository的VmVwGamerAndDetailAndTeamAndAreaRepositoryTest
Tutorial 59-04: 理解IntegrationTestUiDataMSTestRepository的VmVwGamerSkillCountRepositoryTest
Tutorial 59-05: 理解IntegrationTestUiDataMSTestRepository的VmVwTeamAndGamerCountRepositoryTest




T060_01_IntegrationTestUiDataMSTestRepository_VmSpGamerDetailTest
T060_02_IntegrationTestUiDataMSTestRepository_VmSpGamerMagicTest
T060_03_IntegrationTestUiDataMSTestRepository_VmSpGamerSkillTest
T060_04_IntegrationTestUiDataMSTestRepository_VmSpOutputGamerCountByGenderTest
T060_05_IntegrationTestUiDataMSTestRepository_VmSpSelectGamersTest
----------------------
Tutorial 60講義: IntegrationTestUiDataMSTestRepository的VmViewRepository
Tutorial 60-01: 理解IntegrationTestUiDataMSTestRepository的VmSpGamerDetailTest
Tutorial 60-02: 理解IntegrationTestUiDataMSTestRepository的VmSpGamerMagicTest
Tutorial 60-03: 理解IntegrationTestUiDataMSTestRepository的VmSpGamerSkillTest
Tutorial 60-04: 理解IntegrationTestUiDataMSTestRepository的VmSpOutputGamerCountByGenderTest
Tutorial 60-05: 理解IntegrationTestUiDataMSTestRepository的VmSpSelectGamersTest



----------------------
Tutorial 61講義: IntegrationTestUiDataMSTestRepository的VmTableValuedFunction


UiMVC


T062_01_MVC_AutoGenerateControllerAndView
T062_02_MVC_MoreSettings
T062_03_MVC_ErrorHandling
T062_04_MVC_CustomAttribute
T062_05_MVC_Validation_DateFormat
T062_06_MVC_Validation_RegularExpression
----------------------
Tutorial 62講義: 實作MVC的準備動作
Tutorial 62-01: MVC先自動生成Controller和View
Tutorial 62-02: MVC更多的基本設定
Tutorial 62-03: MVC的Error Handling
Tutorial 62-04: MVC的自訂Attribute
Tutorial 62-05: MVC的Validation解決DateFormat
Tutorial 62-06: MVC的Validation解決RegularExpression



----------------------
Tutorial 63講義: 實作UiMVC的AreaController



----------------------
Tutorial 64講義: 實作UiMVC的TeamController 



----------------------
Tutorial 65講義: 實作UiMVC的MagicController



----------------------
Tutorial 66講義: 實作UiMVC的SkillController



T067_01_MVC_UiMVC_Layout
T067_02_MVC_UiMVC_GamerEmail
T067_03_MVC_UiMVC_GamerModel_AutoMapper
T067_04_MVC_UiMVC_GamerController
T067_05_MVC_UiMVC_Gamer_Views
Video
T067_04And05_01_UiMVC_GamerController_Index
T067_04And05_02_UiMVC_GamerController_Detail
T067_04And05_03_UiMVC_GamerController_Create
T067_04And05_04_UiMVC_GamerController_Update
T067_04And05_05_UiMVC_GamerController_Delete
----------------------
Tutorial 67講義: UiMVC的GamerController
Tutorial 67-01: UiMVC的_Layout
Tutorial 67-02: UiMVC的GamerEmail
Tutorial 67-03: UiMVC的GamerModel和AutoMapper
Tutorial 67-04: UiMVC的GamerController
Tutorial 67-05: UiMVC的Gamer的Views
Video
Tutorial 67-04And05-01: UiMVC的GamerController和Index
Tutorial 67-04And05-02: UiMVC的GamerController和Detail
Tutorial 67-04And05-03: UiMVC的GamerController和Create
Tutorial 67-04And05-04: UiMVC的GamerController和Update
Tutorial 67-04And05-05: UiMVC的GamerController和Delete




----------------------
Tutorial 68講義: UiMVC的GamerSkill



----------------------
Tutorial 69講義: UiMVC的GamerMagic



----------------------
Tutorial 70講義: UiMVC的Gamer的Paging



----------------------
Tutorial 71講義: UiMVC的Gamer的Sorting



----------------------
Tutorial 72講義: UiMVC的Gamer的DeleteMultiple



----------------------
Tutorial 73講義: UiMVC的Gamer的CustomizeCacheAttribute



----------------------
Tutorial 74講義: UiMVC的MockUpData範例,Weapon
----------------------
Please revise
A EntityFrameworkE01to03課程的
T037_21_MVC_MockUpData



----------------------
Tutorial 75講義: UiMVC的Gamer Index的DeleteOutPutCache
---------------------
Please Revise
T073_UiMVC_CustomizeCacheAttribute



師資介紹

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