Number of Parameters in DbCommand and performance

Topics: Data Access Application Block
Feb 15, 2008 at 9:29 PM
Edited Feb 15, 2008 at 9:29 PM
I have a project at the moment that is using some tables that have a lot of columns.

I am generating creating my update statements as strings in then sending them to the DB via a DbCommand.

- How many parameters can be support both at the end and at the Sql server end?
- And how does the increasing number of parameters affect performance on the webserver and at the database?
- Also how much data is sent to the Sql server from the webserver for a parameter based query compared to a simple Sql string?

I am using VB.Net 2.0 and Sql Server 2005. Though we may soon update to VB.Net 3.5 so if there are differences then that would be good to know (I presume not, but hey thought I'd better ask)

Any help would be greatly appreciated...