public void insert_maxim() { var dao = new MaximSpaDAO(); for (int i = 0; i < 10; i++) { var newMaxim = new MaximEntity(); newMaxim.Name = "hello"; newMaxim.Content = "world"; var insertOperation = TableOperation.InsertOrReplace(newMaxim); dao.MaximTable.Execute(insertOperation); } var query = new TableQuery <MaximEntity>(); var maximList = dao.MaximTable.ExecuteQuery(query).ToList(); //var query = new TableQuery<AzureTableLogEntity>(); //var maxRowKey = table.ExecuteQuery(query).Max(item => long.Parse(item.RowKey)); //var log = new AzureTableLogEntity(); //log.PartitionKey = tmpLog.Level; //log.LogLevel = tmpLog.Level; //log.Log = tmpLog.Log; //var insertOperation = TableOperation.InsertOrReplace(log); //table.Execute(insertOperation); }
public List <MaximEntity> Get() { var dao = new MaximSpaDAO(); var query = new TableQuery <MaximEntity>(); var result = dao.MaximTable.ExecuteQuery(query).ToList(); return(result); }
public async Task Delete() { var dao = new MaximSpaDAO(); var batchOp = new TableBatchOperation(); var query = new TableQuery <MaximEntity>(); foreach (var item in dao.MaximTable.ExecuteQuery(query)) { var delOp = TableOperation.Delete(item); batchOp.Add(delOp); } var res = dao.MaximTable.ExecuteBatch(batchOp); }
public MaximEntity Get(string id) { var dao = new MaximSpaDAO(); var op = TableOperation.Retrieve <MaximEntity>("PartitionKey", id); var opResult = dao.MaximTable.Execute(op); var result = (MaximEntity)opResult.Result; if (result == null) { var msg = new HttpResponseMessage(); msg.StatusCode = HttpStatusCode.NotFound; msg.Content = new StringContent("id not found in maxim db"); throw new HttpResponseException(msg); } return(result); }
public MaximEntity Post([FromBody] MaximEntity inMaxim) { if (inMaxim == null) { var msg = new HttpResponseMessage(); msg.StatusCode = HttpStatusCode.BadRequest; msg.Content = new StringContent("inMaxim is null, bad request, bad json"); throw new HttpResponseException(msg); } var dao = new MaximSpaDAO(); var newMaxim = new MaximEntity(); newMaxim.Name = inMaxim.Name; newMaxim.Content = inMaxim.Content; var op = TableOperation.InsertOrReplace(newMaxim); dao.MaximTable.Execute(op); return(newMaxim); }
public void cleanup_maxim() { var dao = new MaximSpaDAO(); dao.MaximTable.DeleteIfExists(); }