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!