views:

871

answers:

1

I am binding a Winforms Grid to an entity. (For reasons I won't go into here it must be bound to the entity, not the result a query) The code is as follows:

grid.DataSource = myEntities.entityName.Where("it.field = " & field)

It works, but it obviously isn't strongly typed. Is there a way to define the Where clause of an entity using a strongly typed notation?

+4  A: 

Have you tried to use a lambda expression?

grid.DataSource = myEntities.Customers.Where(c => c.Name == "Bob");

or in VB:

grid.DataSource = myEntities.Customers.Where(Function(c) c.Name = "Bob")

If it has to be dynamic then you might want to look at building a custom Expression Tree. For a tutorial on the basics of Expression Trees see this blog http://blogs.msdn.com/charlie/archive/2008/01/31/expression-tree-basics.aspx

This blog shows a good example of sorting. http://weblogs.asp.net/davidfowler/archive/2008/12/11/dynamic-sorting-with-linq.aspx

bendewey
Thanks. For those of you working in VB like me the VB format is: grid.DataSource = myEntities.Customers.Where( function(c) c.Name = "Bob")
Jeff
Thanks, I added it to the answer.
bendewey