How to get Count from FromSql?

c# ef-core-2.1 entity-framework-core sql-server

Question

ZZZ_tmp
1
2
11/6/2018 9:46:29 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Try 

 var firstElement = dbContext.Items
                             .FromSql (..)
                             .ToList
                             .First();
1
11/6/2018 8:27:27 PM

Related Questions

Getting COUNT and SKIP TAKE in one operation with Linq to Entities

ZZZ_tmp
c# entity-framework entity-framework-6 linq sql-server
asked by Wesley

EF 7/Core: Getting count of records in child table

ZZZ_tmp
c# entity-framework entity-framework-core sql-server
asked by Evan Verney-Fink

Entity framework core Output parameter not working in store procedure using FromSql method (Linq)

ZZZ_tmp
c# entity-framework-core linq sql sql-server
asked by Robin

Entityframework 6.2.0 IQueryable.Count VS IQueryable.ToList().Count

ZZZ_tmp
entity-framework entity-framework-core iqueryable
asked by Mohammed Suez

The required column 'CustomerId' was not present in the results of a 'FromSql' operation

ZZZ_tmp
asp.net-core c# entity-framework entity-framework-core
asked by Ivan Stoev

Getting counts of LEFT JOINED entities via group by

ZZZ_tmp
c# ef-core-2.2 entity-framework-core linq
asked by Geekn

The required column 'id' was not present in the results of a `FromSql` operation in EFcore

ZZZ_tmp
c# entity-framework entity-framework-core linq sql-server
asked by amir133

Calling FromSql Not working on IQueryable<TEntity> after migration from Entity Framework core 2.2 to 3.0

ZZZ_tmp
c# entity-framework-core entity-framework-core-3.0
asked by Mozart Al Khateeb

Is it possible for EF Core 3.0 to use FromSql inside ModelBuilder rather than on DbSet<>

ZZZ_tmp
entity-framework-core
asked by Kram

the method 'Microsoft.EntityFrameworkCore.RelationalQueryableExtensions.FromSql' is currently not supported

ZZZ_tmp
.net asp.net-core-webapi c# entity-framework-core
asked by Farhad Zamani

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