How to use EF .SqlQuery expression in EFCore?

.net .net-core c# entity-framework entity-framework-core

Question

I'm refactoring a code and I have this question.

public class MovimentoManualListRepository : RepositoryBase<MovimentoManualList>, IMovimentoManualListRepository
{
    ConsultarContext _context;
    public MovimentoManualListRepository(ConsultarContext context) : base(context)
    {
        _context = context;
    }

    public List<MovimentoManualList> Listar()
    {
        return _context.Database
            .SqlQuery<MovimentoManualList>("ListarMovimentacao")
            .ToList();
    }
}

I get an error:

Severity Code Description Project File Line Suppression State Error CS1061 'DatabaseFacade' does not contain a definition for 'SqlQuery' and no accessible extension method 'SqlQuery' accepting a first argument of type 'DatabaseFacade' could be found (are you missing a using directive or an assembly reference?)

1
0
10/20/2019 6:20:11 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Do you mean FromSqlRaw.?

Basic raw SQL queries

You can use the FromSqlRaw extension method to begin a LINQ query based on > a raw SQL query. FromSqlRaw can only be used on query roots, that is directly on the DbSet<>.

var blogs = context.Blogs
   .FromSqlRaw("SELECT * FROM dbo.Blogs")
   .ToList();

The following executes a stored procedure 

var blogs = context.Blogs
    .FromSqlRaw("EXECUTE dbo.GetMostPopularBlogs")
    .ToList();

Please note that:

  • it can be mixed and matched it with Linq queries
  • there are limitations

Please see Raw SQL Queries.

1
10/20/2019 6:20:31 AM

Related Questions

EF SqlQuery with navigation properties

I want call sp in t-sql from EF 6. At the same time i want load data to navigation property. On sql server side my SP Joins 2 table and returns. But EF side dont bind navigation properties....My query code loads car data but when i want reach Engine.Name it comes null. How can i fill it ?...//query code _context.Cars.SqlQuery("select * from Car joi...
c# entity-framework entity-framework-6 navigation-properties sql-server
asked by user1924375

How can I Include child data using SqlQuery in EF 6?

I am using EF 6 in MVC and have a query like this to get all my articles and then the category that the article is listed under. This returns results:...list = db.Articles.Where(a => a.PublishDate <= DateTime.Now) .OrderByDescending(a => a.PublishDate) .Skip(page * ArticleCount) .Take(ArticleCount) .Inclu...
asp.net asp.net-mvc-5 entity-framework entity-framework-6
asked by lloydphillips

Using SqlQuery<Dictionary<string, string>> in Entity Framework 6

You can use ...SqlQuery... to directly populate an object if the object has a default constructor and property setters. The result can then be used to create a dictionary. For example:...public class QueryResult { public string A { get; set; } public string B { get; set; } } ...// the colulmn/alias names need to match property names string ...
.net c# dictionary entity-framework sql
asked by jjj

EF - SqlQuery - not have a corresponding column in the data reader with the same name

I'm using entity framework and I have this class...public partial class TipoRequisicaoSubCategoria { public TipoRequisicaoSubCategoria() { this.Formularios = new HashSet<Formulario>(); } public int Id { get; set; } public int IdTipoRequisicao { get; set; } public int IdSubcategoria { ...
.net c# entity-framework entity-framework-6 mysql
asked by Vinícius da Cruz Maia

Whats the difference between EFCore.Tools and EFCore.Tools.DotNet

There are two tools packages in NuGet for EF Core Tools...Microsoft.EntityFrameworkCore.Tools Microsoft.EntityFrameworkCore.Tools.DotNet ...The descriptions don't say much about what each does. ...Does anyone know the difference between these packages and when I should use one or the other?...From the looks of the package contents one has integrati...
entity-framework-core
asked by Not loved

EFCore The Linq Expression Could not be translated and will be evaluated locally

I am attempting to create a compiled query that can be executed on the database side. The idea is to create a reusable function across my code. But EF Core is still saying this query cannot be translated to sql....Here is the reusable ...expression...public static class DisplayFilters { public static Expression<Func<DisplayItem, bool>> isActive...
entity-framework entity-framework-core
asked by christopher clark

EF Core 2.2.1 Database.SqlQuery Method

I create a GenericRawSql on .net Core 2.2.1. I need to create a raw SQL query that will return elements of ...the given generic type.... In EntityFramework there is a method -> SqlQuery(String, Object[]). But i can't find this method in EntityFrameWorkCore 2.2.1...public class GenericRawSql<T1, T2> : IGenericRawSql<T1> where T1 : class where T2 : D...
.net-core c# ef-core-2.2 entity-framework-core
asked by mrcyborg

how to change expression DateTime in EFCore

i use EFCore to search DB....When TValue == DateTime,it not run.... /// <summary> /// 大于或等于 /// </summary> /// <param name="propertyName"></param> /// <param name="value"></param> public void GreaterThanOrEqual<TValue>(string propertyName, TValue value) { var prop = type.G...
.net-core entity-framework-core
asked by sdwdjzhy

Using an existing expression/func to build out another expression/func

If the question is how to build ...Expression<Func<TModel, bool>>... from ...Expression<Func<TModel, TProperty>>... and ...TModel... representing equal predicate, it could be done like this:...// Expression<Func<TModel, TProperty>> propertySelector // TModel model var parameter = propertySelector.Parameters[0]; var left = propertySelector.Body; var...
c# entity-framework-core expression generics lambda
asked by Ivan Stoev

Combining Linq expressions using EFCore 3.0

I have a function doing a complicated Where query on my db context and then applies another transformation passed to it:...static IQueryable<T> Query<T>(Func<IQueryable<ServicesData>, IQueryable<T>> f, string path1 = null, string path2 = null, string path3 = null, string path4 = null, string path5 = null) { try { using (var dbc = new My...
entity-framework entity-framework-core entity-framework-core-3.0
asked by kofifus

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow