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

Relational: Add EntityTypeBuilder.ToQuerySql() sugar method #17063

Closed
bricelam opened this issue Aug 9, 2019 · 3 comments · Fixed by #21831
Closed

Relational: Add EntityTypeBuilder.ToQuerySql() sugar method #17063

bricelam opened this issue Aug 9, 2019 · 3 comments · Fixed by #21831
Assignees
@smitpatel
Labels
area-query closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-enhancement
Milestone
5.0.0

Comments

@bricelam
Copy link
Contributor

bricelam commented Aug 9, 2019 

// Make this...
modelBuilder.Entity<Blog>().ToQuerySql("SELECT * FROM Blogs");

// ...sugar for this
modelBuilder.Entity<Blog>().ToQuery(() => db.Blogs.FromSqlRaw("SELECT * FROM Blogs");
@smitpatel smitpatel changed the title Relatinal: Add EntityTypeBuilder.ToQuerySql() sugar method Relational: Add EntityTypeBuilder.ToQuerySql() sugar method Aug 9, 2019
@ajcvickers ajcvickers added this to the Backlog milestone Aug 12, 2019
@divega divega mentioned this issue Aug 19, 2019
Closed
@smitpatel smitpatel mentioned this issue Mar 10, 2020
Closed
@AndriySvyryd AndriySvyryd mentioned this issue Mar 14, 2020
Closed
@smitpatel smitpatel self-assigned this Mar 31, 2020
@smitpatel smitpatel modified the milestones: Backlog, 5.0.0 Mar 31, 2020
@smitpatel
Copy link
Member

Pulling this in 5.0 so that we can provide easier work-around for #18903

@smitpatel
Copy link
Member

@bricelam - Did you want this to also take parameters from context?

@bricelam
Copy link
Contributor Author

Haven’t thought about it. Nice to have, but I think it’s OK to scope out all parameters for now

@AndriySvyryd AndriySvyryd mentioned this issue Jul 14, 2020
Open
AndriySvyryd added a commit that referenced this issue Jul 18, 2020
@AndriySvyryd
Allow mapping entity types to SQL queries
c1a10f1 
Fixes #13358
Part of #17063
@AndriySvyryd AndriySvyryd mentioned this issue Jul 18, 2020
Merged
AndriySvyryd added a commit that referenced this issue Jul 20, 2020
@AndriySvyryd
Allow mapping entity types to SQL queries
ad4ccc7 
Fixes #13358
Part of #17063
AndriySvyryd added a commit that referenced this issue Jul 20, 2020
@AndriySvyryd
Allow mapping entity types to SQL queries
13e69ca 
Fixes #13358
Part of #17063
@smitpatel smitpatel added the closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. label Jul 28, 2020
smitpatel added a commit that referenced this issue Jul 28, 2020
@smitpatel
Query: Support ToQuerySql
1d80a91 
Resolves #17063
smitpatel added a commit that referenced this issue Jul 28, 2020
@smitpatel
Query: Support ToQuerySql
3e25e9b 
Resolves #17063
@smitpatel smitpatel mentioned this issue Jul 28, 2020
Merged
smitpatel added a commit that referenced this issue Jul 28, 2020
@smitpatel
Query: Support ToQuerySql
3201936 
Resolves #17063
@ghost ghost closed this as completed in #21831 Jul 29, 2020
ghost pushed a commit that referenced this issue Jul 29, 2020
@smitpatel
Query: Support ToQuerySql (#21831)
e57ec85 
Resolves #17063
@ajcvickers ajcvickers modified the milestones: 5.0.0, 5.0.0-rc1 Aug 14, 2020
@ajcvickers ajcvickers modified the milestones: 5.0.0-rc1, 5.0.0 Nov 7, 2020
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@smitpatel smitpatel

Labels
area-query closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-enhancement
Projects
None yet
Milestone
5.0.0
Development

Successfully merging a pull request may close this issue.

Query: Support ToQuerySql dotnet/efcore
3 participants
@bricelam @ajcvickers @smitpatel