I have a code that is working in .Net 3.1 and we have upgraded to .Net 8 and as part of that I have converted Nuget package Microsoft.EntityFramework.MemoryJoin to 0.8.0 and I observed the in-memory List and DB table join having issues after the upgrade. and my code is

var ssnList = objData.Where(r => r.LstMemGraphs != null).Where(r => r.LstMemGraphs.FirstOrDefault().SSN != null)
                   .Select(b => new { SSN = b.LstMemGraphs?.FirstOrDefault().SSN }).ToList();
var querableSSN = _context.FromLocalList(ssnList);   
var lstAccountsSsn = from a in _context.Account
                         join t in queryableSSn on a.SSN equals t.SSN
                         select a;


lstAccounts.AddRange(lstAccountsSsn);

I got the Exception after the upgrade at _context.FromLocalList(ssnList) saying System.String Microsoft.EntityFrameworkCore.RelationalPropertyExtensions.GetColumnName(Microsoft.EntityFrameworkCore.Metadata.IProperty)’not found

Any other way to join both the list and achieve this