dotnet/EntityFramework.Docs

Create article with workarounds for SQL Server features that don't have first-class support

Open

#685 建立於 2018年4月18日

在 GitHub 查看
 (3 留言) (0 反應) (0 負責人)PowerShell (1,625 star) (1,961 fork)batch import
good first issue

描述

  • Spatial: Not needed anymore
  • JSON:
    • Value converter to parse/serialize JSON
    • JSON_VALUE, JSON_QUERY and JSON_MODIFY in FromSql or function mapping
  • Temporal tables:
    • AS OF, FROM TO, BETWEEN AND, CONTAINED IN, ALL in FromSql
    • Custom SQL in migrations
  • SQL Graph:
    • MATCH in FromSql
    • custom SQL in migrations
    • Can node and edge tables be treated as normal tables?
  • Always encrypted:
    • Value converters
    • Custom SQL in migrations
    • AsEnumerable() for explicit client eval (e.g. for comparisons, LIKE, etc.)
  • Full Text Search
    • Create indexes with Sql in migrations
    • Use FreeText (and soon Contains) functions
    • Write FREETEXTTABLE and CONTAINS table query in FromSql, until we get TVF support.

貢獻者指南

技術棧
csharpsql
領域
documentation
議題類型
documentation
難度面向新貢獻者的預計實作難度，1 表示很小改動，5 表示專家級工作。
3
預計時間有經驗貢獻者完成調查、實作、測試並準備 pull request 的粗略時間範圍。
1-2 days
活動狀態議題目前的可參與程度：新鮮、活躍、陳舊、阻塞或等待維護者輸入。
stale
清晰度議題是否清楚說明預期改動、驗收標準和下一步。
clear
前置要求
Entity Framework Core knowledgeSQL Server basicsMarkdown
新手友善度1-100 的估計分數，表示該議題對首次貢獻者的友善程度。
30
研究方向
The issue outlines specific SQL Server features lacking first class support in EF Core (JSON, SQL Graph, Full Text Search, etc.). Research should focus on existing workarounds documented in other EF Core documentation or community resources. The final article should provide step by step guidance for each feature, referencing relevant EF Core API and migration techniques. Check linked discussions and any prior comments for additional context.