Home / Community & Support / Developer Productivity Tools Forums / ASP.NET > Documentation > Can Telerik support views ?

• michael

  Posted on Oct 28, 2010 (permalink)

  Please help me.

  In the below example an error occurred while I trying to create a view, because  Column names in each view must be unique. Column name 'pet_id' in view 'v_oa_select_pet' is specified more than once. 

  My question is can I create views ?

  Here is the link for below example   http://www.telerik.com/help/openaccess-orm/classes-inheritance.html

   

   

  =====================view=========================================

  CREATE VIEW v_oa_select_pet

  AS

  SELECT a.pet_id, a.pet_id, c.pet_id, d.pet_id,

         a.best_friend, b.nme, b.voa_version, c.cats_eaten,

         d.lngth

    FROM dog a

         INNER JOIN pet AS b ON (a.pet_id = b.pet_id)

         LEFT JOIN rottweiler AS c ON (a.pet_id = c.pet_id)

         LEFT JOIN wiener_dog AS d ON (a.pet_id = d.pet_id)

   

  ============================================================

   

  Thanks

• Petar Petar

  Posted on Oct 29, 2010 (permalink)

  Hello michael,

  Unfortunately we do not support forward mapping of views. OpenAccess allows you to work with already available views. Having said that, if you would like to create a view you will have to do it manually by providing valid columns based on which the view will be created. Later you can reverse map those views to your model and work with them as you would do with your normal tables.

  Sincerely yours,
  Petar
  the Telerik team

  Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / ASP.NET > Documentation > Can Telerik support views ?