IDataStore.Min<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 a Predicate<TModel> object) in the primary buffer of the DataStore and returns the minimum result value.

Namespace: DWNet.Data

Assembly: DWNet.Data.dll

Syntax

  public TResult Min<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 minimum value for budget from the Department table which meets the criteria (Departmentid is larger than 3).

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

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

        public MinExample(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 minimum value for budget where departmentid > 3
            // The smallest budget that meets the criteria is 200000.00
            decimal MinBudget = datastore.Min<D_Department, decimal>(
                d => d.Budget, d => d.Departmentid > 3);

            Console.WriteLine("Min Budget: {0}",
                               MinBudget);

            /*This code produces the following output:
             
            Min Budget: 200000.00
            */
        }
    }
}

Example Refer To

Model Class: D_Department
DataWindow File: d_department

Applies to

.NET Standard

2.x