Question Linq join on parameterized distinct key CASE INSENSITIVE

[lordbaddkitty]

To Revisit a previous question with a further stipulation...

Anyone know how to do the following, IGNORING CASE?

Dim Matches = From mRows In LinqMasterTable Join sRows In LinqSecondTable _
             On mRows(ThePrimaryKey) Equals sRows(TheForignKey) _
             Order By mRows(ThePrimaryKey) _
             Select mRows, sRows

For details about the query and it's functions / usage, the previous post is here.

 

[MattP]

SQL Server - linq join parameterized distinct key case insensitive

Dim Matches = From mRows In LinqMasterTable _
From sRows In LinqSecondTable _
Where String.Equals(mRows(ThePrimaryKey).sRows(TheForignKey), StringComparison.OrdinalIgnoreCase) _
Select mRows, sRows

 

[lordbaddkitty]

SQL Server - linq join parameterized distinct key case insensitive

"Public member 'sRows' on type 'String' not found."

Changed it to mRows(ThePrimaryKey),sRows(TheForign Key) (comma rather than period)

"Conversion from type 'DBNull' to type 'String' is not valid."