var manager = new DatastoreManager("oauth_token");

// Getting or creating a datastore
var datastore = await manager.GetOrCreateAsync("test");

// Getting an existing datastore
var existing_datastore = await manager.GetAsync("default");

// Listing available datastores
var datastore_list = await manager.ListAsync();
foreach (var ds in datastore_list) {
  // ...
}

// Deleting a datastore
await manager.DeleteAsync(datastore);

// Wait for up to a minute or for remote changes to occur, whichever comes first
List<Datastore> changed = new List<Datastore>();
if (await manager.AwaitDatastoreChangesAsync(changed)) {
  // Any datastores that have remote changes applied are now in the changed list
}

// Wait for up to a minute or for a change to the list of datastores, whichever comes first
if (await manager.AwaitListChangesAsync()) {
  // calling manager.ListAsync will retrieve the changed list of datastores
}

class Appointment {
  public string Id;
  public DateTime Time;
  public List<String> People = new List<string>();
}

...

// pull in any remote changes and make sure we are up to date before
// trying to apply our own local changes
await datastore.PullAsync();

// get a reference to the appointments table
var table = datastore.GetTable<Appointment>("appointments");

var new_appointment = new Appointment{ Id = "1", Time = DateTime.Now() };
new_appointment.People.Add("Jules");

// insert the object into the table. An Id can also be specified for this method
// though because this object has a public string field called Id, this is worked
// out automatically (If you want you can inherit your objects from BobbyTables.Record
// which will provide this Id field). 
// Note: If the Id field is null or empty on insertion, it will be populated with an 
// auto generated id.
// Also note: this method is not awaited as it is only recording
// the change as pending locally. No changes have been pushed to Dropbox yet.
table.Insert(new_appointment);

// now lets commit the pending insert and push it out to Dropbox
if (await datastore.PushAsync()) {
  // Yay! the changes were accepted
} else {
  // Oh no! a conflict occurred due to another user submitting a change concurrently.
  // In this case we should revert our local changes, Pull in the latest changes and
  // try again. NOTE: The Transaction feature can help make handling conflicts easier.
  datastore.Revert();
}

  // every operation inside the transaction will try to be pushed to Dropbox in a single
  // commit. If anything fails, all changes are reverted, the latest changes are pulled
  // from Dropbox, and the changes will be re-applied until the commit succeeds, or the 
  // max number of retries is exceeded
  var success = await datastore.Transaction(()=> {
    var table = datastore.GetTable<Appointment>("appointments");
    
    var new_appointment = new Appointment{ Id = "1", Time = DateTime.Now() };
    new_appointment.People.Add("Jules");
    
    table.Insert(new_appointment);
  }).PushAsync(); // can specify the number of retries as a parameter (default 1)
  

var table = datastore.GetTable<Appointment>("appointments");

// can search for objects using LINQ queries
var appointment = (from appt in table where t.Id == "1" select appt).SingleOrDefault();

// or you can search using the Id directly
appointment = table.Get("1");

appointment.People.Add("Vincent");
appointment.People.Add("Marcellus");

// now lets commit the pending update and push it out to Dropbox
await datastore.Transaction(()=> {
  table.Update(appointment);
}).PushAsync();

// the local state of a datastore can be saved to a streamWriter. In this case we
// are choosing to save the local snapshot to a file on disk
using (var stream = new FileStream("C:\\db.json",FileMode.Create,FileAccess.Write)) {
  using (StreamWriter writer = new StreamWriter(stream))
  {
  	datastore.Save(writer);
  }
}

...

// We can then reload the old state by loading this file
using (var stream = new FileStream("C:\\db.json",FileMode.Open,FileAccess.Read)) {
  using (StreamReader reader = new StreamReader(stream))
  {
  	datastore = manager.Load(reader);
  }
}

while (true) {
  // Waits for up to a minute or for a change to occur, whichever happens first
  if (await datastore.AwaitPullAsync()) {
    // some remote changes occurred within the last minute and have been pulled in
    // to the local snapshot
  } else {
    // no changes occurred
  }
}

var table = datastore.GetTable<Appointment>("appointments");

var new_appointment = new Appointment{ Time = DateTime.Now() };
table.Insert("1",new_appointment);

var table = datastore.GetTable<Appointment>("appointments");

var new_appointment = new Appointment{ Time = DateTime.Now() };
table.Insert( obj => obj.Time.ToString(), new_appointment);

var table = datastore.GetTable<Appointment>("appointments");
var appointment = table.Get( (obj,value) => obj.SetId(value), "1");