Overview
Basics
Operations
Providers
Providers
Supported Data Types and Operations
Service Query supports all .NET Framework supported data types. Different Framework versions support different data types as well as different operations. View the table below to discover operation support by version.
Supported Data Types By Version
Version | bool | bool? | byte | byte? | char | char? | double | double? | DateTime | DateTime? | DateTimeOffset | DateTimeOffset? | decimal | decimal? | float | float? | Guid | Guid? | short | short? | int | int? | long | long? | sbyte | sbyte? | Single | Single? | string | string? | TimeSpan | TimeSpan? | UInt16 | UInt16? | UInt32 | UInt32? | UInt64 | UInt64? | UInt128 | UInt128? |
.NET 7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
.NET 6 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
Information for .NET Standard 2.1, 2.0, 1.3, .NET 4.5, 4.0 and 3.5 Coming Soon!
Supported Operations By Version
Objects in a list
Version | Select | Distinct | Sort | Average | Count | Minimum | Maximum | Sum | Null | NotNull | Between | Equal | NotEqual | LessThan | LessThanOrEqual | GreaterThan | GreaterThanOrEqual | InSet | NotInSet | Contains | StartsWith | EndsWith |
.NET 7 | Yes | No | Yes | decimal double float int long Single | decimal double float int long Single | decimal double float int long sbyte short Single UInt16 UInt32 UInt64 UInt128 | decimal double float int long sbyte short Single UInt16 UInt32 UInt64 UInt128 | decimal double float int long Single | Yes | Yes | byte char DateTime DateTimeOffset decimal double float int long Guid sbyte short Single UInt16 UInt32 UInt64 UInt128 | Yes | Yes | byte char DateTime DateTimeOffset decimal double float Guid int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 UInt128 | byte char DateTime DateTimeOffset decimal double float Guid int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 UInt128 | byte char DateTime DateTimeOffset decimal double float Guid int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 UInt128 | byte char DateTime DateTimeOffset decimal double float Guid int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 UInt128 | Yes | Yes | Yes | Yes | Yes |
.NET 6 | Yes | No | Yes | decimal double float int long Single | decimal double float int long Single | decimal double float int long sbyte short Single UInt16 UInt32 UInt64 | decimal double float int long sbyte short Single UInt16 UInt32 UInt64 | decimal double float int long Single | Yes | Yes | byte char DateTime DateTimeOffset decimal double float int long sbyte short Single UInt16 UInt32 UInt64 | Yes | Yes | byte char DateTime DateTimeOffset decimal double float int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | byte char DateTime DateTimeOffset decimal double float int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | byte char DateTime DateTimeOffset decimal double float int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | byte char DateTime DateTimeOffset decimal double float int long sbyte short Single TimeSpan UInt16 UInt32 UInt64 | Yes | Yes | Yes | Yes | Yes |
Information for .NET Standard 2.1, 2.0, 1.3, .NET 4.5, 4.0 and 3.5 Coming Soon!