Loading

How can I join two unrelated table in a SelectList?

How can I join two unrelated table in a SelectList?

Marius Vasile

Marius Vasile

5y694.NET

I have two unrelated tables and I want to join PTWTypeName from first table and PTWTypeNameOrg from the second one into a SelectList.

public class PTWType
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public string PTWId { get; set; }
public string PTWTypeName { get; set; }
}
public class PTWTypeOrg
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public string PTWIdOrg { get; set; }
public string PTWTypeNameOrg { get; set; }
public string OrgID { get; set; }
}

What I tried is

var ptwType = await _context.PTWTypesOrg
.Join(_context.PTWTypes, t1 => t1.PTWTypeNameOrg, t2 => t2.PTWTypeName, (t1, t2) => new
{
PTW1 = t1.PTWTypeNameOrg,
PTW2 = t2.PTWTypeName,
}).ToListAsync();
PTWTypeSL = new SelectList(ptwType);

but no result in the SelectList

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
all are string so you don't need join just use list and add values to it .
var PtwTypeNames= _context.PTWTypes.select(x=x.PTWTypeName).ToList();

var PTWTypeNameOrgs=_context.PTWTypeOrgs.
select(x=>x.PTWTypeNameOrg).ToList();

var newList = PtwTypeNames.Concat(PTWTypeNameOrgs);
Now use newList to bind your selectList , which is a list of string.