How to get Count from FromSql?

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

Question

I have 

dbContext.Items.FromSql("SELECT COUNT(*) 
                         FROM Items 
                         WHERE JSON_VALUE(Column, '$.json') = 'abc'")

This returns an IQueryable, I am wondering how I can return a scalar int back?

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

I have a data call in a Linq to Entities powered data access layer that is designed to make paged calls....In doing so, I need to select a subset of the data, say 50 rows, but also get the count of all matches to know how many total matches exist to be paged through....Currently, I'm doing the following:...var queryResult = DatabaseContext.Table ...
c# entity-framework entity-framework-6 linq sql-server
asked by Wesley

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

I eventually received a reply on my issue posted on the EF Core GitHub:...https://github.com/aspnet/EntityFramework/issues/5413...This issue was a bug in RC1 that is now fixed in RC2. I've migrated to RC2, and all looks good now.
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)

I am trying to get output value from the ...dbcontext... using the method ...FromSql(...).......If i execute it on SSMS, it works but not working in EF core....My SP param:... @totalItems VARCHAR(MAX) OUTPUT ...I've removed other params for readable and point out the issue. The records are coming but the ...OUTPUT... parameter is always ...null....
c# entity-framework-core linq sql sql-server
asked by Robin

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

This is a very weird problem In short...var q = (some query).Count(); ...Gives my a number and...var q = (some query).ToList().Count(); ...Gives me entirely different number......with mentioning that (some query) has two includes (joins)...is there a sane explanation for that???...EDIT: here is my query...var q = db.membership_renewals.Include(i =>...
entity-framework entity-framework-core iqueryable
asked by Mohammed Suez

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

CustomerId... is the conventional name for the Foreign Key of the one-to-many relationships introduced by the...public ICollection<Contacts> Contacts { get; set; } public ICollection<Addresses> Addresses { get; set; } ...collection navigation properties of the ...Customer... class. ...Although the related classes ...Contacts... and ...Addresses..
asp.net-core c# entity-framework entity-framework-core
asked by Ivan Stoev

Getting counts of LEFT JOINED entities via group by

Consider the following query that must return a director along with counts of movies and actors for each movie. How would one write this in LINQ using EF CORE 2.2? I need the LINQ to generate SQL that actually uses the GROUP BY with the SQL aggregates as supported in EF CORE 2.1 and forward....SELECT DirectorName, COUNT(m.MovieID), COUNT(a.ActorI...
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

I have a major problem with ...FromSql... and that's it :...I have a model like this:...public partial class model { public string name } ...I want to get some result from my procedure in database(sql serever). when I execute below code ...var sql = "EXECUTE [myprocedure] @param1 "; SqlParameter sqlParameter = new SqlParameter { Parameter...
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

I'm building my query dynamically, I have a method that receives an ...IOrderedQueryable<T>... which is optional. This code used to work perfectly with EF Core 2.2 but stopped after the migration....IQueryable<T> query; if (spec.OrderedQueryable == null) { query = DbContext.Set<T>() .FromSqlRaw($"SELECT * FROM {tableName} ...
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<>

I am mapping EF onto a legacy DB, and at the moment have to create views in the legacy DB to do that....Rather than modify the existing schema at all, I'd like to use the new ...HasNoKey... existing ...FromSql... methods to map my entities onto SQL defined within my application....i.e....protected override void OnModelCreating(ModelBuilder modelBui...
entity-framework-core
asked by Kram

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

Change the ...FromSql... to ...FromSqlRaw...dbContext.TableOne.FromSqlRaw("Some select query here")
.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