public static void Run() { DemoTable demo = new DemoTable { Name = "My demo table", ListVector = new List <InnerTable> { new InnerTable { Fruit = "Apple" }, new InnerTable { Fruit = "Banana" }, new InnerTable { Fruit = "Pear" } } }; // In order of greediness LazyDeserialization(demo); ProgressiveDeserialization(demo); GreedyDeserialization(demo); GreedyMutableDeserialization(demo); }
public ActionResult DeleteConfirmed(int id) { DemoTable demoTable = db.DemoTable.Find(id); db.DemoTable.Remove(demoTable); db.SaveChanges(); return(RedirectToAction("Index")); }
public JsonResult Delete(int ID) { DemoTable dt = DC.DemoTables.Single(m => m.Id == ID); DC.DemoTables.Remove(dt); DC.SaveChanges(); return(Json("Deleted", JsonRequestBehavior.AllowGet)); }
public ActionResult Edit([Bind(Include = "StepID,StepName,Description,IsActive,LastUpdated,LastUpdatedBy")] DemoTable demoTable) { if (ModelState.IsValid) { db.Entry(demoTable).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(demoTable)); }
public ActionResult Edit([Bind(Include = "Id,Name,City,Age")] DemoTable demoTable) { if (ModelState.IsValid) { db.Entry(demoTable).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(demoTable)); }
/// <summary> /// In lazy deserialization, FlatSharp reads from the underlying buffer each time. No caching is done. This will be /// the fastest option if your access patterns are sparse and you touch each element only once. /// </summary> public static void LazyDeserialization(DemoTable demo) { var serializer = new FlatBufferSerializer(new FlatBufferSerializerOptions(FlatBufferDeserializationOption.Lazy)); byte[] buffer = new byte[1024]; serializer.Serialize(demo, buffer); var parsed = serializer.Parse <DemoTable>(buffer); // Lazy deserialization reads objects from vectors each time you ask for them. InnerTable index0_1 = parsed.ListVector ![0];
public ActionResult Create([Bind(Include = "Id,Name,City,Age")] DemoTable demoTable) { if (ModelState.IsValid) { db.DemoTables.Add(demoTable); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(demoTable)); }
public ActionResult Create([Bind(Include = "StepID,StepName,Description,IsActive,LastUpdated,LastUpdatedBy")] DemoTable demoTable) { if (ModelState.IsValid) { db.DemoTable.Add(demoTable); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(demoTable)); }
/// <summary> /// 刪除 /// </summary> public void Delete(DemoTable Data) { try { this.DemoTableDao.Delete(Data); } catch (Exception ex) { throw ex; } }
protected void LinkButton1_Click(object sender, EventArgs e) { DemoTable dt = new DemoTable(); dt.DemoTitle = TextBox1.Text; dt.DemoSource = TextBox2.Text; dl.da.DemoTables.InsertOnSubmit(dt); dl.da.SubmitChanges(); TextBox1.Text = TextBox2.Text = ""; Response.Write("<script>alert('Success')</script>"); }
/// <summary> /// 閱讀 /// </summary> public DemoTable Read(DemoTable Data) { try { return(this.DemoTableDao.Read(Data)); } catch (Exception ex) { throw ex; } }
public ActionResult Detail(DemoTable fdata) { if (fdata.id > 0) { _demo.Update(fdata); } else { _demo.Add(fdata); } return(RedirectToAction("Index", "Demo")); }
// GET: DemoTables/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DemoTable demoTable = db.DemoTable.Find(id); if (demoTable == null) { return(HttpNotFound()); } return(View(demoTable)); }
/// <summary> /// 閱讀 /// </summary> public DemoTable Read(DemoTable Data) { var sql = @"SELECT * FROM DemoTable(NOLOCK) WHERE Id=@Id"; using (var connection = new SqlConnection(ConfigTool.GetDbConnectionStrings())) { try { var result = connection.Query <DemoTable>(sql, Data).ToList(); return(result.Count > 0 ? result.First() : null); } catch (Exception ex) { throw ex; } } }
/// <summary> /// 建立 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonResult Create(DemoTable model) { var result = new ResultModel() { ExecuteResult = "執行成功", QueryResult = "" }; try { this.DemoService.Create(model); } catch (Exception ex) { result.ExecuteResult = string.Format("執行失敗(錯誤原因:{0})", ex.Message); } return(Json(result)); }
/// <summary> /// 查詢 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonResult Read(DemoTable model) { var result = new ResultModel() { ExecuteResult = "執行成功", QueryResult = "" }; try { var queryResult = this.DemoService.Read(model); result.QueryResult = queryResult != null ? new JavaScriptSerializer().Serialize(queryResult) : "查無資料"; } catch (Exception ex) { result.ExecuteResult = string.Format("執行失敗(錯誤原因:{0})", ex.Message); } return(Json(result)); }
/// <summary> /// 刪除 /// </summary> public void Delete(DemoTable Data) { var sql = @"DELETE FROM DemoTable WHERE Id=@Id"; using (var connection = new SqlConnection(ConfigTool.GetDbConnectionStrings())) { connection.Open(); var transaction = connection.BeginTransaction(); try { connection.Execute(sql, Data, transaction); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } }
/// <summary> /// 新增 /// </summary> public void Create(DemoTable Data) { var sql = @"INSERT INTO DemoTable Values(@Id,@Name,@Gender)"; using (var connection = new SqlConnection(ConfigTool.GetDbConnectionStrings())) { connection.Open(); var transaction = connection.BeginTransaction(); try { connection.Execute(sql, Data, transaction); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } }
public void Refresh() { if (csv == null) { return; } DemoTable table = new DemoTable(); table.Load(csv.text); // names AddItem("Year", Color.gray); AddItem("Make", Color.gray); AddItem("Model", Color.gray); AddItem("Desc", Color.gray); AddItem("Price", Color.gray); // types DemoTable.Row row = table.GetAt(0); AddItem(row.Year.GetType().ToString(), Color.gray); AddItem(row.Make.GetType().ToString(), Color.gray); AddItem(row.Model.GetType().ToString(), Color.gray); AddItem(row.Description.GetType().ToString(), Color.gray); AddItem(row.Price.GetType().ToString(), Color.gray); // datas int numRows = table.NumRows(); for (int i = 0; i < numRows; i++) { AddItem(table.GetAt(i).Year.ToString()); AddItem(table.GetAt(i).Make); AddItem(table.GetAt(i).Model); AddItem(table.GetAt(i).Description); AddItem(table.GetAt(i).Price.ToString()); } }
/// <summary> /// 更新 /// </summary> public void Update(DemoTable Data) { var sql = @" UPDATE DemoTable SET Id=@Id,Name=@Name,Gender=@Gender WHERE Id=@Id"; using (var connection = new SqlConnection(ConfigTool.GetDbConnectionStrings())) { connection.Open(); var transaction = connection.BeginTransaction(); try { connection.Execute(sql, Data, transaction); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } }
public ActionResult Index(DemoTable dt) { DC.DemoTables.Add(dt); DC.SaveChanges(); return(Json("Ok", JsonRequestBehavior.AllowGet)); }
partial void DeleteDemoTable(DemoTable instance);
partial void UpdateDemoTable(DemoTable instance);
partial void InsertDemoTable(DemoTable instance);
public JsonResult Update(DemoTable emp) { DC.Entry(emp).State = System.Data.Entity.EntityState.Modified; DC.SaveChanges(); return(Json("Ok", JsonRequestBehavior.AllowGet)); }