GregJFGregJF

My feedback

  1. 8 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      3 comments  ·  Entity Framework Feature Suggestions » runtime  ·  Flag idea as inappropriate…  ·  Admin →
      GregJFGregJF supported this idea  · 
    • 813 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        16 comments  ·  Entity Framework Feature Suggestions » tools  ·  Flag idea as inappropriate…  ·  Admin →
        GregJFGregJF commented  · 

        This is a TERRIBLE idea. In EF and other ORMs Entity keys are used to identify unique records and build associations. Using a GUID to identify unique records is ok (but up for debate).
        But to use them to build associations makes a terrible implementation at the DB level as index and table pages are stuffed with 32 byte records making queries much less efficient than a 4 byte int record or a 8 byte bigint.
        GUIDs can be Unique not null-able keys without being PK or FK

      Feedback and Knowledge Base