Stored Procedure with SimpleRepository

Question

Hi,

How to I execute a Stored Procedure with SimpleRepository and get a Typed List as a answer? I'm using SubSonic 3.

Thanks.

Answer 1

Found my answer:

        StoredProcedure sproc = new StoredProcedure("SprocName", ProviderFactory.GetProvider(ConnectionStringName));

        string input= "input text";
        sproc.Command.AddParameter("input", input, DbType.String);

        return sproc.ExecuteTypedList<T>();