Dynamic SQL with LINQ multiple table joins. RRS feed

  • Question

  • Hi 

    I have a meta data of database with me. At runtime i have to generate queries which may include multiple table joins.
    Client Application just send the XML to service to with column name.

    Using meta data I can get the names of tables to bi join with there primary key. But few tables has different relationship with different table. may be on primary key or some combine key or some unique column.

    So I am facing trouble in join two tables on the basis of information I have from meta data. Can any one suggest me to solve this issue. Also if any one of you know any good algo. for generation dynamic queries. please let me know.

    Friday, February 6, 2009 6:53 PM