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.

工具Tools

LLBLGen ProLLBLGen Pro

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.

網站website

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.

網站website

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

Entity Framework 視覺效果編輯器Entity Framework Visual Editor

這個 Visual Studio 2017 延伸模組增添了 ORM 設計工具,適用於 Entity Framework 6、Core 2.0 及 Core 2.1 類別的視覺設計。A Visual Studio 2017 extension that adds an ORM designer for visual design of Entity Framework 6, Core 2.0 and Core 2.1 classes. 程式碼會使用 T4 範本來產生,因此能夠完全自訂,以滿足各種需求。Code is generated using T4 templates so can be completely customized to suit any needs. 繼承、單向及雙向關聯均有支援,列舉亦然,還能夠對類別進行色彩編碼以及新增文字區塊,以說明設計中可能較不易懂的部分。Inheritance, unidirectional and bidirectional associations are all supported, as are enumerations and the ability to color-code your classes and add text blocks to explain potentially arcane parts of your design.

Marketplace (英文)Marketplace

延伸模組Extensions

Microsoft.EntityFrameworkCore.AutoHistoryMicrosoft.EntityFrameworkCore.AutoHistory

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

GitHub 存放庫GitHub repository

Microsoft.EntityFrameworkCore.DynamicLinqMicrosoft.EntityFrameworkCore.DynamicLinq

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

GitHub 存放庫GitHub repository

EFCore.PracticesEFCore.Practices

嘗試在支援測試的 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

EFSecondLevelCache.CoreEFSecondLevelCache.Core

第二個層級快取程式庫。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

Detached.EntityFrameworkDetached.EntityFramework

載入並儲存整個已中斷連結的實體圖表 (具備子實體與清單的實體)。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

EntityFrameworkCore.PrimaryKeyEntityFrameworkCore.PrimaryKey

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

GitHub 存放庫GitHub repository

EntityFrameworkCore.RxEntityFrameworkCore.Rx

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

GitHub 存放庫GitHub repository

EntityFrameworkCore.TriggersEntityFrameworkCore.Triggers

為您的實體新增插入、更新及刪除事件的觸發程序。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

EntityFrameworkCore.TypedOriginalValuesEntityFrameworkCore.TypedOriginalValues

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

GitHub 存放庫GitHub repository

GecoGeco

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.EntityFrameworkCoreLinqKit.Microsoft.EntityFrameworkCore

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.EntityFrameworkCoreNeinLinq.EntityFrameworkCore

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.UnitOfWorkMicrosoft.EntityFrameworkCore.UnitOfWork

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

GitHub 存放庫GitHub repository

EntityFramework.LazyLoadingEntityFramework.LazyLoading

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

GitHub 存放庫GitHub repository

EFCore.BulkExtensionsEFCore.BulkExtensions

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

GitHub 存放庫GitHub repository

Bricelam.EntityFrameworkCore.PluralizerBricelam.EntityFrameworkCore.Pluralizer

新增設計階段複數表示到 EF Core。Adds design-time pluralization to EF Core.

GitHub 存放庫GitHub repository