Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
help on using sqlcechangetracking

Unanswered help on using sqlcechangetracking

  • Saturday, December 03, 2011 3:44 AM
     
      Has Code
    Sign In to Vote
    0

    1. first i don't use ms sync, can i still use it?.

    2. can i use multiple changetracking to track multiple tables or i can only use 1 for all table (on same database).

     

    here some of my code, i'm building mdi application and i need to track each commit from each table, or at least a table

    SqlCeChangeTracking DBTracker = null;

private void KSPWin_Load(object sender, EventArgs e)
        {
            koneksi.Open();
            DBTracker = new SqlCeChangeTracking(transKon);
            DBTracker.EnableTracking("MASTER_USER", TrackingKeyType.PrimaryKey, TrackingOptions.All);
            
        }

    now what should i use, i was thinking using timer and check changes by using 

    lastcomm = DBTracker.GetLastCommittedCsn();

    i got error this transaction has complete. and sql compact online book doesn't give some code to explain what each member do.

    any thought? i do need some tutorials on using it :)

    • Moved by Papy Normand Saturday, December 03, 2011 10:17 PM Not related to SQL Server Express but SQL Server Compact (From:Getting started with SQL Server)
    •  
     

All Replies

  • Saturday, December 03, 2011 10:15 PM
     
     
    Sign In to Vote
    0

    Hello,

    Your question is related to the SQL Server Compact Edition which has a specific forum where i will move your thread.

    This forum is only for questions related to the Express Edition of SQL Server.

    Have a nice day

    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.
     
  • Saturday, December 03, 2011 10:19 PM
     
     
    Sign In to Vote
    0

    Hello,

    Move done.

    I hope you will find a full and quick answer on this forum which is devoted to the SQL Server Compact Edition

    Have a nice day

    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.
     
  • Wednesday, February 01, 2012 7:44 AM
     
     
    Sign In to Vote
    0

    check this thread

    http://social.microsoft.com/Forums/en/syncgeneral/thread/49656be9-4992-4e38-9143-b9a12f0e44ff