# Include record count on read or write

**URL:** <https://discuss.elastic.co/t/include-record-count-on-read-or-write/189110>\
**Category:** APM\
**Tags:** dotnet\
**Created:** [July 5, 2019, 1:23pm UTC](https://discuss.elastic.co/t/include-record-count-on-read-or-write/189110 "2019-07-05T13:23:06Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rainbowkid11](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rainbowkid11/32/45796_2.png) [@rainbowkid11](https://discuss.elastic.co/u/rainbowkid11)\
**Post date:** [July 5, 2019, 1:23pm UTC](https://discuss.elastic.co/t/include-record-count-on-read-or-write/189110/1 "2019-07-05T13:23:06Z")

</div>

I am testing out specifically the .Net APM. In general for all the APM's I do not see the rows affected in a sql query included on the APM UI.

Is there a way to get this information with .Net APM?

Currently, I don't think this information is included. In general it would be nice to see rows affected to see easily spot bad queries and such.

---

<div class="post-metadata">

**Author:** ![Sergey\_Kleyman](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sergey_kleyman/32/39333_2.png) [@Sergey\_Kleyman](https://discuss.elastic.co/u/Sergey_Kleyman)\
**Post date:** [July 5, 2019, 1:51pm UTC](https://discuss.elastic.co/t/include-record-count-on-read-or-write/189110/2 "2019-07-05T13:51:40Z")

</div>

Hi @rainbowkid11 .

What exactly do you mean by "the rows affected" - do you refer to SQL queries that completed with an error?

---

<div class="post-metadata">

**Author:** ![rainbowkid11](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rainbowkid11/32/45796_2.png) [@rainbowkid11](https://discuss.elastic.co/u/rainbowkid11)\
**Post date:** [July 5, 2019, 2:05pm UTC](https://discuss.elastic.co/t/include-record-count-on-read-or-write/189110/3 "2019-07-05T14:05:31Z")

</div>

@Sergey_Kleyman Thanks for the quick response.

What I meant was if you run something like `Select UserId from Users Where UserStatus = 'Live'` through EF Core, can the APM tell you that 1000 records came back from call?

---

<div class="post-metadata">

**Author:** ![Sergey\_Kleyman](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sergey_kleyman/32/39333_2.png) [@Sergey\_Kleyman](https://discuss.elastic.co/u/Sergey_Kleyman)\
**Post date:** [July 5, 2019, 2:32pm UTC](https://discuss.elastic.co/t/include-record-count-on-read-or-write/189110/4 "2019-07-05T14:32:02Z")

</div>

I see. Unfortunately we don't have support for this use case at the moment - I've opened an issue, which you can track - [https://github.com/elastic/apm-agent-dotnet/issues/360](https://github.com/elastic/apm-agent-dotnet/issues/360).

---

<div class="post-metadata">

**Author:** ![rainbowkid11](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rainbowkid11/32/45796_2.png) [@rainbowkid11](https://discuss.elastic.co/u/rainbowkid11)\
**Post date:** [July 7, 2019, 1:47pm UTC](https://discuss.elastic.co/t/include-record-count-on-read-or-write/189110/5 "2019-07-07T13:47:58Z")

</div>

@Sergey_Kleyman Thanks for your help!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 28, 2019, 9:47am UTC](https://discuss.elastic.co/t/include-record-count-on-read-or-write/189110/6 "2019-07-28T09:47:59Z")

</div>

This topic was automatically closed 20 days after the last reply. New replies are no longer allowed.