Linq To Entities question

Question

I have a table called TableA whch has a foreign key from TableB and a one to many relationship to TableB

I want to do:

var v = Context.TableASet .Include("TableB") .Where(x => x.TableB.Col1 == 123)

But when I do x.TableB. I don't have the Col1 option. this is because TableB has a one to many relationship so I get the properties of a collection and not a TableB object

What can I do here?

jrista · Accepted Answer · 2009-10-27 00:33:32Z

You can use the Any() method on TableB:

var v = Context.TableASet.Include("TableB").Where(x => x.TableB.Any(b => b.Col1 == 123));

Collectives™ on Stack Overflow

Linq To Entities question

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related