How to get count with using COUNT_BIG() from Entity Framework

Question

I want to call COUNT_BIG function over my table. This table returns a lot of data (bigint). I'm finding a way how can I call this function from EF. Until now I have a following code:

var qStr = @"SELECT COUNT_BIG() FROM Attachment"; 
var attachmentCountQuery = context.CreateQuery<long>(qStr);

But I don't know how to get the long variable from this query?

Or is there exists another way how to get the total count of the records from table, where count is bigint?

thanks

aF. · Accepted Answer · 2011-11-22 09:14:16Z

1

Seeing here you are missing some code on that select.

You need to specify which field (expression) to count.

Something like:

var qStr = @"SELECT COUNT_BIG(column_from_Attachment_table) FROM Attachment"; 
var attachmentCountQuery = context.CreateQuery<long>(qStr);

answered Nov 22, 2011 at 9:14

aF.

67k45 gold badges141 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get count with using COUNT_BIG() from Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related