none
Query to Achive following Requirement

    Question

  • <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} -->


    Hi:
             Can any one send me LINQ to SQL Query to Achieve the following Requirement.Plz its very Urgent


    User Table

       UserID                                UserName        

          1                                        Kumar
          2                                         Danial



    FeedbackQA -Table 

    FeedbackQAId                       Qusetions                                                                

      1                                       Are u  a Tax   Payer                                                        

      2                                        Have you Paid Tax                                                         


    FeedbackReport Table  

    UserID           FeedbackQAId                    Answers

      1                           1                                         Yes

      1                           2                                         Yes

    2                            1                                         No
    2                            2                                         Yes

    Result

    UserName            Are u  a Tax  Payer                                        Have you Paid Tax

     Kumar                      Yes                                                                         Yes
    Danial                        No                                                                           Yes


    Wednesday, May 06, 2009 2:28 PM

All replies

  • Please don't make duplicate threads. See my response in your other thread.

    http://social.msdn.microsoft.com/Forums/en-US/linqtosql/thread/91cdd6f7-d3d2-4a6e-bfb9-b84c45a1f9c2
    Sunday, May 10, 2009 5:03 PM
    Answerer