Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1425
LINQ & Infragistics Functions
posted

Hi All,

I've been very impressed so far with LINQ, particularly when it comes to grouping and apply aggregate functions to data. I've also been impressed with Infragistics' library of functions and the FormulaBuilderDialog.

Ideally, I'd like to combine the two... to group rows in a DataTable using LINQ - applying aggregate functions that could be initially specified in the syntax of the Infragistics' functions e.g. 'stdev([PRICE]) / average([PRICE])'.

I've been looking into the use of LINQ's 'Aggregate' keyword to use a custom function, but wondered if there's anyway to incorporate the Infragistics functions with this. Does anyone have any ideas?

I can see a way of interpreting the syntax myself but this would still involve me having to write (or find) source-code for the functions supported in the Infragistics Formula Builder e.g. standard deviation.

So my questions are:

  1. Does this sound like a plausable solution?
  2. Do we have access to the source-code of the Infragistics functions? Or could someone give me a little more information about the functions (are they taken from an external library)?
  3. Has anyone else given this a though? Have any suggestions or experience?

Any information - be it little or large - will be greatly appreciated. =)

Cheers,

Richard

  • 469350
    Verified Answer
    Offline posted

    Hi Richard,

    I'm afraid I'm not entirely clear what you are trying to do. You want to apply a formula to... what exactly?The results of a LINQ Query?

    I think the easiest thing to do would be to bind the data you get back from your LINQ query to a WinGrid and then apply formulas to the grid.