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