dotnet / dotnet/efcore

Support specifying durability for Memory Optimized tables

Open
#34,332 2 comments 1 reaction 0 assignees View on GitHub
area-migrations area-model-building area-sqlserver customer-reported
Dominant language
C#
Stars
14.8k
Forks
3.4k
PR merge metrics
PR metrics pending

Description

When adding a memory optimized table, the database is also configured as memory optimized. I need to use a table DURABILITY of SCHEMA_ONLY, but that option is not exposed through EFC (#6405). Durability can only be set when the table is created. This will require a custom migration for the table which would then also require custom migration to change the database configuration.

**Is there any configuration I can use to set the database to allow memory optimized tables without also creating a table?**

I'd prefer to use the built-in configurations for the database as that would also make the configuration visible in code.

The alternative is that I create the memory optimized table with standard durability so the database is configured, then use a custom migration to drop and recreate the table with the desired durability.

And just in case the SCHEMA_ONLY question is raised, I have an integration point with an external app that needs to have a high performance way of performing CRUD operations. No data is needed between restarts and using SCHEMA_ONLY eliminates disk I/O to further improve performance.
 

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.