EntropyZero Blogging Server

Welcome to EntropyZero Blogging Server Sign in | Join | Help

EntropyZero Blogging Server » EntropyZero Product Forums » dataFresh Product Forum » problems with DataFreshInstance.RefreshTheDatabase();

Reply to an Existing Message

The message you are replying to: problems with DataFreshInstance.RefreshTheDatabase();

Anonymous wrote the following post at 11-09-2006 6:32 AM:

I've tried to start testing on sql2005 with DataFresh but found a problem.

I downloaded your dataFresh sample and tried to implement 2 test cases.
Thats what I had:

public class ExportStatesLoggerDalcTests:TestFixtureBase
{

        [Test]
        public void AddDbName_DbNameNotExists_ReturnsId()
        {
            EntitiesLoggerDalc dalc = new EntitiesLoggerDalc();

            int i = dalc.AddDbName("NewDataName123");
            Assert.Greater(i, 0);
        }

        [Test]
        public void FindDbId_DbNameExists_ReturnsDbId()
        {
            EntitiesLoggerDalc dalc = new EntitiesLoggerDalc();
            int? i = dalc.FindDbId("DbId1"); //in Setup.sql I insert this entity.
            Assert.IsNotNull(i); //Fails, my table is empty.
        }}

I found, that when my second test runs all data is being erased after
DataFreshInstance.RefreshTheDatabase();

but I expected, that the data inserted in Setup.sql is in my tables. Am I right ?

Subject

Message

[quote user="Anonymous"]Hi I&#39;ve tried to&nbsp; start testing on sql2005 with DataFresh but found a problem. I downloaded your dataFresh sample and tried to implement 2 test cases. Thats what I had:&nbsp;public class ExportStatesLoggerDalcTests:TestFixtureBase &nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Test] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; public void AddDbName_DbNameNotExists_ReturnsId() &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EntitiesLoggerDalc dalc = new EntitiesLoggerDalc(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int i = dalc.AddDbName(&quot;NewDataName123&quot;); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Assert.Greater(i, 0); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Test] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; public void FindDbId_DbNameExists_ReturnsDbId() &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EntitiesLoggerDalc dalc = new EntitiesLoggerDalc(); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int? i = dalc.FindDbId(&quot;DbId1&quot;); //in Setup.sql&nbsp; I insert this entity. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Assert.IsNotNull(i); //Fails, my table is empty. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }} I found, that when my second test runs all data is being erased after &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; DataFreshInstance.RefreshTheDatabase();but I expected, that the data inserted in Setup.sql is in my tables. Am I right ? &nbsp; [/quote]