Using a VARCHAR(MAX) parameter in .NET

So you have a stored procedure with a parameter as a VARCHAR(MAX):

CREATE PROCEDURE [dbo].[GetAwesomeDude]
@CustomerName VARCHAR(MAX)

SELECT * FROM CoolAwesomeTable
WHERE ID = @CustomerName

How do you designate this in C#? You use “-1” as the parameter size:

SqlParameter param = new SqlParameter(“@CustomerName”, SqlDbType.VarChar, -1);
param.Value = poly.Points;

Not too difficult, but not too intuitive either.

  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: