Solved it.

Instead of the stored procedure I created a function:

CREATE FUNCTION dbo.dnn_f_CountOutdatedRecords
(
   @ModuleID int,
   @StartDate datetime
)
RETURNS int
AS
BEGIN
   DECLARE @OutdatedRecordsCount int

   SELECT
      @OutdatedRecordsCount = COUNT(*)
   FROM
      dbo.dnn_Records
   WHERE
      ModuleID = @ModuleID
      AND StartDate <= @StartDate

   RETURN @OutdatedRecordsCount
END
GO

In the controller I use the follwing code:

public static int OutdatedRecordsCount(int moduleID, DateTime startDate)
{
   int outdatedRecordsCount = 0;
   using (IDataContext ctx = DataContext.Instance())
   {
      outdatedRecordsCount = ctx.ExecuteScalar(System.Data.CommandType.Text, "SELECT {databaseOwner}{objectQualifier}f_CountOutdatedRecords(@0, @1)", new object[] { moduleID, startDate });
   }
   return outdatedRecordsCount;
}

Eh, voila!

Happy DNNing!
Michael

If I wanted to get a single value from a stored procedure, this is how I'd do it:

<code>
CREATE OR ALTER PROCEDURE CountOutdatedRecords (
    @ModuleId int,
    @StartDate datetime
)
AS
BEGIN
    SELECT @moduleId + DATEDIFF(ns, GETUTCDATE(), @StartDate)
END
GO
</code>

From the SQL, just <code>SELECT</code> the value you want.

<code>
protected int GetValue()
{
    using (IDataContext ctx = DataContext.Instance())
    {
        return ctx.ExecuteScalar<int><int>(
            System.Data.CommandType.StoredProcedure, 
            "{databaseOwner}{objectQualifier}CountOutdatedRecords", 
            new object&#91;&#93; { ModuleConfiguration.ModuleID, DateTime.Now });
    }
}
</int></code>

Using <code>ExecuteScalar</code> will get that single value from the <code>SELECT</code> result set.

If you need to use an <code>OUTPUT</code> parameter, this will work:

<code>
CREATE OR ALTER PROCEDURE CountOutdatedRecords (
  @ModuleId int,
  @StartDate datetime,
  @OutdatedRecordsCount int OUTPUT
)
AS
BEGIN
    SELECT @moduleId + DATEDIFF(ns, GETUTCDATE(), @StartDate);
    SET @OutdatedRecordsCount = 123;
END
GO</code>

<code>
protected int GetOutputValue()
{
    using (IDataContext ctx = DataContext.Instance())
    {
        var count = new SqlParameter("@OutdatedRecordsCount", SqlDbType.Int) 
            { 
                Direction = ParameterDirection.Output 
            };
        ctx.Execute(
            CommandType.StoredProcedure, 
            "{databaseOwner}{objectQualifier}CountOutdatedRecords", 
            new SqlParameter("@ModuleId", ModuleConfiguration.ModuleID), 
            new SqlParameter("@StartDate", DateTime.Now),
            count);

        return (int)theResult.Value;
    }
}</code>

Hope it helps!