Xamarin and Web API Hosted on Azure with Azure SQL DB

[sisaacks]

I have an Xamarin that is currently using a local sqlite database. I have been reading through the dotmim and asp.net web api tutorials and I am a little confused. Please excuse my ignorance about all this, I am new and trying to learn.

1. When I set up my web api, do I need to follow the instructions and set up a controller and db context for each table? OR do I simply use the controller referenced in the dotmim documentation? The dotmim documentation makes it seem like that is the only controller I need? But then I am confused how to link my web api up to Azure and the Azure SQL.

2. Once I call the sync function when the app starts, I am assuming this aligns the client and the server data. Will syncing thing happen automagically every time the local DB changes or do I need to call the sync function every time there is an update to the local db? I want the local DB and Sever to be in sync as much as possible.

If I can get these answered I think its a good start. I know I will have more to come. Thank you for anyone that can send me down the correct path.

[maxrodro]

Hi @sisaacks

I'll give you some examples that I'm using in my projects

API Example:

using Dotmim.Sync;
using Dotmim.Sync.Enumerations;
using Dotmim.Sync.SqlServer;
using Dotmim.Sync.Web.Server;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using Falcon.Assistance.Core.API.Class;
using Falcon.Assistance.Core.API.Constants;
using System;
using System.Threading.Tasks;

namespace Falcon.Assistance.Core.API.Controllers
{
    //[Authorize]
    [Route("api/[controller]")]
    [ApiController]
    public class SyncController : ControllerBase
    {
        private readonly IConfiguration Configuration;

        // The WebServerManager instance is useful to manage all
        // the Web server orchestrators registered in the Startup.cs
        public WebServerOrchestrator Orchestrator { get; }

        // Injected thanks to Dependency Injection
        public SyncController(WebServerOrchestrator webServerOrchestrator, IConfiguration configuration)
        {
            Orchestrator = webServerOrchestrator;
            Configuration = configuration;
        }              

        /// <summary>
        /// This POST handler is mandatory to handle all the sync process
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        public Task Post() => this.Orchestrator.HandleRequestAsync(this.HttpContext);

        /// <summary>
        /// This GET handler is optional. It allows you to see the configuration hosted on the server
        /// </summary>
        [HttpGet]
        public Task Get() => WebServerOrchestrator.WriteHelloAsync(this.HttpContext, this.Orchestrator);       
      
    }
}

API Startup
` public class Startup
{
private readonly ILogger Logger;
internal static IConfiguration Configuration { get; set; }

    public Startup(IConfiguration configuration)
    {
        Configuration = configuration;
    }

    // This method gets called by the runtime. Use this method to add services to the container.
    public void ConfigureServices(IServiceCollection services)
   {
        #region Token

        services.AddSingleton(Configuration);
        services.AddDistributedMemoryCache();
        services.AddSession(options => options.IdleTimeout = TimeSpan.FromMinutes(30));

        services.AddDbContext<FalconAppsContext>(options => options.UseSqlServer(Configuration.GetConnectionString("FalconAppsConnection")));

        services.AddControllers().AddNewtonsoftJson(options => options.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore);

        var key = System.Text.Encoding.UTF8.GetBytes(Configuration["TokenKey"]);

        // Adding a default authentication system
        JwtSecurityTokenHandler.DefaultInboundClaimTypeMap.Clear(); // => remove default claims

        services.AddAuthentication(JwtBearerDefaults.AuthenticationScheme).AddJwtBearer(options =>
                {
                    options.RequireHttpsMetadata = false;
                    options.SaveToken = true;
                    options.TokenValidationParameters = new TokenValidationParameters
                    {
                        ValidIssuer = "Dotmim.Sync.Bearer",
                        ValidAudience = "Dotmim.Sync.Bearer",
                        IssuerSigningKey = new SymmetricSecurityKey(key)
                    };

                    options.Events = new JwtBearerEvents
                    {
                        OnAuthenticationFailed = context =>
                        {
                            Debug.WriteLine("OnAuthenticationFailed: " + context.Exception.Message);
                            return Task.CompletedTask;
                        },
                        OnTokenValidated = context =>
                        {
                            Debug.WriteLine("OnTokenValidated: " + context.SecurityToken);
                            return Task.CompletedTask;
                        }
                    };
                });

        services.AddControllers();

        //Dotmim Configuration
        services.AddMemoryCache();

        #endregion Token

        // [Required]: Get a connection string to your server data source
        var connectionString = Configuration.GetConnectionString("FalconAppsConnection");

        // [Required]: Add a SqlSyncProvider acting as the server hub.
        services.AddSyncServer<SqlSyncChangeTrackingProvider>(connectionString, Constants.SyncFuelGasTables.SyncTablesPrefixFilterConfig);

        


    }

    // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
    public void Configure(IApplicationBuilder app, IWebHostEnvironment env, ILoggerFactory loggerFactory)
    {
        if (env.IsDevelopment())
        {
            app.UseDeveloperExceptionPage();


        }

        var databaseEnviroment = Configuration.GetConnectionString("FalconAppsConnection").Split(";")[1];

        var logger = loggerFactory.CreateLogger("Startup");
        logger.LogError(databaseEnviroment);

        app.UseCors(x => x
                     .AllowAnyMethod()
                     .AllowAnyHeader()
                     .SetIsOriginAllowed(origin => true) // allow any origin
                     .AllowCredentials()); // allow credentials

        //app.UseCors("CorsPolicy");

        app.UseRouting();
        app.UseAuthentication();
        app.UseAuthorization();

        app.UseDefaultFiles();
        app.UseStaticFiles();
        app.UseSession();
        app.UseEndpoints(endpoints =>
        {
            endpoints.MapControllers();
        });
    }
}`

Xamarin Example:
`private async void SyncData_Clicked(object sender, EventArgs e)
{
if (IsBusy) return;

        if (Xamarin.Essentials.Connectivity.NetworkAccess != Xamarin.Essentials.NetworkAccess.Internet)
        {
            await DisplayAlert("Información", "No hay conexión con internet", "OK");
            return;
        }

        try
        {
            
            //Sync Data
            IsBusy = true;

            LogCollection.Clear();

            //App.Token = GenerateJwtToken(CompanyName, CompanyId);
            HttpClient httpClient = new HttpClient();
            //httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", App.Token);
            
            var options = new SyncOptions() { CleanMetadatas = true, DisableConstraintsOnApplyChanges = true };

            // Adding the HttpClient instance to the web client orchestrator
            string URL= "http://192.168.1.100:5001/api/sync";
            var serverOrchestrator = new WebClientOrchestrator(URL, client: httpClient);

            // Second provider is using plain old Sql Server provider, relying on triggers and tracking tables to create the sync environment
            var clientProvider = new SqliteSyncProvider(App.StorageDBPath);

            //var clientOptions = new SyncOptions { BatchSize = 3000 };

            // Creating an agent that will handle all the process
            var agent = new SyncAgent(clientProvider, serverOrchestrator, options);
            agent.Parameters.Add("CompanyId", CompanyId);

            var progress = new SynchronousProgress<ProgressArgs>(pa =>
            {
                var text = $"{pa.ProgressPercentage:p}:  \t[{pa.Source[..Math.Min(4, pa.Source.Length)]}] \t{pa.Message}";

                Console.WriteLine(text);
                LogCollection.Insert(0, text);

                Message = $"Sincronizando datos, por favor espere .... ({ pa.ProgressPercentage})";
            });

            var s1 = await agent.SynchronizeAsync(progress);

            System.Diagnostics.Debug.WriteLine(s1);
            LogCollection.Add($"Total Changes Applied: {s1.TotalChangesApplied}");
            LogCollection.Add($"Total Changes Downloaded: {s1.TotalChangesDownloaded}");
            LogCollection.Add($"Total Changes Uploaded: {s1.TotalChangesUploaded}");
            LogCollection.Add($"Total Resolved Conflicts: {s1.TotalResolvedConflicts}");
            LogCollection.Add($"Total Sync Errors: {s1.TotalSyncErrors}");
                           
           
        }
        catch (Exception ex)
        {
            IsBusy = false;
            var message = Class.ExceptionManager.ExceptionDetailCatch(ex);
            await DisplayAlert("Error", message, "OK");
        }
    }`

[sisaacks]

@maxrodro thank you for the info, I have a couple questions

1. I see your controller, you only have one, a SyncController. In t he web api example's I have seen, they create a controller for every table....do you still need to do that with dotmim sync? This part I find confusing because I have not found a definitive answer to this question.

2. You have set up a button click event to sync the data from what I see. So to sync the data you have to call that function every time. We want the local and server to be in sync as much as possible. So I would have to call that sync method every time the local DB updated correct? Or is that a bad idea....should the sync only happen every so often?

thank you again for the information, I am trying wrap my head around this and what needs to be done.

[sisaacks]

@maxrodro my limited web experience is from 2009 in college...so a I appreciate the help. It seems everything I read has a different answer or way to do it and its confusing. I have the web api up and running. Now to connect from the sample app. Thank you again.

[sisaacks]

I am getting an error I am not sure why...that my table does not exist. I thought that DotMimSync would automatically add it to the Azure Database. i am not sure what I am doing wrong. I am also copying in my web api program.cs

{Dotmim.Sync.Web.Client.HttpSyncWebException: Table Vehicle does not exists.

at Dotmim.Sync.RemoteOrchestrator.EnsureSchemaAsync(DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress) at Dotmim.Sync.Web.Server.WebServerOrchestrator.EnsureSchemaAsync(HttpContext httpContext, HttpMessageEnsureScopesRequest httpMessage, SessionCache sessionCache, CancellationToken cancellationToken, IProgress1 progress)
at Dotmim.Sync.Web.Server.WebServerOrchestrator.HandleRequestAsync(HttpContext httpContext, Action1 action, CancellationToken cancellationToken, IProgress1 progress)

---

INNER EXCEPTION

Table Vehicle does not exists.

at Dotmim.Sync.BaseOrchestrator.InternalGetTableSchemaAsync(SyncContext context, SyncSetup setup, SetupTable setupTable, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress) at Dotmim.Sync.BaseOrchestrator.InternalGetSchemaAsync(SyncContext context, SyncSetup setup, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress)
at Dotmim.Sync.RemoteOrchestrator.EnsureSchemaAsync(DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress) at Dotmim.Sync.RemoteOrchestrator.EnsureSchemaAsync(DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress)

at Dotmim.Sync.Web.Client.HttpRequestHandler.HandleSyncError (System.Net.Http.HttpResponseMessage response) [0x002b2] in <4080d9514c944cf4b3ae889fb07b8e3b>:0
at Dotmim.Sync.Web.Client.HttpRequestHandler.SendAsync (System.Net.Http.HttpClient client, System.String requestUri, System.String sessionId, System.String scopeName, Dotmim.Sync.Web.Client.HttpStep step, System.Byte[] data, System.String ser, Dotmim.Sync.Serialization.IConverter converter, System.String hashString, System.String contentType, System.Threading.CancellationToken cancellationToken) [0x0036c] in <4080d9514c944cf4b3ae889fb07b8e3b>:0
at Dotmim.Sync.SyncPolicy.InternalExecuteAsync[TResult] (System.Func1[TResult] operation, System.Threading.CancellationToken cancellationToken, System.Object arg) [0x00103] in <4c312695a8674d6890ba8c3e768d18bc>:0 at Dotmim.Sync.Web.Client.HttpRequestHandler.ProcessRequestAsync (System.Net.Http.HttpClient client, System.String baseUri, System.Byte[] data, Dotmim.Sync.Web.Client.HttpStep step, System.Guid sessionId, System.String scopeName, Dotmim.Sync.Serialization.ISerializerFactory serializerFactory, Dotmim.Sync.Serialization.IConverter converter, System.Int32 batchSize, Dotmim.Sync.SyncPolicy policy, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x0037f] in <4080d9514c944cf4b3ae889fb07b8e3b>:0
at Dotmim.Sync.Web.Client.WebClientOrchestrator.EnsureSchemaAsync (System.Data.Common.DbConnection connection, System.Data.Common.DbTransaction transaction, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x00213] in <4080d9514c944cf4b3ae889fb07b8e3b>:0 at Dotmim.Sync.SyncAgent+<>c__DisplayClass53_0.<SynchronizeAsync>b__0 () [0x00e09] in <4c312695a8674d6890ba8c3e768d18bc>:0 at Dotmim.Sync.SyncAgent.SynchronizeAsync (Dotmim.Sync.Enumerations.SyncType syncType, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x00185] in <4c312695a8674d6890ba8c3e768d18bc>:0
at AutomobileApp.Services.NFODataService.SyncData () [0x000c6] in C:\SandBox\AutomobileApp\AutomobileApp\AutomobileApp\Services\NFODataService.cs:73 }

[sisaacks]

Okay.....this is absolutely frustrating...there is something I am missing with the web api. As I stated earlier the Schema is NOT created....I have to go in and run a script on azure sql to create the table. Then I stop getting the error that the Table does not exist. However...the data does not sync either...I no longer get errors but there is no synch happening...meaning the data is in my local db but does not show up on the server

The asp.net web tutorial walks though setting up the schema, but you're saying I dont have to do that dotmim does it for me? I am missing something here and running out of time.

[Mimetis]

Server is the "master node". He is basically the truth.
Everyone (all Clients) will sync the server locally (and will eventually send their changes)

So far, before you start sync anything (before DMS creates all the metadatas, tracking tables etc) you should be aware of some big differences from Server side / Clients sides:

• You can have only 1 Server
• You can have any numbers of Clients.
• Server MUST exists with a valid schema. DMS will never creates any schema tables on the server side.
• Client may have an existing schema with the exact same schema as Server, otherwise DMS will create it on the first sync.
• Server data already existing BEFORE first sync (Before DMS creates all the tracking things) will be downloaded to all Clients on first sync
• Client data (if you choose to start with an existing client database) will NOT be uploaded on the first sync.
  • All data after the first sync will be uploaded (because they are tracked) of course

In your case:

• Be sure to have an existing Server database with an existing schema
• You should try to start from scratch with no clients database and see if it works.
• Eventually once you masterize everything, you can think to start with more complex scenario (like handling existing clients)

Now, if you really want to upload existing data from clients (once again, before everything is configured by DMS, and so far, tracked), you can use an hidden gem on LocalOrchestrator : the UpdateUntrackedRowsAsync method.
This method will not work if you are using the SqlChangeTrackingProvider on the client side. See #342

[sisaacks]

So if I have an existing row, in my client database can you explain how I use the LocalOrchestrator? I am not sure what you mean by that? I have yet to be able to get the data to sync. I can add data but nothing happens. I am not sure what I am doing wrong.

[sisaacks]

Okay...I think you have answered part of my question. How do I generate the schema on the server. I have followed the tutorial but I cannot get the CLI to install the .dotnet ef. I keep getting an error about a preview release......I found some info on it, but I cant find what preview version it is. So from my understanding above...if the schema is defined on the server but not the client....the schema will be created on the client side but if the schema is on the client it will never be created on the client. As of right now I cannot figure out how to get the schema generated on the server according to your last bullet above on *Client Data*, I am slightly confused, I do two syncs to begin with (shouldn't the client data be uploaded to the server on the second sync) // Launch the sync process var s1 = await agent.SynchronizeAsync(); /// Make as second sync. (should the data from the client now be uploaded to the server) ?? // All local rows that were existing before first sync happened, will be uploaded correctly s1 = await agent.SynchronizeAsync()

…

On Mon, May 9, 2022 at 12:26 PM Sébastien Pertus ***@***.***> wrote: *Server* is the "master node". He is basically the truth. Everyone (all *Clients*) will sync the server locally (and will eventually send their changes) So far, before you start sync anything (before *DMS* creates all the metadatas, tracking tables etc) you should be aware of some big differences from *Server* side / *Clients* sides: - You can have only *1 Server* - You can have *any numbers of Clients*. - *Server* MUST exists with a valid schema. *DMS* will never creates any schema tables on the server side. - *Client* may have an existing schema with the exact same schema as *Server*, otherwise *DMS* will create it on the first sync. - *Server* data already existing *BEFORE* first sync (Before DMS creates all the tracking things) will be downloaded to all *Clients* on first sync - *Client* data (if you choose to start with an existing client database) will NOT be uploaded on the first sync. - All data after the first sync will be uploaded (because they are tracked) of course In your case: - Be sure to have an existing *Server* database with an existing schema - You should try to start from scratch with no clients database and see if it works. - Eventually once you masterize everything, you can think to start with more complex scenario (like handling existing clients) Now, if you really want to upload existing data from clients (once again, before everything is configured by *DMS*, and so far, tracked), you can use an hidden gem on LocalOrchestrator : the UpdateUntrackedRowsAsync method. This method will not work if you are using the SqlChangeTrackingProvider on the client side. See #342 <#342> — Reply to this email directly, view it on GitHub <#730 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOZ5VYA3G2ENSYQTPT3BB63VJFRE7ANCNFSM5UT5BTVA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[Mimetis]

1)You are responsible of the server side schema. It's not a DMS story

2. All data inserted / deleted / updated between the first sync and second sync, will be ... synced

[sisaacks]

Understood, i simply cannot get the CLI to work for the database migration. Thank you for your help on DMS SUA SPONTE -- Its better to fail while daring greatly, than to be with those cold and timid souls who neither know victory nor defeat. -- Someone once told me not to bite off more than I could chew. I said I'd rather choke on greatness than nibble on mediocrity.

…

On May 9, 2022, at 12:51, Sébastien Pertus ***@***.***> wrote:  1)You are responsible of the server side schema. It's not a DMS story All data inserted / deleted / updated between the first sync and second sync, will be ... synced — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.

[sisaacks]

So I did this...and the data was not synced between the first and second sync....meaning it was not pushed to the server. I am not sure what I am doing wrong. var options = new SyncOptions() { CleanMetadatas = true, DisableConstraintsOnApplyChanges = true }; var serverOrchestrator = new WebClientOrchestrator(" https://automobilewebapi.azurewebsites.net/api/sync"); var clientProvider = new SqliteSyncProvider(connection.DatabasePath); var tables = new string[] { "Vehicle" }; var agent = new SyncAgent(clientProvider, serverOrchestrator, tables); // Launch the sync process var s1 = await agent.SynchronizeAsync(); // Write results Console.WriteLine(s1); // Get local schema for the FIRST client sync var scope = await agent.LocalOrchestrator.GetSchemaAsync(); // insert the new item into the database if (ShouldSeedData()) { var vehicle = new Vehicle { Color = "Silver", Id = Guid.NewGuid(), Make = "RAM", Model = "TRX", VehicleType = VehicleType.Truck, Year = "2021" }; connection.Insert(vehicle); } /// Make as second sync. // All local rows that were existing before first sync happened, will be uploaded correctly s1 = await agent.SynchronizeAsync(); // Write results Console.WriteLine(s1); On Mon, May 9, 2022 at 1:04 PM Seth Isaacks ***@***.***> wrote:

…

Understood, i simply cannot get the CLI to work for the database migration. Thank you for your help on DMS *SUA SPONTE* -- Its better to fail while daring greatly, than to be with those cold and timid souls who neither know victory nor defeat. -- Someone once told me not to bite off more than I could chew. I said I'd rather choke on greatness than nibble on mediocrity. On May 9, 2022, at 12:51, Sébastien Pertus ***@***.***> wrote:  1)You are responsible of the server side schema. It's not a DMS story 1. All data inserted / deleted / updated between the first sync and second sync, will be ... synced — Reply to this email directly, view it on GitHub <#730 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOZ5VYFV6EKNPRRBHO5P773VJFUCPANCNFSM5UT5BTVA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[sisaacks]

I also tried adding an item and syncing again, still doesnt work. I am not sure what i have done wrong. This is very frustrating. I followed your tutorial to a T On Mon, May 9, 2022 at 5:58 PM Seth Isaacks ***@***.***> wrote:

…

So I did this...and the data was not synced between the first and second sync....meaning it was not pushed to the server. I am not sure what I am doing wrong. var options = new SyncOptions() { CleanMetadatas = true, DisableConstraintsOnApplyChanges = true }; var serverOrchestrator = new WebClientOrchestrator(" https://automobilewebapi.azurewebsites.net/api/sync"); var clientProvider = new SqliteSyncProvider(connection.DatabasePath); var tables = new string[] { "Vehicle" }; var agent = new SyncAgent(clientProvider, serverOrchestrator, tables); // Launch the sync process var s1 = await agent.SynchronizeAsync(); // Write results Console.WriteLine(s1); // Get local schema for the FIRST client sync var scope = await agent.LocalOrchestrator.GetSchemaAsync(); // insert the new item into the database if (ShouldSeedData()) { var vehicle = new Vehicle { Color = "Silver", Id = Guid.NewGuid(), Make = "RAM", Model = "TRX", VehicleType = VehicleType.Truck, Year = "2021" }; connection.Insert(vehicle); } /// Make as second sync. // All local rows that were existing before first sync happened, will be uploaded correctly s1 = await agent.SynchronizeAsync(); // Write results Console.WriteLine(s1); On Mon, May 9, 2022 at 1:04 PM Seth Isaacks ***@***.***> wrote: > Understood, i simply cannot get the CLI to work for the database > migration. Thank you for your help on DMS > > *SUA SPONTE* > -- Its better to fail while daring greatly, than to be with those cold > and timid souls who neither know victory nor defeat. > -- Someone once told me not to bite off more than I could chew. I said > I'd rather choke on greatness than nibble on mediocrity. > > On May 9, 2022, at 12:51, Sébastien Pertus ***@***.***> > wrote: > >  > > 1)You are responsible of the server side schema. It's not a DMS story > > 1. All data inserted / deleted / updated between the first sync and > second sync, will be ... synced > > — > Reply to this email directly, view it on GitHub > <#730 (reply in thread)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AOZ5VYFV6EKNPRRBHO5P773VJFUCPANCNFSM5UT5BTVA> > . > You are receiving this because you were mentioned.Message ID: > ***@***.***> > >

[sisaacks]

Here is my web api file......i am absolutely no clue why this is not working using Dotmim.Sync; using Dotmim.Sync.SqlServer; using Azure.Identity; using Microsoft.EntityFrameworkCore; using AutomobileWebApi.Models; var builder = WebApplication.CreateBuilder(args); //builder.Services.AddDbContext<VehicleDb>(opt => opt.UseSqlServer(builder.Configuration.GetConnectionString("NfoConnectionString"))); //builder.Services.AddDatabaseDeveloperPageExceptionFilter(); //var keyVaultEndpoint = new Uri(Environment.GetEnvironmentVariable("VaultUri")); //builder.Configuration.AddAzureKeyVault(keyVaultEndpoint, new DefaultAzureCredential()); // Add services to the container. builder.Services.AddControllersWithViews(); builder.Services.AddDistributedMemoryCache(); builder.Services.AddSession(options => options.IdleTimeout = TimeSpan.FromMinutes(30)); // [Required]: Get a connection string to your server data source var connectionString = builder.Configuration.GetConnectionString("NfoConnectionString"); // [Required] Tables involved in the sync process: var tables = new string[] {"Vehicle" }; var options = new SyncOptions { }; // [Required]: Add a SqlSyncProvider acting as the server hub. builder.Services.AddSyncServer<SqlSyncProvider>(connectionString, tables, options); var app = builder.Build(); // Configure the HTTP request pipeline. //if (!app.Environment.IsDevelopment()) //{ // app.UseExceptionHandler("/Home/Error"); // // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts. // app.UseHsts(); //} app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseRouting(); app.UseAuthorization(); app.UseSession(); app.MapControllers(); app.MapControllerRoute( name: "default", pattern: "{controller=Home}/{action=Index}/{id?}"); app.Run(); On Mon, May 9, 2022 at 6:04 PM Seth Isaacks ***@***.***> wrote:

…

I also tried adding an item and syncing again, still doesnt work. I am not sure what i have done wrong. This is very frustrating. I followed your tutorial to a T On Mon, May 9, 2022 at 5:58 PM Seth Isaacks ***@***.***> wrote: > So I did this...and the data was not synced between the first and second > sync....meaning it was not pushed to the server. > I am not sure what I am doing wrong. > > var options = new SyncOptions() { CleanMetadatas = true, > DisableConstraintsOnApplyChanges = true }; > var serverOrchestrator = new WebClientOrchestrator(" > https://automobilewebapi.azurewebsites.net/api/sync"); > var clientProvider = new > SqliteSyncProvider(connection.DatabasePath); > var tables = new string[] { "Vehicle" }; > var agent = new SyncAgent(clientProvider, > serverOrchestrator, tables); > > // Launch the sync process > var s1 = await agent.SynchronizeAsync(); > > // Write results > Console.WriteLine(s1); > > // Get local schema for the FIRST client sync > var scope = await > agent.LocalOrchestrator.GetSchemaAsync(); > > // insert the new item into the database > if (ShouldSeedData()) > { > var vehicle = new Vehicle > { > Color = "Silver", > Id = Guid.NewGuid(), > Make = "RAM", > Model = "TRX", > VehicleType = VehicleType.Truck, > Year = "2021" > }; > > connection.Insert(vehicle); > } > > > /// Make as second sync. > // All local rows that were existing before first sync > happened, will be uploaded correctly > s1 = await agent.SynchronizeAsync(); > > // Write results > Console.WriteLine(s1); > > On Mon, May 9, 2022 at 1:04 PM Seth Isaacks < > ***@***.***> wrote: > >> Understood, i simply cannot get the CLI to work for the database >> migration. Thank you for your help on DMS >> >> *SUA SPONTE* >> -- Its better to fail while daring greatly, than to be with those cold >> and timid souls who neither know victory nor defeat. >> -- Someone once told me not to bite off more than I could chew. I said >> I'd rather choke on greatness than nibble on mediocrity. >> >> On May 9, 2022, at 12:51, Sébastien Pertus ***@***.***> >> wrote: >> >>  >> >> 1)You are responsible of the server side schema. It's not a DMS story >> >> 1. All data inserted / deleted / updated between the first sync and >> second sync, will be ... synced >> >> — >> Reply to this email directly, view it on GitHub >> <#730 (reply in thread)>, >> or unsubscribe >> <https://github.com/notifications/unsubscribe-auth/AOZ5VYFV6EKNPRRBHO5P773VJFUCPANCNFSM5UT5BTVA> >> . >> You are receiving this because you were mentioned.Message ID: >> ***@***.***> >> >>

[sisaacks]

Sebastian the other thing I may mention, and maybe you have dealt with this before, but I am connecting to a DB hosted in Azure. I have went through all your tutorials, I can access the web api.....everything is working fine...other than data syncing I have the same schema I have a sqlite lite local db and a Azure Sql Server db I have only one client and one Server I have no explanation as to why the data will not sync Other than in my web api, do I need a controller for every table or does the sync table take care of that? There has to be something I am missing On Mon, May 9, 2022 at 6:12 PM Seth Isaacks ***@***.***> wrote:

…

