1500 characters remaining

SQL Server 2008 R2

A window is a finite collection of events that results from applying a windowing operator on a stream of events..

## Inheritance Hierarchy

System.Object

Namespace:  Microsoft.ComplexEventProcessing.Linq
Assembly:  Microsoft.ComplexEventProcessing (in Microsoft.ComplexEventProcessing.dll)

## Syntax

```public class CepWindow<TPayload>

```

#### Type Parameters

The CepWindow<TPayload> type exposes the following members.

## Methods

NameDescription
Equals (Inherited from Object.)
Finalize (Inherited from Object.)
GetHashCode (Inherited from Object.)
GetType (Inherited from Object.)
MemberwiseClone (Inherited from Object.)
ToString (Inherited from Object.)
Top

## Extension Methods

NameDescription
Avg<TPayload>(Expression<Func<TPayload, SByte>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Int16>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Int32>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Int64>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Byte>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, UInt16>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, UInt32>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, UInt64>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Single>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Decimal>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Double>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Nullable<SByte>>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Nullable<Int16>>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Nullable<Int32>>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Nullable<Int64>>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Nullable<Byte>>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Nullable<UInt16>>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Nullable<UInt32>>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Nullable<UInt64>>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Nullable<Single>>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Nullable<Decimal>>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Avg<TPayload>(Expression<Func<TPayload, Nullable<Double>>>)Overloaded. Computes the average over all events in a window. The value to average over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Count<TPayload>Computes the count of events in the window. (Defined by CepWindowExtensionMethods.)
Max<TPayload, TMaxValue>Computes the maximum of the values specified by the input parameter over a window of events. (Defined by CepWindowExtensionMethods.)
Min<TPayload, TMinValue>Computes the minimum of the values specified by the input parameter over a window of events. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, SByte>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Int16>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Int32>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Int64>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Byte>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, UInt16>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, UInt32>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, UInt64>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Single>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Decimal>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Double>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Nullable<SByte>>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Nullable<Int16>>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Nullable<Int32>>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Nullable<Int64>>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Nullable<Byte>>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Nullable<UInt16>>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Nullable<UInt32>>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Nullable<UInt64>>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Nullable<Single>>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Nullable<Decimal>>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
Sum<TPayload>(Expression<Func<TPayload, Nullable<Double>>>)Overloaded. Computes the sum of all events in a window. The value to compute the sum over is defined in the input expression parameter. (Defined by CepWindowExtensionMethods.)
UserDefinedAggregate<TPayload, TUda, TAggregateOutput>Calls a user-defined aggregate (UDA) in which the UDA does not take an additional expression to map the input event to the input that the UDA expects. (Defined by CepWindowExtensionMethods.)
UserDefinedAggregateWithMapping<TPayload, TUda, TAggregateInput, TAggregateOutput>Calls a user-defined aggregate. (Defined by CepWindowExtensionMethods.)
Top

## Remarks

Windows serve as the basis for set-based operations such as aggregation or ranking. For more information, see Using Event Windows.