DbType

[Peter Kirk]

Hi

I have a database with an "nchar" column. How do I specify this type of
column in C# when I use stored procedures?

For example:

IDbCommand command = ... // get the command

IDataParameter param = command.CreateParameter();

param.ParameterName = "@pcid";
param.Value = 'n';
param.Direction = ParameterDirection.Input;

param.DbType = ??

command.Parameters.Add(param);

There appears to be no DbType whihc corresponds to a char.

Thanks,
Peter

 

[Luke Smith]

You can use DbType.String or DbType.StringFixedLength.

Luke

 

[carion1]

You can use System.Data.SqlDbType.Char