SqlCeFunctions Class

Definition

Namespace:

System.Data.Entity.SqlServerCompact.Legacy

Assembly:

EntityFramework.SqlServerCompact.Legacy.dll

Contains function stubs that expose SqlServerCe methods in Linq to Entities.

public static class SqlCeFunctions

type SqlCeFunctions = class

Public Class SqlCeFunctions

Inheritance

Object

SqlCeFunctions

Methods

Acos(Nullable<Decimal>)	A mathematical function that returns the angle, in radians, whose cosine is the specified numerical value. This angle is called the arccosine.
Acos(Nullable<Double>)	A mathematical function that returns the angle, in radians, whose cosine is the specified numerical value. This angle is called the arccosine.
Asin(Nullable<Decimal>)	A mathematical function that returns the angle, in radians, whose sine is the specified numerical value. This angle is called the arcsine.
Asin(Nullable<Double>)	A mathematical function that returns the angle, in radians, whose sine is the specified numerical value. This angle is called the arcsine.
Atan(Nullable<Decimal>)	A mathematical function that returns the angle, in radians, whose tangent is the specified numerical value. This angle is called the arctangent.
Atan(Nullable<Double>)	A mathematical function that returns the angle, in radians, whose tangent is the specified numerical value. This angle is called the arctangent.
Atan2(Nullable<Decimal>, Nullable<Decimal>)	Returns the positive angle, in radians, between the positive x-axis and the ray from the origin through the point (x, y), where x and y are the two specified numerical values. The first parameter passed to the function is the y-value and the second parameter is the x-value.
Atan2(Nullable<Double>, Nullable<Double>)	Returns the positive angle, in radians, between the positive x-axis and the ray from the origin through the point (x, y), where x and y are the two specified numerical values. The first parameter passed to the function is the y-value and the second parameter is the x-value.
CharIndex(Byte[], Byte[])	Returns the starting position of one expression found within another expression.
CharIndex(Byte[], Byte[], Nullable<Int32>)	Returns the starting position of one expression found within another expression.
CharIndex(Byte[], Byte[], Nullable<Int64>)	Returns the starting position of one expression found within another expression.
CharIndex(String, String)	Returns the starting position of one expression found within another expression.
CharIndex(String, String, Nullable<Int32>)	Returns the starting position of one expression found within another expression.
CharIndex(String, String, Nullable<Int64>)	Returns the starting position of one expression found within another expression.
Cos(Nullable<Decimal>)	Returns the trigonometric cosine of the specified angle, in radians, in the specified expression.
Cos(Nullable<Double>)	Returns the trigonometric cosine of the specified angle, in radians, in the specified expression.
Cot(Nullable<Decimal>)	A mathematical function that returns the trigonometric cotangent of the specified angle, in radians.
Cot(Nullable<Double>)	A mathematical function that returns the trigonometric cotangent of the specified angle, in radians.
DataLength(Byte[])	Returns the number of bytes used to represent any expression.
DataLength(Nullable<Boolean>)	Returns the number of bytes used to represent any expression.
DataLength(Nullable<DateTime>)	Returns the number of bytes used to represent any expression.
DataLength(Nullable<Decimal>)	Returns the number of bytes used to represent any expression.
DataLength(Nullable<Double>)	Returns the number of bytes used to represent any expression.
DataLength(Nullable<Guid>)	Returns the number of bytes used to represent any expression.
DataLength(String)	Returns the number of bytes used to represent any expression.
DateAdd(String, Nullable<Double>, Nullable<DateTime>)	Returns a new datetime value based on adding an interval to the specified date.
DateAdd(String, Nullable<Double>, String)	Returns a new datetime value based on adding an interval to the specified date.
DateDiff(String, Nullable<DateTime>, Nullable<DateTime>)	Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
DateDiff(String, Nullable<DateTime>, String)	Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
DateDiff(String, String, Nullable<DateTime>)	Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
DateDiff(String, String, String)	Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
DateName(String, Nullable<DateTime>)	Returns a character string that represents the specified datepart of the specified date.
DateName(String, String)	Returns a character string that represents the specified datepart of the specified date.
DatePart(String, Nullable<DateTime>)	Returns an integer that represents the specified datepart of the specified date.
DatePart(String, String)	Returns an integer that represents the specified datepart of the specified date.
Degrees(Nullable<Decimal>)	Returns the corresponding angle in degrees for an angle specified in radians.
Degrees(Nullable<Double>)	Returns the corresponding angle in degrees for an angle specified in radians.
Degrees(Nullable<Int32>)	Returns the corresponding angle in degrees for an angle specified in radians.
Degrees(Nullable<Int64>)	Returns the corresponding angle in degrees for an angle specified in radians.
Exp(Nullable<Decimal>)	Returns the exponential value of the specified float expression.
Exp(Nullable<Double>)	Returns the exponential value of the specified float expression.
GetDate()	Returns the current database system timestamp as a datetime value without the database time zone offset. This value is derived from the operating system of the computer on which the instance of SQL Server is running.
Log(Nullable<Decimal>)	Returns the natural logarithm of the specified input value.
Log(Nullable<Double>)	Returns the natural logarithm of the specified input value.
Log10(Nullable<Decimal>)	Returns the base-10 logarithm of the specified input value.
Log10(Nullable<Double>)	Returns the base-10 logarithm of the specified input value.
NChar(Nullable<Int32>)	Returns the Unicode character with the specified integer code, as defined by the Unicode standard.
PatIndex(String, String)	Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types.
Pi()	Returns the constant value of pi.
Radians(Nullable<Decimal>)	Returns the radian measure corresponding to the specified angle in degrees.
Radians(Nullable<Double>)	Returns the radian measure corresponding to the specified angle in degrees.
Radians(Nullable<Int32>)	Returns the radian measure corresponding to the specified angle in degrees.
Radians(Nullable<Int64>)	Returns the radian measure corresponding to the specified angle in degrees.
Rand()	Returns a pseudo-random float value from 0 through 1, exclusive.
Rand(Nullable<Int32>)	Returns a pseudo-random float value from 0 through 1, exclusive.
Replicate(String, Nullable<Int32>)	Repeats a string value a specified number of times.
Sign(Nullable<Decimal>)	Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.
Sign(Nullable<Double>)	Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.
Sign(Nullable<Int32>)	Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.
Sign(Nullable<Int64>)	Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.
Sin(Nullable<Decimal>)	Returns the trigonometric sine of the specified angle.
Sin(Nullable<Double>)	Returns the trigonometric sine of the specified angle.
Space(Nullable<Int32>)	Returns a string of repeated spaces.
SquareRoot(Nullable<Decimal>)	Returns the square root of the specified number.
SquareRoot(Nullable<Double>)	Returns the square root of the specified number.
StringConvert(Nullable<Decimal>)	Returns character data converted from numeric data.
StringConvert(Nullable<Decimal>, Nullable<Int32>)	Returns character data converted from numeric data.
StringConvert(Nullable<Decimal>, Nullable<Int32>, Nullable<Int32>)	Returns character data converted from numeric data.
StringConvert(Nullable<Double>)	Returns character data converted from numeric data.
StringConvert(Nullable<Double>, Nullable<Int32>)	Returns character data converted from numeric data.
StringConvert(Nullable<Double>, Nullable<Int32>, Nullable<Int32>)	Returns character data converted from numeric data.
Stuff(String, Nullable<Int32>, Nullable<Int32>, String)	Inserts a string into another string. It deletes a specified length of characters in the target string at the start position and then inserts the second string into the target string at the start position.
Tan(Nullable<Decimal>)	Returns the trigonometric tangent of the input expression.
Tan(Nullable<Double>)	Returns the trigonometric tangent of the input expression.
Unicode(String)	Returns the integer value, as defined by the Unicode standard, for the first character of the input expression.