SqlParameter to SQL declare representation

  • Thread starter Thread starter antonitomt
  • Start date Start date
A

antonitomt

Hello guys,
I'm working on some dynamic sql.

Is there a way, method or function to convert in VS a Sqlparameter variableinto a string with the equivalent declare t-sql (i.e: "@parámetro Numeric(15,2))",
"@parámetro Tinyint", "parámetro Date" and so on.. ?

Thanks

Sorry my englisth is bad.
 
Hello guys,
I'm working on some dynamic sql.

Is there a way, method or function to convert in VS a Sqlparameter variable into a string with the equivalent declare t-sql (i.e: "@parámetro Numeric(15,2))",
"@parámetro Tinyint", "parámetro Date" and so on.. ?
Click to expand...

I do not know a built in way to do so. But it should be straight forward
to write a function the converts the type in an SqlParameter instance to
an T-SQL type.

Something like

public static string ToSQLTypeString(this SqlParameter param)
{
switch (param.DbType)
{case DbType.Int32:
return "INT";
case DbType.Decimal:
return string.Format("DECIMAL({0},{1})", param.Size, param.Scale);
...
}
}

Now you can write

string.Format("DECLARE {0} {1};", "@variable_name",
ToSQLTypeString(sqlparam));


Marcel
 
I'm working on some dynamic sql.

Is there a way, method or function to convert in VS a Sqlparameter variable into a string with the equivalent declare t-sql (i.e: "@parámetro Numeric(15,2))",
"@parámetro Tinyint", "parámetro Date" and so on.. ?
Click to expand...

I would expect:

p.ParameterName
p.SqlDbType
p.Size
p.Precision

to provide what you need.

Arne
 
Back
Top