Test Driven unit testing with stored procedure in VS 2010

Question

I have a class (Not (DAL)) that get's data from DB and give it to me in required format(in specific class format).

Now i need to write a unit test case, but TestContext Data row always return me single row.

I want to fill TestContext by my stored procedure. Please tell me how can i specify stored procedure name. Thanks in advance.

Here Is Code.

public static List<TextValueField> ExternalDataGet(int providerId)
    {
        return ListFactory<TextValueField>.Create(Keys.QAT, "[stats].[GetExternalDataV2]", new object[] { providerId }, TextValueField.Factory);
    }
public static List<T> Create(string key, string sp, object[] parameters, FactoryDelegate factory)
    {
        List<T> list = new List<T>();
        Database db = DatabaseFactory.CreateDatabase(key);
        string connectionString = db.ConnectionStringWithoutCredentials;

        using (DbCommand cmd = db.GetStoredProcCommand(sp, parameters))
        {
            try
            {
                using (cmd.Connection = db.CreateConnection())
                {
                    cmd.Connection.Open();
                    cmd.CommandTimeout = 0;
                    using (DbDataReader reader = cmd.ExecuteReader())
                    {
                        try
                        {
                            while (reader.Read())
                                list.Add(factory(reader));
                        }
                        finally
                        {
                            if (!reader.IsClosed)   
                                reader.Close();
                        }
                    }
                    cmd.Connection.Close();
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
                throw new DataAccessException(ex, key, connectionString, sp, parameters);
            }
            finally
            {
                if (cmd.Connection != null)
                    if (cmd.Connection.State == ConnectionState.Open)
                        cmd.Connection.Close();
            }
        }
        return list;
    }

How do i test a method that return DataSet depending upon the argument supplied. please give me some idea. — Pavan Tiwari, May 01 '12 at 10:22

score 0 · Answer 1 · answered May 04 '12 at 14:28

0

I want to fill TestContext by my stored procedure. Please tell me how can i specify stored procedure name.

This should handle your request.

public static List<TextValueField> ExternalDataGet(int providerId, string storedProc = "[stats].[GetExternalDataV2]")
{
    return ListFactory<TextValueField>.Create(Keys.QAT, storedProc, new object[] { providerId }, TextValueField.Factory);
}

answered May 04 '12 at 14:28

Austin Salonen

49,173
15
109
139

I am waiting for your response. – Pavan Tiwari May 08 '12 at 11:38
@PavanTiwari: Response to what? – Austin Salonen May 08 '12 at 14:24
you answer of above question if u have. – Pavan Tiwari May 08 '12 at 14:50
@PavanTiwari: You haven't asked a question. – Austin Salonen May 08 '12 at 15:14
How does i fill my TestContext with the result of Stored Procedure Data – Pavan Tiwari May 09 '12 at 05:20
@PavanTiwari: Where is TestContext referenced in any of the supplied code? – Austin Salonen May 09 '12 at 14:42

Test Driven unit testing with stored procedure in VS 2010

1 Answers1