This question is locked. New answers and comments are not allowed.
I am getting the following exception:
When running this linq query:
The Users and People tables exist in different databases so this is in essence a cross database join.
Every record in the users table must have an email address but not every person in the persons table must have a login name hence the reason for the join not being outer.
I believe the issue is probably being cased by the join but have no idea what I can do to fix this issue?
After further testing I have now implemented the following LINQ change:
I now have the following exception raised:
If you look at the LINQ statement, Login name is a field of Person NOT User. Why is Telerik ORM resolving p.LoginName as u.LoginName.
This is mental. All I want to do is a simple inner join!!
Object reference not set to an instance of an object.
Dim
result = (From u
As
DB1.User
In
dbContext1.Users
Join p
As
DB2.Person
In
dbContext2.People
On
p.LoginName Equals u.Email
Select
u, p).ToList
Every record in the users table must have an email address but not every person in the persons table must have a login name hence the reason for the join not being outer.
I believe the issue is probably being cased by the join but have no idea what I can do to fix this issue?
After further testing I have now implemented the following LINQ change:
Dim
result = (From u
As
DB1.User
In
dbContext1.Users
Join p
As
DB2.Person
In
dbContext.People
On
p.LoginName Equals u.Email
Where
Not
p.LoginName
Is
Nothing
Select
u, p).ToList
Identifier 'LoginName' is not a parameter or variable or field of 'DbContext.User'. If 'LoginName' is a property please add the FieldAlias or Storage attribute to it or declare it as a field's alias.
This is mental. All I want to do is a simple inner join!!