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 criterion (Departmentid > 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