BLL and DAL

kss · November 24th, 2008, 03:01 PM

Thanks Lee,
I caught that, and made the correct changes. But I'm still getting the same exception.

And I believe it's on AspNetUserID, cuz in the command window it I try to debug.print("AspNetUserID") I get the exception but if I debug.print on the UserName, it is returned, to the command window.
The AspNetUserID can not be null in my db table.
Out of all the fields that my Stored proc returns only 2 can be nulls (middlename and phone2)

Thanks everyone for you help, suggestions and guidance.
Kss.

kss · November 24th, 2008, 03:06 PM

Could the fact that AspNetUserID is a guid, have anything to do with it? When I do reader("AspNetUserID") do I need to do anything to cast this as a guid like I do with my booleans and dates.

Lee Dumond · November 24th, 2008, 03:49 PM

Yeah, you would want to do that, though I'm not sure this relates to the problem at hand. The following code should accomplish that.

Code:

Protected Overridable Function GetUserFromReader( _
                ByVal reader As IDataReader) _
                As UsersDetails

   Dim userId As New Guid(reader("AspNetUserId").ToString)

   Return New UsersDetails( _
     userId, _
     reader("UserName").ToString(), _
     reader("FirstName").ToString(), _
     
     etc...
End Function

_________________________________

Visit my blog at http://leedumond.com

kss · November 24th, 2008, 03:59 PM

Awesome thanks.

Figuered it out, stupid mistake on my part.
reader("xxx") the "xxx" needs to be the actual fields from your stored proc. not what you are using in your object.

It's alway the simple stupid stuff that gets you.
Thanks all.
Greatly appreciated.