SqlParameter to SQL declare representation

[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.

 

[Marcel Müller]

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.. ?

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

 

[Arne Vajhøj]

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.. ?

I would expect:

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

to provide what you need.

Arne

 

[antonitomt]

Thanks

 

[antonitomt]

Thanks