IDataStore.Max<TModel, TResult>(Func<TModel, TResult> selector, Predicate<TModel> predicate) Method

.NET Standard 2.x

Invokes a transform function on each row (that satisfies the condition specified by Predicate<TModel>) in the primary buffer of the DataStore and returns the maximum result value.

Namespace: DWNet.Data

Assembly: DWNet.Data.dll

Syntax

  public TResult Max<Tmodel, TResult>(Func<Tmodel, TResult> selector, Predicate<Tmodel> predicate);

Type Parameters

TModel

The type of a model class that matches with the current DataObject.

TResult

The type of the value returned by selector.

Parameters

selector System.Func<TModel,TResult>

A transform function to apply to each row.

predicate System.Predicate<TModel>

A function to evaluate each row for a condition.

Returns

TResult

The maximum value.

Examples

The following code example demonstrates how to get the maximum value for budget from the Department table which meets the criterion (Departmentid > 3).

using Appeon.ApiDoc.Models;
using DWNet.Data;
using System;

namespace Appeon.ApiDoc.IDataStoreExamples
{
    public class MaxExample
    {
        private readonly SchoolContext _context;

        public MaxExample(SchoolContext dataContext)
        {
            // Sets the data context
            _context = dataContext;
        }

        public void Example2()
        {
            // Instantiates a DataStore object with datawindow: d_department.
            var datastore = new DataStore("d_department", _context);

            datastore.Retrieve();

            // Gets the maximum value for budget where departmentid > 3
            // The largest budget that meets the criteria is 250000.00
            decimal maxBudget = datastore.Max<D_Department, decimal>
                (d => d.Budget, d => d.Departmentid > 3);

            Console.WriteLine("Max Budget: {0}",
                               maxBudget);

            /*This code produces the following output:
             
            Max Budget: 250000.00
            */
        }
    }
}

Example Refer To

Model Class: D_Department
DataWindow File: d_department

Applies to

.NET Standard

2.x