in
SubSonic Forums » SubSonic 2.x » Code Discussion » How walk relations & get the sql fro auto-creation of views

How walk relations & get the sql fro auto-creation of views

Last post 05-13-2008 2:12 AM by yitzchok. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 05-09-2008 6:01 PM

    • mamcx
    • Not Ranked
    • Joined on 10-23-2007
    • Posts 1

    How walk relations & get the sql fro auto-creation of views

    Reply Contact
    Hi, We are building a reporting that look like a OLAP report using DevExpress PivotGrid. We need let the user select the tables & get back a single view of the data. We don't let him define their relationships (no user have training in databases). Is for replace a system 5 years old that have this functionality. I found that Subsonic let me walk the relationships. So the user freely chose 3 tables from a list of 15. Now, I need found how join them... and find the most optiomal join strategy so by mistake the software no join every table in the DB or chosee the longest path to joint them. Any ideas in how do this?

  • 05-13-2008 2:12 AM In reply to

    Re: How walk relations & get the sql fro auto-creation of views

    Reply Contact
    You can try the new SqlQuery from version 2.1 beta
    If I am I because I am I, and You are You because You are You, then I am I, and you are you. But If I am I because You are You, and You are You because I am I, then I am not I and You are not You. -Rabbi of Kotzk
Page 1 of 1 (2 items)