Multiple clients to 1 server (upload only)

[sneakwish]

When I try to sync multiple client sqlite databases, it overwrites the other clients data in de server database. How do I fix this?
Sorry I'm new to this. Here's my code, all my tables have a relation to each other:

 public async Task SynchronizeDBAsync()
        {
            Logger.Instance.Info("Starting Database Sync");
            // Sqlite Client provider acting as the "server"
            SqlSyncProvider serverProvider = new SqlSyncProvider(@"Data Source=(LOCALDB)\local;Initial Catalog=test2;Integrated Security=True");
            // Sqlite Client provider acting as the "client"
            SqliteSyncProvider clientProvider = new SqliteSyncProvider(Db.DbPath);

            // Tables involved in the sync process:
            var setup = new SyncSetup("Session", "Mission", "Info", "Freeroam");
            setup.Tables["Session"].SyncDirection = SyncDirection.UploadOnly;
            setup.Tables["Mission"].SyncDirection = SyncDirection.UploadOnly;
            setup.Tables["Info"].SyncDirection = SyncDirection.UploadOnly;
            setup.Tables["Freeroam"].SyncDirection = SyncDirection.UploadOnly;

            // Sync agent
            SyncAgent agent = new SyncAgent(clientProvider, serverProvider);

            try
            {
                var result = await agent.SynchronizeAsync(setup);
                if (result != null)
                    Logger.Instance.Info(result.ToString());
            }
            catch (Exception e)
            {
                Logger.Instance.Info("Error Syncing Database: " + e);
            }```

[Mimetis]

Are you using identity auto increment primary keys ?

[sneakwish]

No, sorry I dont know how you can do that. Can you setup this with C# code?

[Mimetis]

It's a question to understand what is your problem, not a solution you need to implement....

[Mimetis]

I need a sample to be able to reproduce or mode details, otherwise it will be difficult to help you here

[sneakwish]

 public class DataloggerContext : DbContext
    {
        public DbSet<Session> Session { get; set; }
        public DbSet<Mission> Scenario { get; set; }
        public DbSet<Freeroam> Freeroam { get; set; }
        public DbSet<Info> ShipLocation { get; set; }

        public string DbPath { get; }

        public DataloggerContext()
        {
            string FolderName = "" + Environment.GetFolderPath(Environment.SpecialFolder.UserProfile) + "\\Data\\";
            DbPath = FolderName + "database.db";
            Database.EnsureCreated();
        }

        protected override void OnConfiguring(DbContextOptionsBuilder options)
        {
            options.UseSqlServer($"Data Source=(LocalDb)\\local;Initial Catalog=test2;Integrated Security=True");
            //options.UseSqlite($"Data Source={DbPath}");
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Session>()
                .Property(b => b.Id)
                .ValueGeneratedOnAdd()
                .UseSqlServerIdentityColumn();
        }

I create the database with Database.EnsureCreated();
I tried to implement the identity on the id with OnModelCreating ValueGeneratedOnAdd() and UseSqlServerIdentityColumn();
I also tried it with dataAnnotations: [DatabaseGenerated(DatabaseGeneratedOption.Identity)]

Nothing works. Can you help me?

[Mimetis]

need a sample to reproduce

[sneakwish]

tablestest.zip

when i start the program it will create a new sqlite database.
When I add stuff in the sqlite database, it syncs with the serverDB but when I delete the local sqlite database, Irun the program it will create a new sqlitedatabase but when that one syncs it overwrites the old data. I'm not sure how to implement identity auto increment primary keys.

[Mimetis]

your Id in table User is auto increment, that's why multiple clients will insert new user with same identity key, that will sync as an update and not an insert
if you want to work with multiple clients change your primary keys from int to guid