{"id":39,"date":"2011-10-21T14:09:00","date_gmt":"2011-10-21T14:09:00","guid":{"rendered":"https:\/\/wdev-blog.azurewebsites.net\/index.php\/2011\/10\/21\/linqtosql-count\/"},"modified":"2011-10-21T14:09:00","modified_gmt":"2011-10-21T14:09:00","slug":"linqtosql-count","status":"publish","type":"post","link":"http:\/\/panahy.nl\/index.php\/2011\/10\/21\/linqtosql-count\/","title":{"rendered":"LinqToSql Count"},"content":{"rendered":"

You can pass the results of a linq query to the next statement like this one<\/p>\n

<\/p>\n
var q = context.Products<\/span><\/div>\n
                .Where(p => p.ProductName.StartsWith(“A”))<\/span><\/div>\n
                .Count();<\/span><\/div>\n<\/div>\n
<\/div>\n
and that should provide the count of products with names starting with “A”. <\/div>\n
Further it would make no difference (performance wise) to skip theWhere statement and simply call the Count with filter as parameter, like:<\/div>\n
<\/div>\n
\n
var q = context.Products<\/span><\/div>\n
                .Count(p => p.ProductName.StartsWith(“B”));<\/span><\/div>\n<\/div>\n
<\/div>\n
or in another syntax like:<\/div>\n
<\/div>\n
\n
    q = (from p in context.Products<\/span><\/div>\n
         where p.ProductName.StartsWith(“C”)<\/span><\/div>\n
         select true).Count();<\/span><\/div>\n<\/div>\n
<\/div>\n
So, I did put a tracing into the Context.Log to see what it goes to the SQL-Server. I’ve got the following for all three cases:<\/div>\n
<\/div>\n
\n
SELECT COUNT(*) AS [value]<\/span><\/div>\n
FROM [dbo].[Products] AS [t0]<\/span><\/div>\n
WHERE [t0].[ProductName] LIKE @p0<\/span><\/div>\n
— @p0: Input NVarChar (Size = 4000; Prec = 0; Scale = 0) [A%]<\/span><\/b><\/div>\n
— Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 4.0.30319.1<\/span><\/div>\n
<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

You can pass the results of a linq query to the next statement like this one var q = context.Products                 .Where(p => p.ProductName.StartsWith(“A”))                 .Count(); and that should provide the count of products with names starting with “A”.  Further it … Continue reading “LinqToSql Count”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[33],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"post-thumbnail":false},"uagb_author_info":{"display_name":"Pouya Panahy","author_link":"http:\/\/panahy.nl\/index.php\/author\/pouya\/"},"uagb_comment_info":0,"uagb_excerpt":"You can pass the results of a linq query to the next statement like this one var q = context.Products                 .Where(p => p.ProductName.StartsWith(“A”))                 .Count(); and that should provide the count of products with names starting with “A”.  Further it…","_links":{"self":[{"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/posts\/39"}],"collection":[{"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/comments?post=39"}],"version-history":[{"count":0,"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/posts\/39\/revisions"}],"wp:attachment":[{"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/media?parent=39"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/categories?post=39"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/tags?post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}