EF Core 工具和延伸模組EF Core Tools & Extensions

工具和延伸模組提供 Entity Framework Core 的額外功能。Tools and extensions provide additional functionality for Entity Framework Core.


延伸模組以各種來源建置而成,且不屬於 Entity Framework Core 專案維護的一部份。Extensions are built by a variety of sources and not maintained as part of the Entity Framework Core project. 考慮使用協力廠商延伸模組時,請務必評估品質、授權、合規性、支援等,確保其符合您的需求。When considering a third party extension, be sure to evaluate quality, licensing, compatibility, support, etc. to ensure they meet your requirements.



LLBLGen Pro 是實體模型化解決方案,具備 Entity Framework 與 Entity Framework Core 的支援。LLBLGen Pro is an entity modeling solution with support for Entity Framework and Entity Framework Core. 您可加以利用來輕鬆定義實體模型,並將其對應至資料庫,優先使用資料庫或模型後,即可開始直接撰寫查詢。It lets you easily define your entity model and map it to your database, using database first or model first, so you can get started writing queries right away.


Devart Entity DeveloperDevart Entity Developer

Devart Entity 是功能強大的 ORM 設計工具,適用於 ADO.NET Entity Framework、NHibernate、LinqConnect、Telerik Data Access、LINQ 到 SQL。Entity Developer is a powerful ORM designer for ADO.NET Entity Framework, NHibernate, LinqConnect, Telerik Data Access, and LINQ to SQL. 您可使用模型優先和資料庫優先方法來設計您的 ORM 模型,並為其產生 C# 或 Visual Basic .NET 程式碼。You can use Model-First and Database-First approaches to design your ORM model and generate C# or Visual Basic .NET code for it. 其為您帶來新的 ORM 模型設計方式,這不僅提高了生產力,還有助於資料庫應用程式的開發。It introduces new approaches for designing ORM models, boosts productivity, and facilitates the development of database applications.


EF Core Power ToolsEF Core Power Tools

Visual Studio 2017+ 延伸模組。Visual Studio 2017+ extension. 您可從現有的資料庫或 SQL Server Database 專案執行 DbContext 及 POCO 類別的還原工程,並透過各種方式對 DbContext 進行視覺化及檢查。You can reverse engineer of DbContext and POCO classes from an existing database or SQL Server Database project, and visualize and inspect your DbContext in various ways.

GitHub WikiGitHub wiki



支援自動記錄資料變更歷程記錄的 Microsoft.EntityFrameworkCore 外掛程式。A plugin for Microsoft.EntityFrameworkCore to support automatically recording data changes history.

GitHub 存放庫GitHub repository


Microsoft.EntityFrameworkCore 的動態 LINQ 延伸模組,可新增非同步支援Dynamic Linq extensions for Microsoft.EntityFrameworkCore which adds Async support

GitHub 存放庫GitHub repository


嘗試在支援測試的 API 中擷取中上等級的做法 - 包括可掃描 N+1 個查詢的小型架構。Attempt to capture some good or best practices in an API that supports testing – including a small framework to scan for N+1 queries.

GitHub 存放庫GitHub repository


第二個層級快取程式庫。Second Level Caching Library. 第二個層級快取是查詢快取。Second level caching is a query cache. EF 命令的結果會存放在快取中,使相同的 EF 命令會從快取擷取其資料,而不必再次向資料庫再次執行命令。The results of EF commands will be stored in the cache, so that the same EF commands will retrieve their data from the cache rather than executing them against the database again.

GitHub 存放庫GitHub repository


載入並儲存整個已中斷連結的實體圖表 (具備子實體與清單的實體)。Loads and saves entire detached entity graphs (the entity with their child entities and lists). 此想法出自於 GraphDiffInspired by GraphDiff. 此想法同時也新增了部分外掛程式,來減輕部分工作的重複性,例如稽核與分頁。The idea is also add some plugins to simplificate some repetitive tasks, like auditing and pagination.

GitHub 存放庫GitHub repository


從任何實體將主索引鍵 (包含複合索引鍵) 擷取為字典。Retrieve the primary key (including composite keys) from any entity as a dictionary.

GitHub 存放庫GitHub repository


Entity Framework 實體之經常性可視項的被動延伸模組包裝函式。Reactive extension wrappers for hot observables of Entity Framework entities.

GitHub 存放庫GitHub repository


為您的實體新增插入、更新及刪除事件的觸發程序。Add triggers to your entities with insert, update, and delete events. 以下有三種事件,分別為:失敗前、失敗後以及失敗時。There are three events for each: before, after, and upon failure.

GitHub 存放庫GitHub repository


為您實體屬性的 OriginalValue 取得具類型的存取權。Get typed access to the OriginalValue of your entity properties. 支援簡單與複雜的屬性,但不支援瀏覽/集合。Simple and complex properties are supported, navigation/collections are not.

GitHub 存放庫GitHub repository


Geco 提供反向模型產生器,並具有複數/單數支援、以 C# 6.0 插入字串為基礎的可編輯範本,並在 .Net Core 上執行。Geco provides a Reverse Model generator with support for Pluralization/Singularization and editable templates based on C# 6.0 interpolated strings and running on .Net Core. 其也提供了種子指令碼產生器,具有 SQL 合併指令碼及指令碼執行器。It also provides an Seed script generator with SQL Merge scripts and an script runner.

Github 存放庫Github repository


LinqKit.Microsoft.EntityFrameworkCore 是一組免費的延伸模組,適用於 LINQ、SQL 及 EntityFrameworkCore 進階使用者。LinqKit.Microsoft.EntityFrameworkCore is a free set of extensions for LINQ to SQL and EntityFrameworkCore power users. 具備 Include(...) 與 IDbAsync 支援。With Include(...) and IDbAsync support.

GitHub 存放庫GitHub repository


NeinLinq.EntityFrameworkCore 為使用 LINQ 提供者提供了實用的延伸模組,例如僅支援 .NET 函式少數子集的 Entity Framework、重複使用函式、重寫查詢、甚至能使 null 不出現,還能使用可翻譯的述詞與選取器來建置動態查詢。NeinLinq.EntityFrameworkCore provides helpful extensions for using LINQ providers such as Entity Framework that support only a minor subset of .NET functions, reusing functions, rewriting queries, even making them null-safe, and building dynamic queries using translatable predicates and selectors.

GitHub 存放庫GitHub repository


Microsoft.EntityFrameworkCore 的外掛程式,可支援存放庫、工作模式的單位,以及支援分散式交易的多個資料庫。A plugin for Microsoft.EntityFrameworkCore to support repository, unit of work patterns, and multiple database with distributed transaction supported.

GitHub 存放庫GitHub repository


EF Core 1.1 的消極式載入Lazy Loading for EF Core 1.1

GitHub 存放庫GitHub repository


適用於大量作業 (插入、更新、刪除) 的 EntityFrameworkCore 延伸模組。EntityFrameworkCore extensions for Bulk operations (Insert, Update, Delete).

GitHub 存放庫GitHub repository