NewId Class

Creates a unique database-generated value. Translates into the SQL string NEWID().

For a list of all members of this type, see NewId Members.

System.Object
   Field
      ScalarFunction
         NewId

[Serializable]

public class NewId : ScalarFunction

Example

The following unit test, FunctionTests.OrderByNewId(), demonstrates querying for the set of ProductCategorys in the DomainObjects unit test database and ordering by the NewId function.

Based on the criteria defined in the FunctionTests.OrderByNewId() test, DomainObjects executes the following SELECT statement against the database:

SELECT   PRODUCT_CATEGORY01.PRODUCT_CATEGORY_ID AS PRODUCT_CATEGORY01_PRODUCT_CATEGORY_ID,
         PRODUCT_CATEGORY01.NAME AS PRODUCT_CATEGORY01_NAME,
         PRODUCT_CATEGORY01.DESCRIPTION AS PRODUCT_CATEGORY01_DESCRIPTION,
         PRODUCT_CATEGORY01.CONCRETE_CLASS AS PRODUCT_CATEGORY01_CONCRETE_CLASS,
         PRODUCT_CATEGORY01.SPANISH_DESCRIPTION AS PRODUCT_CATEGORY01_SPANISH_DESCRIPTION,
         NEWID()
FROM     PRODUCT_CATEGORY AS PRODUCT_CATEGORY01
ORDER BY 6

Requirements

Namespace: DomainObjects.Facade.Command.Function

Assembly: DomainObjects.Core (in DomainObjects.Core.dll)

NewId Class

Example

Requirements

See Also