Equivalent of OracleParameter [C#/.NET/SQL Server]

Question

I working on a database migration (from Oracle to SQL Server) and in this context, I need to change the DAL layer of an ASP.NET project. Part of this is finding the SQL Server equivalent of the class OracleParameter (From Oracle.DataAccess.dll).

So I would like to know which class I have to use, is it DbParameter or another one?

What does OracleParameter inherit from or implement? DbParameter? Then wouldn't it make sense there's an equivalent class in the SQL Server libraries that also inherits from that, and probably has "parameter" in the name? And where does one look for information about the libraries that come with .NET? The documentation! — mason
– mason, Commented Apr 25, 2017 at 13:13

r.net · Accepted Answer · 2017-04-25 13:55:48Z

1

Best to use:

SqlParameter

Eg:

var parameter = new SqlParameter();
            parameter.ParameterName = "@paramName";
            parameter.Direction = ParameterDirection.Input;
            parameter.SqlDbType = SqlDbType.Int;
            //parameter.IsNullable = true;
            parameter.Value = DaysInStock;

answered Apr 25, 2017 at 13:55

r.net

6317 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Equivalent of OracleParameter [C#/.NET/SQL Server]

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related