Using SQL2005 Sequential GUID's

Thread is closed for posting
6 posts, 0 answers
  1. Sean McConnell
    Sean McConnell avatar
    38 posts
    Member since:
    Aug 2007

    Posted 16 Feb 2009 Link to this post

    Hello, we are trying to use OpenAccess with our existing database that uses sequential GUID's for Primary keys. I'm sure someone will say "don't use GUID's for PK's", well noted. Regardless, is there any way to get this to work correctly?

    It appears that automatically pulling back the DB generated PK value is only supported for INT types - is this correct?

    If we cannot get this to work, it basically breaks our performance increases gained from using Sequential GUID's vrs Regular GUID's. So we would either need to switch back to INT's (possible), try another solution (hope not), or possibly customize OpenAccess with a method of returning the newly generated GUID-type PK value ...



  2. Zoran
    Zoran avatar
    534 posts

    Posted 19 Feb 2009 Link to this post

    Hello Randall Kohltfarber,

    OpenAccess currently supports normal Guids and AUTOINC but sequential Guids are not supported yet. 

    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  3. Christian
    Christian avatar
    2 posts
    Member since:
    Nov 2008

    Posted 04 Jun 2010 Link to this post

    It has been over a year, have support for Sequential GUID's been added yet? 
  4. Dimitar Kapitanov
    Dimitar Kapitanov avatar
    632 posts

    Posted 07 Jun 2010 Link to this post

    Hi Christian,
    A new type mapping and definition system is being developed at the moment. The target release is for Q2 but we are sure we will be able to show something more even earlier. I think that the sequential GUIDs feature is exactly related to this development of ours, and I think we can have them for Q2. Hope that answers your questions.

    Kind regards,
    Dimitar Kapitanov
    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.
  5. Christian
    Christian avatar
    2 posts
    Member since:
    Nov 2008

    Posted 07 Jan 2011 Link to this post

    Has this been addressed yet?
  6. Damyan Bogoev
    Damyan Bogoev avatar
    581 posts

    Posted 10 Jan 2011 Link to this post

    Hi Sean McConnell,

    I am afraid that Telerik OpenAccess ORM does not support sequential GUIDs yet. We will do our best to add this feature for the next Q1 release.
    I am sorry for the inconvenience caused.

    Kind regards,
    Damyan Bogoev
    the Telerik team
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
Back to Top