• 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
+7
Watch Video

Views

select
ProductIDCategoryIDCategoryNameDiscontinuedProductNameQuantityPerUnitReorderLevelSupplierIDUnitPriceUnitsInStockUnitsOnOrder
123456
Page size:
select
 60 items in 6 pages
11BeveragesChai10 boxes x 20 bags10118.00390
21BeveragesChang24 - 12 oz bottles25119.001740
32CondimentAniseed Syrup12 - 550 ml bottles25110.001370
42CondimentChef Anton's Cajun Seasoning48 - 6 oz jars0222.00530
62CondimentGrandma's Boysenberry Spread12 - 8 oz jars25325.001200
77ProduceUncle Bob's Organic Dried Pears12 - 1 lb pkgs.10330.00150
82CondimentNorthwoods Cranberry Sauce12 - 12 oz jars0340.0060
108SeafoodIkura12 - 200 ml jars0431.00310
138SeafoodKonbu2 kg box566.00240
147ProduceTofu40 - 100 g pkgs.0623.25350

Databse Views are mapped to persistent classses by Telerik OpenAccess ORM. Views can be queried as any persistent objects via OQL or LINQ queries. In order to process the Views properly OpenAcces requires identity columns for every mapped View. These columns are selected by the user in the Reverse Mapping Wizard.

 

This example demonstrates how to use Database Views with Telerik OpenAccess ORM. The database View that is selected from the combo-box is beinq fetched from the database using OQL and presented in the RadGrid.