public static SqlDataReader Title()
    {
        SqlConnection connection = ConnectionManager.GetConnection();

        var command = new SqlCommand("StoredProcedure", connection);

        command.CommandType = CommandType.StoredProcedure;

        SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);

        return reader;
    }

SQLDataReader Return reader

c

C#