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