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

[divega]

• Spatial: Not needed anymore
  • Link to workarounds for missing EF6 features article
• 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.

[Dzivo]

Any news on this ?

[glautrou]

Hi @divega ,

• Temporal tables:

  • AS OF, FROM TO, BETWEEN AND, CONTAINED IN, ALL in FromSql

I wrote the EfCoreTemporalTable library that automatically generates FromSql from LINQ queries with associated documentation, which is the goal of the task you mentionned.

However EF Core 6.0 milestone should natively handle temporal tables, let me know if you need my help about this soon outdated feature in EF docs and what can I do.

[ErikEJ]

@glautrou Add it to the Tools page in Docs