Execute Custom SQL.

[GArrigotti]

In Entity Framework 6 I was able to utilize SqlQuery. I found on Stack Overflow and several documentation that the command was modified to FromSql. However, when I utilize the release candidate, the FromSql command doesn't appear though the proper depdencies are specified in the application.

[divega]

FromSql() is an extension method for DbSet<TEntity>. Are you importing the necessary namespace? In RC1 that would be Microsoft.Data.Entity.

[divega]

Correction: it is on IQueryable<T>.

[GArrigotti]

Yes, I did implement Microsoft.Data.Entity. I'll double check, I didn't attempt on a DbSet. This differs from SqlQuery, SqlQuery could be wrapped:

public TEntity GetEntityFromStoredProcedure<TEntity>(string procedure, params SqlParameter[] parameters)
{
     return this.Database.SqlQuery(..., ...);
}

Which I would of assumed would be the case FromSql for the most part. But that doesn't appear to be the case, if I have to go off a DbSet.

[divega]

Yes, FromSql() and SqlQuery() are different. We already have issues tracking the functional gap. You should be able to find them searching active issues here.

[GArrigotti]

Thank you Divega, anything I can do to potentially help?

[divega]

AFAIR the main two things that are missing are:

• Support for add-hoc mapping of arbitrary types Support for querying objects without keys #1862
• Support for passing DbParameters Support passing DbParameter instances to raw SQL APIs #3115

For the first one there is some pending design work, e.g. figure out what the API looks like and where we put it (and option is to do something similar to what we had in EF6) whether it is still composable like FromSql() or not, etc. I would suggest that if you have a strong preference you start by posting to the thread.

For the second one we are pretty much locked on just adding DbParameter as an option, but other patterns have been suggested as well.