Here ya do Andrew
=========== Without [Eagerload]
UserProfileServiceTest.GetUserProfile : Passed
SELECT
Profile.Id,
Profile.LockVersion,
Profile.UserAccountId,
Profile.ProfileTypeId,
Profile.LastUpdatedDate,
Profile.CharacterUrl,
Profile.UiThemeColour,
Profile.Message,
Profile.FirstName,
Profile.LastName,
Profile.BirthDate,
Profile.SchoolName,
Profile.PhoneAreaCode,
Profile.PhoneNumber,
Profile.GuardianName,
Profile.GuardianEmailAddress,
Profile.GuardianPhoneAreaCode,
Profile.GuardianPhoneNumber,
Profile.UserAddressId,
Profile.GuardianAddressId
FROM
Profile
WHERE
Profile.UserAccountId = 1100;
SELECT
ProfileType.Id,
ProfileType.LockVersion,
ProfileType.ShortCode,
ProfileType.Description
FROM
ProfileType
WHERE
EXISTS (
SELECT
Profile.*
FROM
Profile
WHERE
Profile.ProfileTypeId = ProfileType.Id AND
Profile.UserAccountId = 1100
);
SELECT
Address.Id,
Address.LockVersion,
Address.StreetAddress,
Address.Suburb,
Address.City,
Address.PostCode,
Address.Country,
Address.LastUpdatedDate
FROM
Address
WHERE
EXISTS (
SELECT
Profile.*
FROM
Profile
WHERE
Profile.UserAddressId = Address.Id AND
Profile.UserAccountId = 1100
);
SELECT
Address.Id,
Address.LockVersion,
Address.StreetAddress,
Address.Suburb,
Address.City,
Address.PostCode,
Address.Country,
Address.LastUpdatedDate
FROM
Address
WHERE
EXISTS (
SELECT
Profile.*
FROM
Profile
WHERE
Profile.GuardianAddressId = Address.Id AND
Profile.UserAccountId = 1100
)
(1 ms)
SELECT
Favourite.Id,
Favourite.LockVersion,
Favourite.Name,
Favourite.FavouriteTypeId,
Favourite.UserProfileId
FROM
Favourite
WHERE
Favourite.UserProfileId = 1300;
SELECT
FavouriteType.Id,
FavouriteType.LockVersion,
FavouriteType.Name,
FavouriteType.Description
FROM
FavouriteType
WHERE
EXISTS (
SELECT
Favourite.*
FROM
Favourite
WHERE
Favourite.FavouriteTypeId = FavouriteType.Id AND
Favourite.UserProfileId = 1300
)
(0 ms)
SELECT
UserAccount.Id,
UserAccount.LockVersion,
UserAccount.IsDisabled,
UserAccount.FailedLogonAttempts,
UserAccount.IsLocked,
UserAccount.PasswordHash,
UserAccount.Nickname,
UserAccount.EmailAddress,
UserAccount.ResetPassword,
UserAccount.LastActiveDate,
UserAccount.LastUpdatedDate,
UserAccount.HashCookie
FROM
UserAccount
WHERE
UserAccount.Id = 1100
(0 ms)
===================================================
=========== With [Eagerload]=======================
UserProfileServiceTest.GetUserProfile : Failed
SELECT
Profile.Id,
Profile.LockVersion,
Profile.UserAccountId,
Profile.ProfileTypeId,
Profile.LastUpdatedDate,
Profile.CharacterUrl,
Profile.UiThemeColour,
Profile.Message,
Profile.FirstName,
Profile.LastName,
Profile.BirthDate,
Profile.SchoolName,
Profile.PhoneAreaCode,
Profile.PhoneNumber,
Profile.GuardianName,
Profile.GuardianEmailAddress,
Profile.GuardianPhoneAreaCode,
Profile.GuardianPhoneNumber,
Profile.UserAddressId,
Profile.GuardianAddressId
FROM
Profile
WHERE
Profile.UserAccountId = 1100;
SELECT
ProfileType.Id,
ProfileType.LockVersion,
ProfileType.ShortCode,
ProfileType.Description
FROM
ProfileType
WHERE
EXISTS (
SELECT
Profile.*
FROM
Profile
WHERE
Profile.ProfileTypeId = ProfileType.Id AND
Profile.UserAccountId = 1100
);
SELECT
Favourite.Id,
Favourite.LockVersion,
Favourite.Name,
Favourite.FavouriteTypeId,
Favourite.UserProfileId
FROM
Favourite
WHERE
EXISTS (
SELECT
Profile.*
FROM
Profile
WHERE
Profile.Id = Favourite.UserProfileId AND
Profile.UserAccountId = 1100
);
SELECT
FavouriteType.Id,
FavouriteType.LockVersion,
FavouriteType.Name,
FavouriteType.Description
FROM
FavouriteType
WHERE
EXISTS (
SELECT
Favourite.*
FROM
Favourite
WHERE
Favourite.FavouriteTypeId = FavouriteType.Id AND
EXISTS (
SELECT
Profile.*
FROM
Profile
WHERE
Profile.Id = Favourite.UserProfileId AND
Profile.UserAccountId = 1100
)
);
SELECT
Address.Id,
Address.LockVersion,
Address.StreetAddress,
Address.Suburb,
Address.City,
Address.PostCode,
Address.Country,
Address.LastUpdatedDate
FROM
Address
WHERE
EXISTS (
SELECT
Profile.*
FROM
Profile
WHERE
Profile.UserAddressId = Address.Id AND
Profile.UserAccountId = 1100
);
SELECT
Address.Id,
Address.LockVersion,
Address.StreetAddress,
Address.Suburb,
Address.City,
Address.PostCode,
Address.Country,
Address.LastUpdatedDate
FROM
Address
WHERE
EXISTS (
SELECT
Profile.*
FROM
Profile
WHERE
Profile.GuardianAddressId = Address.Id AND
Profile.UserAccountId = 1100
)
(1 ms)
SELECT
UserAccount.Id,
UserAccount.LockVersion,
UserAccount.IsDisabled,
UserAccount.FailedLogonAttempts,
UserAccount.IsLocked,
UserAccount.PasswordHash,
UserAccount.Nickname,
UserAccount.EmailAddress,
UserAccount.ResetPassword,
UserAccount.LastActiveDate,
UserAccount.LastUpdatedDate,
UserAccount.HashCookie
FROM
UserAccount
WHERE
UserAccount.Id = 1100
(0 ms)
NUnit.Framework.AssertionException:
expected: <8>
but was: <16>
at NUnit.Framework.Assert.DoAssert(IAsserter asserter)
at NUnit.Framework.Assert.AreEqual(Int32 expected, Int32 actual, String message, Object[] args)
at NUnit.Framework.Assert.AreEqual(Int32 expected, Int32 actual)
at SPARC.MissionOn.Webservices.User.Tests.UserProfileServiceTest.GetUserProfile() in UserProfileServiceTest.cs:line 147