what approach will experts choose to follow in this type of condition using LINQ silverlight .edmx
- 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 dat开发者_如何学编程aadaptor
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
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"
You can try BLToolkit to create your DAL and then use WCF service to push data to silverlight app.
精彩评论