CodeSmith Community
Your Code. Your Way. Faster!

View based on Table using GUID as Primary Key

Latest post 07-09-2008 8:12 AM by blake05. 1 replies.
  • 07-03-2008 9:39 AM

    • JRich
    • Top 150 Contributor
    • Joined on 04-24-2007
    • Posts 30
    • Points 785

    View based on Table using GUID as Primary Key

    I have a view based on the following table schema. I also have a view which uses this table. When the View entity is generated, the column INVMatlTypeLkpID is specified to be an integer, rather than a GUID.

    /****************************************************************************************************/

    [INVMatlTypeLkpID] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_INVlkpMatlType_INVMatlTypeLkpID],
    [BusinessKey] [char](1) NULL,
    [Desc] [varchar](25) NULL,
    [Active] [dbo].[Boolean_True] NULL,
    [LogicalDel] [dbo].[Boolean_False] NULL,
    [FKUnitsOfMeasureDefault] [int] NULL,
    CONSTRAINT [PK_INVPNTypeLkp] PRIMARY KEY NONCLUSTERED
    ([INVMatlTypeLkpID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]

    /*******************************************************************************************************/

    • Post Points: 35
  • 07-09-2008 8:12 AM In reply to

    • blake05
    • Top 25 Contributor
    • Joined on 04-03-2008
    • Wisconsin
    • Posts 333
    • Points 5,930

    Re: View based on Table using GUID as Primary Key

    Hello, 

    What set of templates are you using to generate?

    Thanks

    -Blake Niemyjski 

    Blake Niemyjski

    CodeSmith Tools, LLC Support Specialist

    Blog: http://windowscoding.com/blogs/blake/

    ----------------------------------------------------------------------
     Member of the .NetTiers team | Visit http://www.nettiers.com
    ----------------------------------------------------------------------

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems