Entity framework raw SQL Query

by

You have to capture the results into a class with matching property names, and (at least) a parameterless constructor:

class DbResult
{
    public int ID { get; set; }
    public string NAME { get; set; }
    public string DB_FIELD { get; set; }
}

var result = _dbContext.Database.SqlQuery<DbResult>(
                 "select ID, NAME, DB_FIELD from eis_hierarchy");

More Related Contents:

  1. VB Net Class in C# [closed]
  2. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  3. A circular reference was detected while serializing an object of type ‘SubSonic.Schema .DatabaseColumn’.
  4. Ignoring a class property in Entity Framework 4.1 Code First
  5. The cast to value type ‘Int32’ failed because the materialized value is null
  6. What is the purpose of self tracking entities?
  7. Making Entity Class Closed for Changes
  8. Entity Framework/Linq EXpression converting from string to int
  9. Filter/Search using Multiple Fields – ASP.NET MVC
  10. How to convert an expression tree to a partial SQL query?
  11. EF Data Context – Async/Await & Multithreading
  12. Why would try/finally rather than a “using” statement help avoid a race condition?
  13. Retrieve an object from entityframework without ONE field
  14. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  15. DbContext discard changes without disposing
  16. Entity Framework 4: How to find the primary key?
  17. How to compare only Date without Time in DateTime types?
  18. Set database timeout in Entity Framework
  19. .Include() vs .Load() performance in EntityFramework
  20. Max return value if empty query
  21. Group by with multiple columns using lambda
  22. How to do an “in” query in entity framework?
  23. How to Specify Primary Key Name in EF-Code-First
  24. big issue in converting string to datetime using linq-to-entities
  25. Entity Framework: Duplicate Records in Many-to-Many relationship
  26. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  27. How to force LINQ Sum() to return 0 while source collection is empty
  28. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  29. How to include() nested child entity in linq
  30. LINQ Query to Convert string to datetime

Leave a Comment