The table-valued approach is always my preferred option, but often that&#x27;s a where bad APIs become a nuisance.<p>I mean, look at all this boilerplate:<p><a href="http:&#x2F;&#x2F;stackoverflow.com&#x2F;questions&#x2F;10409576&#x2F;pass-table-valued-parameter-using-ado-net" rel="nofollow">http:&#x2F;&#x2F;stackoverflow.com&#x2F;questions&#x2F;10409576&#x2F;pass-table-value...</a>