Not sure if I understood the problem, but if you know the entity / property types, you can also create the Expression tree at runtime. We are doing something like this in our framework. Let me know if you need an example on this.
Pedro On Fri, Feb 13, 2009 at 4:09 PM, Justin Collum <[email protected]> wrote: > Check out this thread: > http://stackoverflow.com/questions/498597/linq-is-it-possible-with-dynamic-linq-to-dynamically-specify-the-from-clause > > On Fri, Feb 13, 2009 at 8:04 AM, Justin Collum <[email protected]> wrote: >> >> Have you read ScottGu's post about Dynamic LINQ? Might help: >> http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx >> Nothing in there about using a table dynamically though. You might be asking >> LINQ to do something that it can't. >> >> Also, this isn't specific to dblinq. More appropriate to post this >> question on StackOverflow. >> >> On Fri, Feb 13, 2009 at 7:48 AM, Blair <[email protected]> wrote: >>> >>> Hi >>> >>> I have a feeling this is not possible but I thought I should ask in >>> any case. >>> >>> Is it possible to use DBLinq/Linq to query a table dynamically. >>> Something like: - >>> >>> string tableName = "my_table"; >>> var q = from p in db.GetTableX(tableName) select p; >>> >>> I have used GetTableX here as the existing methods GetTable doesn't >>> allow you to do this. >>> >>> I have several tables that all have an ID column and I would select a >>> row that has a particular ID. >>> >>> I have tried several methods including instantiating a generic >>> instance using Activator.CreateInstance and invoking a CreateQuery as >>> a GenericMethod. Unfortunately both methods just return an Object >>> which cannot be enumerated with Linq's select construct. >>> >>> I can see why this is tricky since the "<from> * <in> * <where> * >>> <select>" grammar needs strong typing. >>> >>> Thanks in advance, >>> Blair >>> >> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dblinq?hl=en -~----------~----~----~----~------~----~------~--~---
