what approach will experts choose to follow in this type of condition using LINQ silverlight .edmx

Question

• there are 500 tables, some large, some small,
• all have different number of columns
• they may or may not have a relation between them

i must

• select

  • "user specified columns" from
  • "user specified table" where
  • "user specified condition" on "user specified column"

my solution was

• just write functions/queries/stored procedures for all of them :-)

but well thats gonna take an eternity considering the fact that silver doesnot support system.data which would have provided a simple/crude solution of constructing the select command as a string and then pass it to the dataadaptor

note

this question might seem fimiliar to the previous one i asked

but here

• i am interested in any feasible/professional solution

and also note

• please do not comment that this scenario can never arise practically, i know that just wondering what if!

thnks

Answer 1

I would look in to having Silveright use WCF RIA Services and NHibernate.

NHibernate offers the ability to compose expressions on the fly and dynamically map to objects. Consider the approach found here for building your

select "user specified columns" from
"user specified table" where
"user specified condition" on "user specified column"

Answer 2

You can try BLToolkit to create your DAL and then use WCF service to push data to silverlight app.