Support For Columstore Index Storage

Open
#15,733 15 comments 43 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
5/5
Estimated time
Over a week
Newbie friendliness
20/100
Issue type
Feature
Clarity
Needs clarification
Activity status
Stale
Tech stack
csharp, sql
Domain
databases

Research direction

Start by reviewing the SQL Server provider's index and migration support, then compare it with the Columnstore Index behavior described in the linked SQL Server documentation. Determine how columnstore indexes would need to be represented in the model and migrations; done means the provider can support rolling these indexes without leaving the model unaware.

Written by the indexing model from the issue text.

Description

area-migrations customer-reported

Currently it appears the only way I can roll Columnstore Indexes (https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview?view=sql-server-2017) is to basically write a ton of SQL during a migration and leave the database in a state that the model is not really aware about.

Is there any planned support for these unique types of indexes for the SQL Server provider of EF Core?

Dominant language
C#
Stars
14.8k
Forks
3.4k
Avg merge
2d 5h
Merged PRs (30d)
134

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from dotnet/efcore

All issues in dotnet/efcore

Similar issues

More C# issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.