var sql = @"Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-MvcApplication1-20131029153010;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-MvcApplication1-20131029153010.mdf";            SqlBulkCopy bc = new System.Data.SqlClient.SqlBulkCopy(sql);            bc.DestinationTableName = "TestInfo";            DataTable t = new DataTable();            t.Columns.Add("id");            t.Columns.Add("MyProperty");            DataRow r = t.NewRow();            r[0] = 1;            r[1] = "2";            t.Rows.Add(r);            bc.WriteToServer(t);            bc.Close();