public IActionResult BulkInsert(int num) { using (var db = new AppDb()) { var time = DateTime.Now; db.Connection.Open(); var txn = db.Connection.BeginTransaction(); try { for (var i = 0; i < num; i++) { var blogPost = new BlogPost { Db = db, Title = "bulk", Content = "bulk " + num }; blogPost.Insert(); } } catch (Exception) { txn.Rollback(); throw; } txn.Commit(); var timing = $"Sync: Inserted {num} records in " + (DateTime.Now - time); Console.WriteLine(timing); return(new OkObjectResult(timing)); } }
public IActionResult Post([FromBody] BlogPost body) { using (var db = new AppDb()) { db.Open(); BlogPost.Insert(db, body); return(new OkObjectResult(body)); } }
public IActionResult Post([FromBody] BlogPost body) { using (var db = new AppDb()) { db.Connection.Open(); body.Db = db; body.Insert(); return(new OkObjectResult(body)); } }
protected void ButtonAdd_OnClick(object sender, EventArgs e) { BlogPost bp = new BlogPost(); DataBindingManagerBlogPost.DataSource = bp; DataBindingManagerBlogPost.PullData(); bp.ParentID = CurrentBlog.FileID; bp.SortOrder = CurrentBlog.Files.Count; bp.Insert(); Response.Redirect(bp.FileType.EditUrl + "?FileID=" + bp.ID); }