SqlQuery missing from EF7... please add

[giancarloa]

Hi... in EF6 we could query non entity projections with raw SQL using Database.SqlQuery... that was REALLY cool... but I am trying to migrate to EF7 and don't see this method... I looked around and it appears people are saying to use FromSql instead but that's an extension method off of a DbSet... in my case I don't have a DbSet for the type in question because it's not an entity... it's just a plain old projection... pretty please consider bringing SqlQuery to EF7... thank you

[rowanmiller]

Duplicate of #1862

[badyalsk]

In Entity Framework Core, we are not able to return some complex type(columns from different entities) from Stored Procedure using RAW SQL. It alway returns Entity in DbSet. When we are expecting to add support for this functionality in EF Core. What are the alternatives?

[doggy8088]

@badyalsk The alternative should be Query Types in EF Core 2.1.