Forum Discussion

Tom_R's avatar
Tom_R
New Contributor III
4 years ago

Join Framework table data to Application table data using SQL

SOURCE: ONESTREAM CHAMPIONS Hi - I am trying to create a journal entry summary report, and am able to get most of my data from the application tables, however the created by, submitted by, etc user...
Data Integration
Tom_R's avatar
Tom_R
New Contributor III
4 years ago

Hi Marc,

What did you use to join the two tables?

Thanks,

ckattookaran's avatar
ckattookaran
VIP
4 years ago

You can use LINQ to join two datatables.

  • MarcR's avatar
    MarcR
    VIP
    4 years ago

    Hi Tom, I actually have a really small dataset from the application (i select the scheduled tasks from the task scheduler) and then loop over these results in a Datatable. For every line (i have only 😎 i run a query on the Framework with the item from the application and append that to a DataTable.
    However, i cannot imagine that there is no way to join two datatables.

    Curious what LINQ means that Celvin states. @Celvin, do you have some more information?

    • Tom_R's avatar
      Tom_R
      New Contributor III
      4 years ago

      Hi Celvin,

      I have never used LINQ. Can you please provide an example of how it would work?

      Thanks,