• ORM Open Access Demo
  • ASP.NET Ajax Demo
  • Extensions for ASP.NET MVC
  • Silverlight Demo
  • WPF Demo
  • Reporting Demo
  • Visit Telerik site
Q1 2010 (v2010.1.310, 10 March 2010) release history
Vote
+8
Watch Video

Using Oql

select
CustomerIDAddressBool1CityCompanyNameContactNameContactTitleCountryFaxPhonePostalCodeRegion
12345678910
Page size:
select
 92 items in 10 pages
07091AddressCityCompanyNameContactNameContactTitleCountryXXXYYYZZZRegion
54848AddressCityCompanyNameContactNameContactTitleCountryXXXYYYZZZRegion
54867AddressCityCompanyNameContactNameContactTitleCountryXXXYYYZZZRegion
ANTONMataderos 2312México D.F.Antonio Moreno TaqueríaAntonio MorenoOwnerMexico (5) 555-393205023 
AROUT120 Hanover Sq.LondonAround the HornThomas HardySales RepresentativeUK(171) 555-6750(171) 555-7788WA1 1DP 
BERGSBerguvsvägen 8LuleåBerglunds snabbköpChristina BerglundOrder AdministratorSweden0921-12 34 670921-12 34 65S-958 22 
BLAUSForsterstr. 57MannheimBlauer See DelikatessenHanna MoosSales RepresentativeGermany0621-089240621-0846068306 
BLONP24, place KléberStrasbourgBlondesddsl père et filsFrédérique CiteauxMarketing ManagerFrance88.60.15.3288.60.15.3167000 
BOLIDC/ Araquil, 67MadridBólido Comidas preparadasMartín SommerOwnerSpain(91) 555 91 99(91) 555 22 8228023 
BONAP12, rue des BouchersMarseilleBon app'Laurence LebihanOwnerFrance91.24.45.4191.24.45.4013008 
OQL (Object Query Language) is used to perform different queries to the persistent objects. When using OQL queries are performed to the persistent classes and not to database tables. The OQL queries will be the same no matter what database you use. OQL differs from SQL in that:
  • OQL supports object referencing within tables. Objects can be nested within objects;
  • Not all SQL keywords are supported within OQL. Keywords that are not relevant to Netcool/Precision IP have been removed from the syntax;
  • OQL can perform mathematical computations within OQL statements.