using(var connection = new SqlConnection("Connection_String")) { var people = new List{ new Person { FirstName = "John", LastName = "Doe" }, new Person { FirstName = "Jane", LastName = "Doe" }, new Person { FirstName = "Bob", LastName = "Smith" }, }; connection.BulkInsert(people); }
using (var context = new BloggingContext()) { var posts = new ListThis example uses Entity Framework Core to perform a BulkInsert. The connection string and database details are defined in the BloggingContext class. The example then creates a list of Post objects and uses the BulkInsert method to insert them into the database. The package library for these examples is likely to be either Dapper or Entity Framework Core.{ new Post { Title = "Post 1", Content = "Content 1" }, new Post { Title = "Post 2", Content = "Content 2" }, new Post { Title = "Post 3", Content = "Content 3" }, }; context.BulkInsert(posts); }