C# (CSharp) IDataInteraction.AddOutputParameter Examples

Example #1

            public bool SetupCommand(IDataInteraction command)
            {
                command.ExecuteText(GetSql());
                command.AddOutputParameter("@param", DbType.StringFixedLength, 4);

                return(true);
            }

Example #2

 public bool SetupCommand(IDataInteraction command)
 {
     command.ExecuteText(@"
         SELECT @value = 'param';
         SELECT 'result';");
     command.AddOutputParameter("@value", DbType.AnsiString, 5);
     return(true);
 }

Example #3

File: SetupCommandTests.cs Project: Whiteknight/CastIron

 public bool SetupCommand(IDataInteraction command)
 {
     command.ExecuteText("SELECT @param = 'TEST';");
     command.AddOutputParameter("@param", DbType.StringFixedLength, 4);
     return(false);
 }

Example #4

File: CommandOutputParametersTests.cs Project: Whiteknight/CastIron

 public bool SetupCommand(IDataInteraction command)
 {
     command.ExecuteText("SELECT @param = 'TEST';");
     command.AddOutputParameter("@param", DbType.AnsiString, 4);
     return(true);
 }

Example #5

 public bool SetupCommand(IDataInteraction interaction)
 {
     interaction.ExecuteText("SELECT @value = 5;");
     interaction.AddOutputParameter("@value", DbType.Int32, 0);
     return(true);
 }

Example #6

 public bool SetupCommand(IDataInteraction interaction)
 {
     interaction.ExecuteText("SELECT @value = 'TEST';");
     interaction.AddOutputParameter("@value", DbType.AnsiString, 8000);
     return(true);
 }