locked
Duplicated columns on client ce db RRS feed

  • Question

  • Hi:
    I created a Contact Sync Project following OfflineAppDemo1 guildline.  My Contact table on the Server is as follows:

    CREATE TABLE [dbo].[Contact](
        [ContactID] [int] NOT NULL,
        [FirstName] [nvarchar](50) NULL,
        [LastName] [nvarchar](50) NULL,
        [HomePhone] [nvarchar](30) NULL,
        [CreateUserID] [nvarchar](50) NULL,
        [LastUpdateUserID] [nvarchar](50) NULL,
        [UpdateClientID] [int] NULL CONSTRAINT [DF_Contact_UpdateClientID]  DEFAULT ((0)),
        [create_timestamp] [bigint] NULL DEFAULT (@@dbts+(1)),
        [update_timestamp] [timestamp] NOT NULL,
     CONSTRAINT [PK_Contact] PRIMARY KEY CLUSTERED
    (
        [ContactID] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    ) ON [PRIMARY]

    After the synchronization, all the columns on the client sqlce Contact table got duplicated like:
    Contact, FirstName, LastName, ..., ContactID1, FirstName1, LastName1...etc

    Any Idea? Many thanks!


    • Moved by Max Wang_1983 Friday, April 22, 2011 9:12 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Saturday, December 22, 2007 1:18 PM

All replies

  •  

    Interesting. could you check your selectIncrementInsert query on the sync adapter for this table ?

     

    if possible, could you hook up to the CreatingSchemaEvnet on the client provider to dump the sync schema object to see what the content is in it ? this should give up some hint on this issue.

     

    thanks

    Yunwen

    Sunday, December 23, 2007 6:33 PM
    Moderator