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)
AS

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;
comm.Parameters.Add(param);

Not too difficult, but not too intuitive either.

Advertisements
  1. Leave a comment

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: