title: using MobileService.GetSyncTable PullAsync Trouble
body: <p>I am trying to get using the Azure Backend with Sync to work for my app.
  It looks like PullAsync is not populating my local table though.</p>
  
  <p>My Table is set up like this:</p>
  
  <pre><code>private IMobileServiceSyncTable&lt;Familie&gt; FamilienTable = App.MobileService.GetSyncTable&lt;Familie&gt;(); // offline sync
  </code></pre>
  
  <p>Some code first. Initializing the table like this:</p>
  
  <pre><code>if (!App.MobileService.SyncContext.IsInitialized)
          {
              var store = new MobileServiceSQLiteStore("localGarden.db");
              store.DefineTable&lt;Familie&gt;();
              await App.MobileService.SyncContext.InitializeAsync(store);
          }
  </code></pre>
  
  <p>I can see that the table is created and it is on my local system later (already tried setting up a new table, too). </p>
  
  <p>And a little later in my code this is called:</p>
  
  <pre><code> try
          {
              await FamilienTable.PullAsync(null, FamilienTable.CreateQuery());                                
          }
   catch (Exception ex)
          {
              errorString = "Pull failed: " + ex.Message +
                "\n\nIf you are still in an offline scenario, " +
                "you can try your Pull again when connected with your Mobile Serice.";
          }
  
          if (errorString != null)
          {
              MessageDialog d = new MessageDialog(errorString);
              await d.ShowAsync();
          }
  </code></pre>
  
  <p>I set this up originally based on <a href="https://azure.microsoft.com/en-us/documentation/articles/mobile-services-xamarin-ios-get-started-offline-data/" rel="nofollow">https://azure.microsoft.com/en-us/documentation/articles/mobile-services-xamarin-ios-get-started-offline-data/</a> and adapted to using a Win10 App. This is using Microsoft.Azure.Mobile.Client.SQLitestore 2.0.1 mainly.</p>
  
  <p>I know that I need to replace the null in the PullAsync with a string for incremental updates in the future.</p>
  
  <p>Using fiddler I discovered that there are 2 calls to my node.js powered API on Azure during the pullAsync: 
  [removed].azurewebsites.net/tables/Familie?$skip=0&amp;$top=50&amp;__includeDeleted=true (which returns a JSON with 6 rows I have in my table) and immidiatly after that [removed].azurewebsites.net/tables/Familie?$skip=6&amp;$top=50&amp;__includeDeleted=true which returns an empty JSON.</p>
  
  <p>My local table stays empty though.</p>
  
  <p>Can someone tell me, if that behavior is by design, explain why I get 2 calls and give me an idea where to look for the reason  why my local table is not populated?</p>
  
  <p>Thank you very much!</p>
  
  <hr>
  
  <h1>Additional Info: Output of LoggingHandler:</h1>
  
  <pre><code>CREATE TABLE IF NOT EXISTS [Familie] ([id] INTEGER PRIMARY KEY, [Name] TEXT, [Deleted] BOOLEAN, [Version] DATETIME, [createdAt] DATETIME, [updatedAt] DATETIME)
  CREATE TABLE IF NOT EXISTS [__operations] ([id] TEXT PRIMARY KEY, [kind] INTEGER, [state] INTEGER, [tableName] TEXT, [tableKind] INTEGER, [itemId] TEXT, [item] TEXT, [createdAt] DATETIME, [sequence] INTEGER, [version] INTEGER)
  CREATE TABLE IF NOT EXISTS [__errors] ([id] TEXT PRIMARY KEY, [httpStatus] INTEGER, [operationVersion] INTEGER, [operationKind] INTEGER, [tableName] TEXT, [tableKind] INTEGER, [item] TEXT, [rawResult] TEXT)
  CREATE TABLE IF NOT EXISTS [__config] ([id] TEXT PRIMARY KEY, [value] TEXT)
  BEGIN TRANSACTION
  INSERT OR IGNORE INTO [__config] ([id]) VALUES (@p0)
  The thread 0x2fcc has exited with code 0 (0x0).
  UPDATE [__config] SET [value] = @p0 WHERE [id] = @p1
  COMMIT TRANSACTION
  SELECT * FROM [__operations] ORDER BY [sequence] DESC LIMIT 1
  SELECT COUNT(1) AS [count] FROM [__operations]
  Pulling changes from remote server
  'Gemüsebeetplaner.exe' (CoreCLR: CoreCLR_UWP_Domain): Loaded 'C:\Users\Jens\documents\visual studio 14\Projects\Gemüsebeetplaner\Gemüsebeetplaner\bin\x86\Debug\AppX\System.Linq.Queryable.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
  SELECT * FROM [__operations] WHERE ([tableName] = @p1) LIMIT 0
  SELECT COUNT(1) AS [count] FROM [__operations] WHERE ([tableName] = @p1)
  Pulling changes from remote server
  SELECT * FROM [__operations] WHERE ([tableName] = @p1) LIMIT 0
  SELECT COUNT(1) AS [count] FROM [__operations] WHERE ([tableName] = @p1)
  SELECT * FROM [Familie] ORDER BY [Name]
  </code></pre>
  
  <hr>
  
  <h2>Additonal Info 2:</h2>
  
  <p>**Screenshots of the tables **
  <a href="http://i.stack.imgur.com/cQ9fK.jpg" rel="nofollow">Screenshot</a></p>
  
  <p><strong>This is the log with parameters enabled:</strong>
  Pulling changes from remote server</p>
  
  <pre><code>SELECT * FROM [__operations] WHERE ([tableName] = @p1) LIMIT 0
  @p1:Familie
  SELECT COUNT(1) AS [count] FROM [__operations] WHERE ([tableName] = @p1)
  @p1:Familie
  {
    "count": 0
  }
  Pulling changes from remote server
  SELECT * FROM [__operations] WHERE ([tableName] = @p1) LIMIT 0
  @p1:Familie
  SELECT COUNT(1) AS [count] FROM [__operations] WHERE ([tableName] = @p1)
  @p1:Familie
  {
    "count": 0
  }
  SELECT * FROM [Familie] ORDER BY [Name]
  The thread 0x24c8 has exited with code 0 (0x0).
  The thread 0x1474 has exited with code 0 (0x0).
  The thread 0x1a40 has exited with code 0 (0x0).
  </code></pre>
  
  <hr>
  
  <h2>Class</h2>
  
  <pre><code>public class Familie
  {
      [JsonProperty(PropertyName = "Id")]
      public int Id { get; set; }
  
      [JsonProperty(PropertyName = "Name")]
      public string Name { get; set; }
  
  }
  </code></pre>