static void Main(string[] args) { var data = GetItems(); var connectionString = "data source=localhost;initial catalog=test;Connect Timeout=60;Integrated Security=true"; using (var sqlConnection = new SqlConnection(connectionString)) { sqlConnection.Open(); using (var bcp = new SqlBulkCopy(sqlConnection)) using (var reader = ObjectReader.Create(data)) { bcp.DestinationTableName = "misc"; bcp.AddMappings(data); bcp.WriteToServer(reader); } } Console.WriteLine("Hello World!"); }