Here is my web api file......i am absolutely no clue why this is not working using Dotmim.Sync; using Dotmim.Sync.SqlServer; using Azure.Identity; using Microsoft.EntityFrameworkCore; using AutomobileWebApi.Models; var builder = WebApplication.CreateBuilder(args); //builder.Services.AddDbContext<VehicleDb>(opt => opt.UseSqlServer(builder.Configuration.GetConnectionString("NfoConnectionString"))); //builder.Services.AddDatabaseDeveloperPageExceptionFilter(); //var keyVaultEndpoint = new Uri(Environment.GetEnvironmentVariable("VaultUri")); //builder.Configuration.AddAzureKeyVault(keyVaultEndpoint, new DefaultAzureCredential()); // Add services to the container. builder.Services.AddControllersWithViews(); builder.Services.AddDistributedMemoryCache(); builder.Services.AddSession(options => options.IdleTimeout = TimeSpan.FromMinutes(30)); // [Required]: Get a connection string to your server data source var connectionString = builder.Configuration.GetConnectionString("NfoConnectionString"); // [Required] Tables involved in the sync process: var tables = new string[] {"Vehicle" }; var options = new SyncOptions { }; // [Required]: Add a SqlSyncProvider acting as the server hub. builder.Services.AddSyncServer<SqlSyncProvider>(connectionString, tables, options); var app = builder.Build(); // Configure the HTTP request pipeline. //if (!app.Environment.IsDevelopment()) //{ // app.UseExceptionHandler("/Home/Error"); // // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts. // app.UseHsts(); //} app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseRouting(); app.UseAuthorization(); app.UseSession(); app.MapControllers(); app.MapControllerRoute( name: "default", pattern: "{controller=Home}/{action=Index}/{id?}"); app.Run(); On Mon, May 9, 2022 at 6:04 PM Seth Isaacks ***@***.***> wrote: > I also tried adding an item and syncing again, still doesnt work. > I am not sure what i have done wrong. > This is very frustrating. > I followed your tutorial to a T > > On Mon, May 9, 2022 at 5:58 PM Seth Isaacks < > ***@***.***> wrote: > >> So I did this...and the data was not synced between the first and second >> sync....meaning it was not pushed to the server. >> I am not sure what I am doing wrong. >> >> var options = new SyncOptions() { CleanMetadatas = true, >> DisableConstraintsOnApplyChanges = true }; >> var serverOrchestrator = new WebClientOrchestrator(" >> https://automobilewebapi.azurewebsites.net/api/sync"); >> var clientProvider = new >> SqliteSyncProvider(connection.DatabasePath); >> var tables = new string[] { "Vehicle" }; >> var agent = new SyncAgent(clientProvider, >> serverOrchestrator, tables); >> >> // Launch the sync process >> var s1 = await agent.SynchronizeAsync(); >> >> // Write results >> Console.WriteLine(s1); >> >> // Get local schema for the FIRST client sync >> var scope = await >> agent.LocalOrchestrator.GetSchemaAsync(); >> >> // insert the new item into the database >> if (ShouldSeedData()) >> { >> var vehicle = new Vehicle >> { >> Color = "Silver", >> Id = Guid.NewGuid(), >> Make = "RAM", >> Model = "TRX", >> VehicleType = VehicleType.Truck, >> Year = "2021" >> }; >> >> connection.Insert(vehicle); >> } >> >> >> /// Make as second sync. >> // All local rows that were existing before first sync >> happened, will be uploaded correctly >> s1 = await agent.SynchronizeAsync(); >> >> // Write results >> Console.WriteLine(s1); >> >> On Mon, May 9, 2022 at 1:04 PM Seth Isaacks < >> ***@***.***> wrote: >> >>> Understood, i simply cannot get the CLI to work for the database >>> migration. Thank you for your help on DMS >>> >>> *SUA SPONTE* >>> -- Its better to fail while daring greatly, than to be with those cold >>> and timid souls who neither know victory nor defeat. >>> -- Someone once told me not to bite off more than I could chew. I said >>> I'd rather choke on greatness than nibble on mediocrity. >>> >>> On May 9, 2022, at 12:51, Sébastien Pertus ***@***.***> >>> wrote: >>> >>>  >>> >>> 1)You are responsible of the server side schema. It's not a DMS story >>> >>> 1. All data inserted / deleted / updated between the first sync and >>> second sync, will be ... synced >>> >>> — >>> Reply to this email directly, view it on GitHub >>> <#730 (reply in thread)>, >>> or unsubscribe >>> <https://github.com/notifications/unsubscribe-auth/AOZ5VYFV6EKNPRRBHO5P773VJFUCPANCNFSM5UT5BTVA> >>> . >>> You are receiving this because you were mentioned.Message ID: >>> ***@***.***> >>> >>>

[Vextamour]

I've been seeing tons of messages on this discussion so maybe I can help. Make sure both your WebAPI and client application both have the exact same version from NuGet Package Manager of DotMimSync. I'm running 0.94 on both applications. Below is my WebAPI code and my (client) WPF application code. What happens when I run my WPF application is it creates a local SQLite database that is encrypted with SQLCipher and builds the schema locally automatically via DotMimSync. My central server is an Azure SQL Server. You'll notice I've parametrized everything within the application so you'd have to change it to all your own calls either hard coded or parameters.

