Learning › Ecsqlreference › PolymorphicAndNonPolymorphicQuery
Edit this page

Polymorphic vs non-polymorphic query

ECSQL is polymorphic query by default, use the ONLY keyword to make queries non-polymorphic.

Syntax: [ALL|ONLY] <className>

Polymorphic query

SELECT * FROM [BisCore].[GeometricElement3d] Limit 10 -- following is same as above and all GeometricElement3d and its derived classes will be returned. SELECT * FROM ALL [BisCore].[GeometricElement3d] Limit 10

Non-Polymorphic query

Restrict result to exactly a single type of class.

SELECT * FROM ONLY [BisCore].[GeometricElement3d] Limit 10

ECSql Syntax

Last Updated: 13 November, 2025