.NET ขอคำแนะนำหรือตัวอย่างการ Loop for insert data เข้าฐานข้อมูลด้วยครับ

DbContent db = new DbContent("...connection string...");

for (int i=0; i < 1000; i++)
{
MyTable data = new MyTable();
data.xxx = i;

db.MyTable.InsertOnSubmit(data);
}

db.SubmitChange;

DataTable Dt = new DataTable();
Dt.Columns.Add(new DataColumn("xxx", typeof(int)));

for (int i=0; i < 1000; i++)
{
DataRow DrNew = Dt.NewRow();
DrNew["xxx"] = i;
Dt.Rows.Add(DrNew);
}

SqlConnection sqlConnection = new SqlConnection("...connection string...");
SqlCommand sqlCommand = new SqlCommand("Insert Into [MyTable] ([xxx]) Values (@xxx)", sqlConnection);
sqlCommand.Parameters.Add("@xxx", SqlDbType.Int, 4, "xxx");

SqlDataAdapter sqlAdapter = new SqlDataAdapter();
sqlAdapter.InsertCommand = sqlCommand;
sqlAdapter.Update(DataSource);

sqlAdapter.Update(DataSource);

sqlAdapter.Update(Dt);