Record Number in Entity

avidan · December 26th, 2010, 12:10 PM

Hello
How do I get the record number in an entity?
Thanks.
Alex

Imar · December 28th, 2010, 11:34 AM

Hi there,

You may want to read this: http://www.catb.org/~esr/faqs/smart-questions.html to get some inspiration on asking smart questions that result in the answers you're after.

Based on your current question, I can come up with a least 17 different follow up questions to give me some context. That's a bit too much for me now.

However, feel free to elaborate on what it is you're asking, and I'll be happy to provide you with an answer.

Cheers,

Imar

avidan · December 29th, 2010, 04:03 AM

Hi Imar
Thanks for the link.
I think the question is really clear. And the answer (I found myself after fiddling around with the Help and Googling) is
Dim count = (From r In myentity.tables).Count

The point is that I thought after (page 559)

Unsing myEntities as new PlanetWorxEntities

avidan · December 29th, 2010, 04:05 AM

Hi Imar
Thanks for the link.
I think the question is really clear. And the answer (I found myself after fiddling around with the Help and Googling) is
Dim count = (From r In myentity.tables).Count

The point is that I thought after (page 559)

Unsing myEntities as new PlanetWorxEntities
Dim myReview as Review

I can get the number of records doing

dim x=myreview.count

But I was wrong.

Somehow in asp.net everything is much less intuitive than in VB6.

Regards
Alex

Imar · December 29th, 2010, 06:52 AM

Quote:

I think the question is really clear

I disagree. Now I understand you want the number of records, rather than the record's number (such as an ID). The question may be clear to you but that's hardly relevant. It has to be clear to your audience (me, and other visitors to this forum) or we won't be able to help. I had no idea what you we're asking the first time so I couldn't help you.

With regard to your code:

Code:

Dim myReview as Review
Dim x = myReview.Count()

This won't work, as myReview is not a collection, but a single type. As such it has no Count method.

Hope this helps,

Imar