Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Migrations: SQL Server Filtered Indexes #5817

Closed
MarcoLoetscher opened this issue Jun 20, 2016 · 1 comment
Closed

Migrations: SQL Server Filtered Indexes #5817

MarcoLoetscher opened this issue Jun 20, 2016 · 1 comment
Labels
closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. good first issue This issue should be relatively straightforward to fix. help wanted This issue involves technologies where we are not experts. Expert help would be appreciated. type-enhancement
Milestone
2.0.0

Comments

@MarcoLoetscher
Copy link

For indexes on SQL Server, it should be possible to set a filter might as string or lamda expression:
modelBuilder.Entity<Blog>().HasIndex(b => b.Url, "[Url] IS NOT NULL AND [IsActive] = 1");
or
modelBuilder.Entity<Blog>().HasIndex(b => b.Url, b => b.Url != null && b.IsActive == 1);
@MarcoLoetscher MarcoLoetscher mentioned this issue Jun 20, 2016
Closed
@rowanmiller rowanmiller added this to the Backlog milestone Jun 20, 2016
@rowanmiller rowanmiller added the help wanted This issue involves technologies where we are not experts. Expert help would be appreciated. label Jun 20, 2016
laskoviymishka added a commit to laskoviymishka/EntityFramework that referenced this issue Oct 26, 2016
@laskoviymishka
feat(Migrations): SQL Server Filterable indexes.
434cfc6 
Fixed dotnet#5817
@laskoviymishka laskoviymishka mentioned this issue Oct 26, 2016
Merged
4 tasks
laskoviymishka added a commit to laskoviymishka/EntityFramework that referenced this issue Oct 27, 2016
@laskoviymishka
feat(Migrations): SQL Server Filterable indexes.
548c9a9 
Fixed dotnet#5817
laskoviymishka added a commit to laskoviymishka/EntityFramework that referenced this issue Oct 29, 2016
@laskoviymishka
feat(Migrations): SQL Server Filterable indexes.
2e0498a 
Fixed dotnet#5817
@AndriySvyryd AndriySvyryd modified the milestones: 1.2.0, Backlog Oct 29, 2016
@AndriySvyryd
Copy link
Member

Fixed in 2e0498a by @laskoviymishka

@AndriySvyryd AndriySvyryd added the closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. label Oct 29, 2016
smitpatel pushed a commit that referenced this issue Nov 8, 2016
@laskoviymishka @smitpatel
feat(Migrations): SQL Server Filterable indexes.
9bd895b 
Fixed #5817
@roji roji mentioned this issue Nov 21, 2016
Closed
@smitpatel smitpatel mentioned this issue Jul 12, 2017
Closed
@smitpatel smitpatel mentioned this issue Apr 10, 2019
Closed
@bricelam bricelam added the good first issue This issue should be relatively straightforward to fix. label May 31, 2019
@ajcvickers ajcvickers modified the milestones: 2.0.0-preview1, 2.0.0 Oct 15, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. good first issue This issue should be relatively straightforward to fix. help wanted This issue involves technologies where we are not experts. Expert help would be appreciated. type-enhancement
Projects
None yet
Milestone
2.0.0
Development

No branches or pull requests
5 participants
@bricelam @ajcvickers @rowanmiller @AndriySvyryd @MarcoLoetscher