将大型插入作为表值参数或作为字符串插入语句传递给SQL Server是否更好？

I am writing a .NET application that writes data to SQL Server 2008r2. I have two options for inserting the data, either I can create a large string insert statement, and send it as a text command, or I can collect the data in a .NET DataTable, and pass it as a table valued parameter. What are the benefits and costs of each method?I am writing a .NET application that writes dat