Thanks Pedro, I have constructed an Expression tree. However, it looks a bit daunting and unlikely to please my fellow colleagues who will probably argue on sticking to stored procs if they saw how its done.
On Feb 13, 4:11 pm, Pedro Ferreira <[email protected]> wrote: > 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-dy... > > > 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... > >> 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 -~----------~----~----~----~------~----~------~--~---
