public void AddTransformerParametersTest() { IExtraDataTransformer extraFieldsProvider = new SampleLogDataProvider(); DatabaseTraceListener_Accessor target = new DatabaseTraceListener_Accessor( storedProcedureName, logConnectionStringName, null, extraFieldsProvider); object data = new CustomLogEntry { JobId = 12345, RepId = 54321 }; IDbCommand command = new SqlCommand(); //MockRepository mocks = new MockRepository(); //IDbCommand command = mocks.StrictMock<IDbCommand>(); //IDataParameterCollection parameters = mocks.StrictMock<IDataParameterCollection>(); //Expect.Call(command.Parameters).Return(parameters); //Expect.Call(command.Parameters.Add(target.factory.CreateParameter( // (p) => { p.DbType = DbType.String; p.Value = 12345; p.ParameterName = "JobId"; }))); //Expect.Call(command.Parameters).Return(parameters); //Expect.Call(command.Parameters.Add(target.factory.CreateParameter( // (p) => { p.DbType = DbType.String; p.Value = 54321; p.ParameterName = "RepId"; }))); //mocks.ReplayAll(); target.AddTransformerParameters(data, command); //mocks.VerifyAll(); IDataParameter jobParam = command.Parameters["JobId"] as IDataParameter; Assert.IsNotNull(jobParam); Assert.IsNotNull(jobParam.Value); Assert.AreEqual<string>(jobParam.Value.ToString(), "12345"); IDataParameter repParam = command.Parameters["RepId"] as IDataParameter; Assert.IsNotNull(repParam); Assert.IsNotNull(repParam.Value); Assert.AreEqual<string>(repParam.Value.ToString(), "54321"); }
public void AddTransformerParametersTest() { IExtraDataTransformer extraFieldsProvider = new SampleLogDataProvider(); DatabaseTraceListener_Accessor target = new DatabaseTraceListener_Accessor( storedProcedureName, logConnectionStringName, null, extraFieldsProvider); //object data = new CustomLogEntry { JobId = 12345, RepId = 54321 }; //IDbCommand command = new SqlCommand(); //target.AddTransformerParameters(data, command); //IDataParameter jobParam = command.Parameters["JobId"] as IDataParameter; //Assert.IsNotNull(jobParam); //Assert.IsNotNull(jobParam.Value); //Assert.AreEqual<string>(jobParam.Value.ToString(), "12345"); //IDataParameter repParam = command.Parameters["RepId"] as IDataParameter; //Assert.IsNotNull(repParam); //Assert.IsNotNull(repParam.Value); //Assert.AreEqual<string>(repParam.Value.ToString(), "54321"); }