protected void Query_Test() { DatabaseDotComContext context = (DatabaseDotComContext)Session["context"]; DatabaseDotComClient client = new DatabaseDotComClient(context); // BEGIN Query Example DatabaseDotCom.DatabaseDotComClient.QueryResult qr = client.Query("Select Id, Name, FirstName, LastName, Phone, Account.Id, Account.Name From Contact"); System.Diagnostics.Debug.WriteLine("Records: " + qr.size); foreach (DatabaseDotComClient.DBCObject obj in qr.records) { System.Diagnostics.Debug.WriteLine("Id: " + obj.GetStringField("Id")); System.Diagnostics.Debug.WriteLine("Name: " + obj.GetStringField("Name")); if (obj.getFields().ContainsKey("Contacts")) { try { DatabaseDotComClient.QueryResult cons = (DatabaseDotComClient.QueryResult)obj.getFields()["Contacts"]; foreach (DatabaseDotComClient.DBCObject con in cons.records) { System.Diagnostics.Debug.WriteLine("Contact name: " + con.GetStringField("Name")); } } catch (Exception ex) { } } else if (obj.getFields().ContainsKey("Account")) { try { DatabaseDotComClient.DBCObject account = (DatabaseDotComClient.DBCObject)obj.getFields()["Account"]; System.Diagnostics.Debug.WriteLine("Account name: " + account.GetStringField("Name")); System.Diagnostics.Debug.WriteLine("Account industry: " + account.GetStringField("Industry")); System.Diagnostics.Debug.WriteLine("Account id: " + account.GetStringField("Id")); } catch (Exception ex) { } } GridView1.DataSource = qr.GetDataSet(); GridView1.DataBind(); // END Query Example } }
protected void DeleteByQueryResult_Click(object sender, EventArgs e) { outputbox.Text += "Starting delete using query result sample..." + Environment.NewLine; DatabaseDotComContext context = (DatabaseDotComContext)Session["context"]; DatabaseDotComClient client = new DatabaseDotComClient(context); DatabaseDotComClient.QueryResult contactQuery = client.Query("Select Id From Contact Where FirstName = 'Joe'"); DatabaseDotCom.DBDCReference.DeleteResult[] results = client.DeleteByQueryResult(contactQuery); outputbox.Text += "Delete success result is: " + results[0].success + Environment.NewLine + Environment.NewLine; Query_Test(); }
/* protected void Update_Click(object sender, EventArgs e) { // BEGIN Update Example DatabaseDotComContext context = (DatabaseDotComContext)Session["context"]; DatabaseDotComClient client = new DatabaseDotComClient(context); outputbox.Text += "Starting update sample..." + Environment.NewLine; DatabaseDotComClient.QueryResult accountQuery = client.Query("Select Id From Account Where Name = 'Azure Test Account'"); DatabaseDotComClient.DBCObject newAccount = accountQuery.records[0]; newAccount.SetStringField("Industry", "Agriculture"); DatabaseDotCom.DBDCReference.SaveResult sr; newAccount = client.Update(newAccount, out sr); outputbox.Text += "Update success result is: " + sr.success + Environment.NewLine + Environment.NewLine; //END Update Example } */ protected void DeleteByIds_Click(object sender, EventArgs e) { // BEGIN Delete Example DatabaseDotComContext context = (DatabaseDotComContext)Session["context"]; DatabaseDotComClient client = new DatabaseDotComClient(context); outputbox.Text += "Starting delete using ids sample..." + Environment.NewLine; DatabaseDotComClient.QueryResult contactQuery = client.Query("Select Id From Contact Where FirstName = 'Joe'"); string[] ids = new string[contactQuery.records.Length]; for (int i = 0; i < ids.Length; i++) { ids[i] = contactQuery.records[i].Id; } DatabaseDotCom.DBDCReference.DeleteResult[] results = client.DeleteByIds(ids); outputbox.Text += "Delete success result is: " + results[0].success + Environment.NewLine + Environment.NewLine; Query_Test(); }