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);
}
