How to create generic DbSet table that can be used in linq query

Asked Sep 08 '22 at 19:10

Active Sep 10 '22 at 18:51

Viewed 64 times

I have 3 Entity DBSet table => (Table1, Table2, Table3)

Three of them have same properties name => (id, UserName, Role)

My Function

Question: how do I create a function that can be used for 3 different DbSet table?

Can we create a generic DBSet and access property by typing the string "id" and do the linq query like => a.("id") equals b.PkId (code above). Thanks in advance!

edited Sep 10 '22 at 18:51

David Browne - Microsoft

80,331
6
39
67

asked Sep 08 '22 at 19:10

Wayne Zack

1

_"Three of them have same properties name"_ - apply an interface, accept an `IQueryable` as parameter. – CodeCaster Sep 08 '22 at 19:14
@CodeCaster Hi, thanks for commenting, do you mean create an interface for my function or properties? – Wayne Zack Sep 09 '22 at 01:36

How to create generic DbSet table that can be used in linq query

0 Answers0