WebAPI: (Note that in my tables variable I'm pulling a list of tables from a JSON file. You could have just as easily hard coded every table you want to sync there with code like this "TableA,TableB,TableC"). I'm also using Auth0 for authentication and authorization so you can ignore all that for now until you get everything working. Also, it's important under your Configure method you keep all the calls in that exact order.

        public void ConfigureServices(IServiceCollection services)
        {            
            services.AddControllers();
            services.AddControllers().AddJsonOptions(x => x.JsonSerializerOptions.ReferenceHandler = ReferenceHandler.Preserve);

            #region Dotmim Database Sync. Documentation found at https://dotmimsync.readthedocs.io/Overview.html
            services.AddDistributedMemoryCache();
            services.AddSession(options => options.IdleTimeout = TimeSpan.FromMinutes(30));

            // [Required]: Get a connection string to your server data source

            var connectionString = Configuration.GetConnectionString("DbConnectionString");
            

            var options = new SyncOptions { ConflictResolutionPolicy = Dotmim.Sync.Enumerations.ConflictResolutionPolicy.ServerWins };

            // [Required] Tables involved in the sync process. These tables were moved to the configuration JSON file so they are not hard coded here.
            var tables = Configuration["DBServerSyncTables:TableList"].Split(',').ToArray();

            // [Required]: Add a SqlSyncProvider acting as the server hub.
            services.AddSyncServer<SqlSyncChangeTrackingProvider>(connectionString, tables, options);
            #endregion

            services.AddDbContext<DbContext>(options => options.UseSqlServer(Configuration.GetConnectionString("DbConnectionString")));
            services.AddAuthentication(options =>
            {
                options.DefaultAuthenticateScheme = JwtBearerDefaults.AuthenticationScheme;
                options.DefaultChallengeScheme = JwtBearerDefaults.AuthenticationScheme;
            }).AddJwtBearer(options =>
            {
                options.Authority = $"https://{Configuration["Auth0:Domain"]}/";
                options.Audience = Configuration["Auth0:Audience"];
            });


        }

        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
        {


            app.UseHttpsRedirection();

            app.UseRouting();

            app.UseAuthentication();
            app.UseAuthorization();

            app.UseSession();

            app.UseEndpoints(endpoints =>
            {
                endpoints.MapControllers();
            });
        }

WPF Application:

        public static async Task<bool> SynchronizeDBAsync()
        {

                string clientDBConnectionString = Globals.SQLLiteConnectionString;
                string baseUrl = ConfigurationManager.AppSettings["BaseURL"];

                HttpClient httpClient = new HttpClient();
                httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", Globals.Auth0Token.Replace("Bearer ", ""));

                // Adding the HttpClient instance to the web client orchestrator
                var serverOrchestrator = new WebClientOrchestrator($"{baseUrl}api/sync", client: httpClient);

                //var serverOrchestrator = new WebClientOrchestrator("https://localhost:44368/api/sync"); //Uncomment this if you're trying to test the API sync locally
                var clientProvider = new SqliteSyncProvider(clientDBConnectionString);

                var options = new SyncOptions { ConflictResolutionPolicy = ConflictResolutionPolicy.ServerWins };
                
                var agent = new SyncAgent(clientProvider, serverOrchestrator, options);

                var localOrchestrator = agent.LocalOrchestrator;
                var remoteOrchestrator = agent.RemoteOrchestrator;

                try
                {
                    var results = await agent.SynchronizeAsync();

                        MessageBox.Show($"Sync duration: {results.CompleteTime.Subtract(results.StartTime).TotalSeconds}\n" +
                        $"Changes: {results.TotalChangesUploaded}\n" +
                        $"Downloaded: {results.TotalChangesDownloaded}\n" +
                        $"Applied: {results.TotalChangesApplied}\n" +
                        $"Conflicts: {results.TotalResolvedConflicts}");

                    return true;
                }
                catch (Exception e)
                {
                    MessageBox.Show("DB Sync Failed. Closing application and attempting to rebuild database. Please run application again.");
                    log.Error($"Failed on {MethodBase.GetCurrentMethod().DeclaringType} while attemping to sync the server database to local.", e);
                    return false;
                }
        }

Then anywhere in my application that I want to sync up the database for example when they save data from a form or they load a new tab I can simply just call...
_ = DBSync.SynchronizeDatabases.SynchronizeDBAsync();

[sisaacks]

I appreciate this but its quite confusing...I followed the examples in the tutorial....however I cannot get this to work. Everything I try does not work. Here is my client side code, and I get an error on the last sync stating a sync is already in progress. I have spent days on this and everybody gives me something slightly different. For example I using a web api with 6.0.....which does not have the configure methods as your code does.
I am going to include my Xamarin Code File and my Web Api File...maybe someone can explain why this is not syncing.

Currently now when I try the first sync I am getting a strange error
{Dotmim.Sync.SyncException: SQLite Error 1: 'no such column: base.Model'. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 1: 'no such column: base.Model'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC (System.Int32 rc, SQLitePCL.sqlite3 db) [0x0006d] in :0
at Microsoft.Data.Sqlite.SqliteCommand+d__64.MoveNext () [0x00116] in :0
at Microsoft.Data.Sqlite.SqliteCommand.Prepare () [0x00046] in :0
at Dotmim.Sync.DbSyncAdapter.GetCommandAsync (Dotmim.Sync.Builders.DbCommandType commandType, System.Data.Common.DbConnection connection, System.Data.Common.DbTransaction transaction, Dotmim.Sync.SyncFilter filter) [0x001f0] in <4c312695a8674d6890ba8c3e768d18bc>:0
at Dotmim.Sync.BaseOrchestrator.GetSelectChangesCommandAsync (Dotmim.Sync.SyncContext context, Dotmim.Sync.SyncTable syncTable, Dotmim.Sync.SyncSetup setup, System.Boolean isNew, System.Data.Common.DbConnection connection, System.Data.Common.DbTransaction transaction) [0x000e3] in <4c312695a8674d6890ba8c3e768d18bc>:0
at Dotmim.Sync.BaseOrchestrator.ReadSyncTableChangesAsync (Dotmim.Sync.SyncContext context, Dotmim.Sync.SyncTable syncTable, Dotmim.Sync.Batch.BatchInfo batchInfo, Dotmim.Sync.MessageGetChangesBatch message, Dotmim.Sync.DatabaseChangesSelected changesSelected, System.Data.Common.DbConnection connection, System.Data.Common.DbTransaction transaction, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x00150] in <4c312695a8674d6890ba8c3e768d18bc>:0 at Dotmim.Sync.BaseOrchestrator.InternalGetChangesAsync (Dotmim.Sync.SyncContext context, Dotmim.Sync.MessageGetChangesBatch message, System.Data.Common.DbConnection connection, System.Data.Common.DbTransaction transaction, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x0053c] in <4c312695a8674d6890ba8c3e768d18bc>:0
at Dotmim.Sync.LocalOrchestrator.GetChangesAsync (Dotmim.Sync.ScopeInfo localScopeInfo, System.Data.Common.DbConnection connection, System.Data.Common.DbTransaction transaction, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x00582] in <4c312695a8674d6890ba8c3e768d18bc>:0 at Dotmim.Sync.LocalOrchestrator.GetChangesAsync (Dotmim.Sync.ScopeInfo localScopeInfo, System.Data.Common.DbConnection connection, System.Data.Common.DbTransaction transaction, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x006db] in <4c312695a8674d6890ba8c3e768d18bc>:0
--- End of inner exception stack trace ---
at Dotmim.Sync.LocalOrchestrator.GetChangesAsync (Dotmim.Sync.ScopeInfo localScopeInfo, System.Data.Common.DbConnection connection, System.Data.Common.DbTransaction transaction, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x00742] in <4c312695a8674d6890ba8c3e768d18bc>:0 at Dotmim.Sync.SyncAgent+<>c__DisplayClass53_0.<SynchronizeAsync>b__0 () [0x00e09] in <4c312695a8674d6890ba8c3e768d18bc>:0 at Dotmim.Sync.SyncAgent.SynchronizeAsync (Dotmim.Sync.Enumerations.SyncType syncType, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x00185] in <4c312695a8674d6890ba8c3e768d18bc>:0
at AutomobileApp.Services.NFODataService.SyncData () [0x00137] in C:\SandBox\AutomobileApp\AutomobileApp\AutomobileApp\Services\NFODataService.cs:84 }

Here is my Xamarin Client Side Sync Code:
public async Task SyncData()
{
try
{
var test = await GetItems();

            var serverOrchestrator = new WebClientOrchestrator("https://automobilewebapi.azurewebsites.net/api/sync");
            var clientProvider = new SqliteSyncProvider(connection.DatabasePath);
            var tables = new string[] { "Vehicle" };
            var agent = new SyncAgent(clientProvider, serverOrchestrator, tables);

            // Launch the sync process
            var s1 = await agent.SynchronizeAsync();

            // Write results
            Console.WriteLine(s1);

            // Get local schema for the FIRST client sync
            var scope = await agent.LocalOrchestrator.GetSchemaAsync();

            // Update all rows on the client side that does not have any tracking rows
            await agent.LocalOrchestrator.UpdateUntrackedRowsAsync(scope);

            // All local rows that were existing before first sync happened, will be uploaded correctly
            s1 = await agent.SynchronizeAsync();

            // Write results
            Console.WriteLine(s1);
        }
        catch (Exception ex)
        {
            var ruhrowShaggy = ex.ToString();
        }
    }

Here is my Web API Code

using Dotmim.Sync;
using Dotmim.Sync.SqlServer;
using Azure.Identity;
using Microsoft.EntityFrameworkCore;
using AutomobileWebApi.Models;

var builder = WebApplication.CreateBuilder(args);
builder.Services.AddDbContext(opt => opt.UseSqlServer(builder.Configuration.GetConnectionString("NfoConnectionString")));
builder.Services.AddDatabaseDeveloperPageExceptionFilter();
//var keyVaultEndpoint = new Uri(Environment.GetEnvironmentVariable("VaultUri"));
//builder.Configuration.AddAzureKeyVault(keyVaultEndpoint, new DefaultAzureCredential());

// Add services to the container.
builder.Services.AddControllersWithViews();

builder.Services.AddDistributedMemoryCache();
builder.Services.AddSession(options => options.IdleTimeout = TimeSpan.FromMinutes(30));
// [Required]: Get a connection string to your server data source
var connectionString = builder.Configuration.GetConnectionString("NfoConnectionString");

// [Required] Tables involved in the sync process:
var tables = new string[] {"Vehicle" };

var options = new SyncOptions { };

// [Required]: Add a SqlSyncProvider acting as the server hub.
builder.Services.AddSyncServer(connectionString, tables, options);

var app = builder.Build();

// Configure the HTTP request pipeline.
//if (!app.Environment.IsDevelopment())
//{
// app.UseExceptionHandler("/Home/Error");
// // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
// app.UseHsts();
//}

app.UseHttpsRedirection();
app.UseStaticFiles();

app.UseRouting();

app.UseAuthorization();
app.UseSession();

app.MapControllers();

app.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");

app.Run();

[Vextamour]

This error message might mean that your SQLite database is missing a column in your main database. Delete your SQLite database and let DotMim recreate your local SQLite to see if this error message resolves.

{Dotmim.Sync.SyncException: SQLite Error 1: 'no such column: base.Model'. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 1: 'no such column: base.Model'.

[sisaacks]

Now i am getting another error: Dotmim.Sync.Web.Client.HttpSyncWebException: Invalid object name 'Vehicle_tracking' I dont understand why this so difficult. I have followed the tutorial step by step. something is not working correctly I just dumped my sqlite data and its not missing anything. public class Vehicle { [PrimaryKey] public Guid Id { get; set; } public VehicleType VehicleType { get; set; } public string Make { get; set; } public string Year { get; set; } } I can insert and delete with ease I wonder if it has something to do with the primary key is there something I have to declare for DMS on the Webapi? I have been working on this for days now. On Tue, May 10, 2022 at 8:30 AM Seth Isaacks ***@***.***> wrote:

…

I dont understand how to let dotmim create my schema....I have to create my schema for the Sqlite to work. I automatically create the database on loan the app would fail without that database On Tue, May 10, 2022 at 8:24 AM Vext ***@***.***> wrote: > This error message might mean that your SQLite database is missing a > column in your main database. Delete your SQLite database and let DotMim > recreate your local SQLite to see if this error message resolves. > > {Dotmim.Sync.SyncException: SQLite Error 1: 'no such column: base.Model'. > ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 1: 'no such > column: base.Model'. > > — > Reply to this email directly, view it on GitHub > <#730 (reply in thread)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AOZ5VYA4FZRQXQZJZ4TANOLVJJ5SHANCNFSM5UT5BTVA> > . > You are receiving this because you were mentioned.Message ID: > ***@***.***> >

[sisaacks]

A guy mentioned I need to provision my Sql Azure Database?  Is that true?

I have an Xamarin Cross Platform Application which uses a Sqlite DatabaseThe schema is already in place, its built as soon as the app starts.
I have followed the asp.net core web api tutorial.
I have used EF to migrate the objects in the web api to the database on azure.  
Yet I get an error every time I try to sync which makes no sense to me I get Invalid object name Vehicle_TrackingThis happens when I turn on the Change Tracking on the Database and using builder.Services.AddSyncServer(connectionString, tables, options);

If I turn off change tracking and I use SylSyncProvider then I get a different error stating Dotmim.Sync.Web.Client.HttpSyncWebException: Invalid column name 'Model'
But I do not have any column named MODEL.  I have no idea where that is coming from.  Why?

I have tried and tried and tried but I cannot get this to work. 

{Dotmim.Sync.Web.Client.HttpSyncWebException: Invalid object name 'Vehicle_tracking'.

   at Dotmim.Sync.RemoteOrchestrator.ApplyThenGetChangesAsync(ScopeInfo clientScope, BatchInfo clientBatchInfo, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress)    at Dotmim.Sync.Web.Server.WebServerOrchestrator.ApplyThenGetChangesAsync2(HttpContext httpContext, HttpMessageSendChangesRequest httpMessage, SessionCache sessionCache, Int32 clientBatchSize, CancellationToken cancellationToken, IProgress1 progress)
   at Dotmim.Sync.Web.Server.WebServerOrchestrator.HandleRequestAsync(HttpContext httpContext, Action1 action, CancellationToken cancellationToken, IProgress1 progress)

---

INNER EXCEPTION

Invalid object name 'Vehicle_tracking'.

   at Microsoft.Data.SqlClient.SqlCommand.<>c.b__203_0(Task1 result)    at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke()
   at System.Threading.Tasks.Task.<>c.<.cctor>b__272_0(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dotmim.Sync.BaseOrchestrator.ReadSyncTableChangesAsync(SyncContext context, SyncTable syncTable, BatchInfo batchInfo, MessageGetChangesBatch message, DatabaseChangesSelected changesSelected, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress)    at Dotmim.Sync.BaseOrchestrator.InternalGetChangesAsync(SyncContext context, MessageGetChangesBatch message, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress)
   at Dotmim.Sync.RemoteOrchestrator.ApplyThenGetChangesAsync(ScopeInfo clientScope, BatchInfo clientBatchInfo, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress)    at Dotmim.Sync.RemoteOrchestrator.ApplyThenGetChangesAsync(ScopeInfo clientScope, BatchInfo clientBatchInfo, DbConnection connection, DbTransaction transaction, CancellationToken cancellationToken, IProgress1 progress)

  at Dotmim.Sync.Web.Client.HttpRequestHandler.HandleSyncError (System.Net.Http.HttpResponseMessage response) [0x002b2] in <4080d9514c944cf4b3ae889fb07b8e3b>:0
  at Dotmim.Sync.Web.Client.HttpRequestHandler.SendAsync (System.Net.Http.HttpClient client, System.String requestUri, System.String sessionId, System.String scopeName, Dotmim.Sync.Web.Client.HttpStep step, System.Byte[] data, System.String ser, Dotmim.Sync.Serialization.IConverter converter, System.String hashString, System.String contentType, System.Threading.CancellationToken cancellationToken) [0x0036c] in <4080d9514c944cf4b3ae889fb07b8e3b>:0
  at Dotmim.Sync.SyncPolicy.InternalExecuteAsync[TResult] (System.Func1[TResult] operation, System.Threading.CancellationToken cancellationToken, System.Object arg) [0x00103] in <4c312695a8674d6890ba8c3e768d18bc>:0   at Dotmim.Sync.Web.Client.HttpRequestHandler.ProcessRequestAsync (System.Net.Http.HttpClient client, System.String baseUri, System.Byte[] data, Dotmim.Sync.Web.Client.HttpStep step, System.Guid sessionId, System.String scopeName, Dotmim.Sync.Serialization.ISerializerFactory serializerFactory, Dotmim.Sync.Serialization.IConverter converter, System.Int32 batchSize, Dotmim.Sync.SyncPolicy policy, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x0037f] in <4080d9514c944cf4b3ae889fb07b8e3b>:0
  at Dotmim.Sync.Web.Client.WebClientOrchestrator.ApplyThenGetChangesAsync (Dotmim.Sync.ScopeInfo scope, Dotmim.Sync.Batch.BatchInfo clientBatchInfo, System.Data.Common.DbConnection connection, System.Data.Common.DbTransaction transaction, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x00447] in <4080d9514c944cf4b3ae889fb07b8e3b>:0   at Dotmim.Sync.SyncAgent+<>c__DisplayClass53_0.<SynchronizeAsync>b__0 () [0x00e09] in <4c312695a8674d6890ba8c3e768d18bc>:0   at Dotmim.Sync.SyncAgent.SynchronizeAsync (Dotmim.Sync.Enumerations.SyncType syncType, System.Threading.CancellationToken cancellationToken, System.IProgress1[T] progress) [0x00185] in <4c312695a8674d6890ba8c3e768d18bc>:0
  at AutomobileApp.Services.NFODataService.SyncData () [0x00137] in C:\SandBox\AutomobileApp\AutomobileApp\AutomobileApp\Services\NFODataService.cs:83 }

[Vextamour]

Yes, you need to provision your Azure SQL Server to create the tracking tables. I provided that code in the sample above with some explanation. Put the provision and deprovision in separate end points then you can call that endpoint from your API. It seems like you are very close to getting this to work just missing small pieces.

[sisaacks]

@Vextamour I am using EF to migrate my DB from the API to the Azure Sql DB. The tracking tables are already done by EF. I have no idea how to apply the provisioning.....where to call it.....what do do with the returned schmema. I need an example that makes sense. We will pay @Mimetis for his time. This has gone on way too long and we need to get this rolling. I am continually spinning my wheels with this

I included a snap shot of the Azure DB you can plainly see the tracking tables are there.
I dont know what is going on or why.....but i get the invalid tracking name if I use SqlSyncChangeTrackingProvider and if I use SqlSyncProvider I get invalied MODEL name.

I Dont see anywhere in the code you provided that shows how to use provisioning? Am I missing something?

[Mimetis]

I've made a sample here : https://github.com/Mimetis/VehiclesSyncDemo

Call the server Reset method to create the server database with initial data
Then look at the client commands to see the 2 samples

Once you are comfortable with, we will be able to look further, if needed

[sisaacks]

I see what you have done in the example, thank you for taking the time. That is a console application and my ap is an MOBILE application, SQLite is configured much differently. I deleted everything off of Azure and restarted and miraculously its now working fine. It was the only thing that I reasoned could be the issue, everything was set up as you had instructed I am sure I will have questions about how to Add Tables and Columns and such as how the schema evolves.

…

On Tue, May 10, 2022 at 2:06 PM Sébastien Pertus ***@***.***> wrote: I've made a sample here : https://github.com/Mimetis/VehiclesSyncDemo Once you are comfortable with, we will be able to look further, if needed — Reply to this email directly, view it on GitHub <#730 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOZ5VYAPCDYC5A7MNBS5N7DVJLFWHANCNFSM5UT5BTVA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[sisaacks]

I have a question about the Migration is your example you have two sql sync providers In my sync I have a sqliteSyncprovider and a WebClientOrchestrator Should I be using those for the migration vs the two sqlsyncproviders? Also, when I add a property to my model in the client side, sqlite auto generates that field. So do I still need a provider for the client side? Regards Seth Isaacks On Tue, May 10, 2022 at 2:43 PM Seth Isaacks ***@***.***> wrote:

…

I see what you have done in the example, thank you for taking the time. That is a console application and my ap is an MOBILE application, SQLite is configured much differently. I deleted everything off of Azure and restarted and miraculously its now working fine. It was the only thing that I reasoned could be the issue, everything was set up as you had instructed I am sure I will have questions about how to Add Tables and Columns and such as how the schema evolves. On Tue, May 10, 2022 at 2:06 PM Sébastien Pertus ***@***.***> wrote: > I've made a sample here : https://github.com/Mimetis/VehiclesSyncDemo > > Once you are comfortable with, we will be able to look further, if needed > > — > Reply to this email directly, view it on GitHub > <#730 (reply in thread)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AOZ5VYAPCDYC5A7MNBS5N7DVJLFWHANCNFSM5UT5BTVA> > . > You are receiving this because you were mentioned.Message ID: > ***@***.***> >

[sisaacks]

I dont understand how to let dotmim create my schema....I have to create my schema for the Sqlite to work. I automatically create the database on loan the app would fail without that database

…

On Tue, May 10, 2022 at 8:24 AM Vext ***@***.***> wrote: This error message might mean that your SQLite database is missing a column in your main database. Delete your SQLite database and let DotMim recreate your local SQLite to see if this error message resolves. {Dotmim.Sync.SyncException: SQLite Error 1: 'no such column: base.Model'. ---> Microsoft.Data.Sqlite.SqliteException: SQLite Error 1: 'no such column: base.Model'. — Reply to this email directly, view it on GitHub <#730 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOZ5VYA4FZRQXQZJZ4TANOLVJJ5SHANCNFSM5UT5BTVA> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[Mimetis]

if the SQLite database is not existing, DMS will create it and the tables.
Pretty simple :)