Entity

avidan · September 9th, 2015, 11:06 AM

Hi
I would like to retrieve the number of records of a table (users) in an entity, depending on a certain result. I tried
Using myentities As New entity
If x=1 then
Dim users = (From r In myentities.users).Count 'Get number of all users
else
Dim users = (From r In myentities.users where r.name=N'Brown').Count 'Get number of users named Brown
end if
msgbox(users).

But it doesn't work, the Dim... cannot be in an if/endif
How can i solve this?
Thanks
Alex

Imar · September 9th, 2015, 02:08 PM

You can use Dim within an If statement. However, the variable is scoped to that block.

Instead, you can declare the variable outside the block and then use it inside and after:

Code:

Dim users As Integer

Using myentities As New entity
If x=1 then
      users = (From r In myentities.users).Count 'Get number of all users
else
      users = (From r In myentities.users where r.name=N'Brown').Count 'Get number of users named Brown
end if
msgbox(users)

Note that although MsgBox *seems* to appear to work in a development environment, it won't work for your web users.

Hope this helps,

Imar

avidan · September 9th, 2015, 03:06 PM

Fantastic. So simple and so clear. Learned a lot. Thanks.
Alex

avidan · September 9th, 2015, 03:29 PM

What type (for dim) is users in this example?
users = (From r In myentities.view_user).SingleOrDefault

Imar · September 10th, 2015, 03:24 AM

So it is the same as the other thread: just hover over Dim or users and it'll show you the type; likely it'll be view_user but I can't tell for sure. It'll be a single instance (because of your SingleOrDefault) of whatever the underlying type of view_user is.

Note that this likely won't work:

(From r In myentities.view_user).SingleOrDefault

There's no restrictive Where clause (for example, finding one y its ID) so unless there's exactly one user in your database SingleOrDefault will crash because it'll encounter more than one object.

Cheers,

Imar

avidan · September 10th, 2015, 02:46 PM

Dim users As IQueryable(Of view_user)

Thanks for your help.
Alex