none
help on using sqlcechangetracking

    Question

  • 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)
    Saturday, December 03, 2011 3:44 AM

All replies

  • 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:15 PM
  • 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.
    Saturday, December 03, 2011 10:19 PM
  • check this thread

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

    Wednesday, February 01, 2012 7:44 AM