Dynamic type inside a Linq-to-sql query

Question

I'm trying to refactor a query that currently uses reflection:

var dbObjects = from d in collection  
    where d.GetType().GetProperty("Id").GetValue(d, null) == id  
    select d;

I would like to use dynamic typing to access the property Id on "d" without knowing what type "d" is at compile time. Something like this:

var dbObjects = from (dynamic)d in collection  
    where d.Id == id  
    select d;

Is this possible? ... and out of interest, is it faster, or does the dynamic runtime use reflection under the hood?

Thanks,

Alan

How is this linq-to-sql? The database can't call those reflection methods. — Amy B
– Amy B, Commented Jun 24, 2010 at 13:19

Koynov · Accepted Answer · 2010-06-24 10:56:48Z

2

Dynamic type uses reflection under the hood so it won't be much faster if any. Because of that I think your Linq-To-Sql expression should work fine. You could check that blog post. It seams that DLR is there only to make your code more readable.

edited Jun 24, 2010 at 10:56

answered Jun 24, 2010 at 10:49

Koynov

1,5191 gold badge10 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dynamic type inside a Linq-to-sql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related