Skip to content

Instantly share code, notes, and snippets.

@musukvl
Created November 2, 2017 14:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save musukvl/2fbf2432d4259d097fca54302dee994f to your computer and use it in GitHub Desktop.
Save musukvl/2fbf2432d4259d097fca54302dee994f to your computer and use it in GitHub Desktop.
Insert 100 000 rows to ms sql server by Entity Framework SaveChanges
for (var i = 0; i < 100000; i++)
{
using (var dbContext = new MainDbContext())
{
dbContext.Logs.Add(new Log()
{
Key = Guid.NewGuid().ToString("D"),
Data = "some random data:" + Guid.NewGuid().ToString("D"),
UpdatedDate = DateTime.UtcNow
});
dbContext.SaveChanges();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment