public void Context_can_get_process_data()
        {
            //arrange
            MatProcessData processData = ProcessDataHelper.CreateProcessDataObject();
            var            bsonObject  = BsonDocument.Parse(JsonConvert.SerializeObject(processData));

            collection.InsertOne(bsonObject);
            //act
            var context = new ProcessDbContext(mockOptions.Object);
            var filter  = Builders <BsonDocument> .Filter.Eq("_id", processData.Id);

            var result             = context.getCollection().FindAsync(filter).Result.FirstOrDefault();
            var resultDeserialized = BsonSerializer.Deserialize <MatProcessData>(result);

            //assert
            Assert.Equal(processData.Id, resultDeserialized.Id);
            Assert.Equal(processData.ProcessType.value, resultDeserialized.ProcessType.value);
            Assert.Equal(processData.ProcessType.name, resultDeserialized.ProcessType.name);
            Assert.Equal(processData.ProcessDataAvailable, resultDeserialized.ProcessDataAvailable);
            Assert.Equal(processData.ProcessDataSchemaVersion, resultDeserialized.ProcessDataSchemaVersion);
            Assert.Equal(processData.ProcessStage, resultDeserialized.ProcessStage);
            Assert.Equal(processData.LinkedProcessId, resultDeserialized.LinkedProcessId);
            Assert.Equal(processData.PreProcessData, resultDeserialized.PreProcessData);
            Assert.Equal(processData.ProcessData, resultDeserialized.ProcessData);
            Assert.Equal(processData.PostProcessData, resultDeserialized.PostProcessData);
        }
 public void TearDown()
 {
     using (var ctx = new ProcessDbContext())
     {
         ctx.Database.ExecuteSqlCommand("delete from PROCESS_DEFINITION_ACCOUNT");
         ctx.Database.ExecuteSqlCommand("delete from ACCOUNTS");
         ctx.Database.ExecuteSqlCommand("delete from  PROCESS_DEFINITIONS");
     }
 }
 public void TearDown()
 {
     using (var ctx = new ProcessDbContext())
     {
         ctx.Database.ExecuteSqlCommand("delete from  PROCESSES");
         ctx.Database.ExecuteSqlCommand("delete from PROCESS_DEFINITION_ACCOUNT");
         ctx.Database.ExecuteSqlCommand("delete from ACCOUNTS");
         ctx.Database.ExecuteSqlCommand("delete from  PROCESS_DEFINITIONS");
         ctx.Database.ExecuteSqlCommand("delete from  PROPERTY_ELEMENTS");
         ctx.Database.ExecuteSqlCommand("delete from  PROPERTY_SCHEMA_ELEMENTS");
         ctx.Database.ExecuteSqlCommand("delete from  PROPERTIES_COLLECTIONS");
     }
 }
 public void TearDown()
 {
     // remove collection data
     using (var ctx = new ProcessDbContext())
     {
         try
         {
             ctx.Database.ExecuteSqlCommand("delete from PROPERTY_SCHEMA_ELEMENTS");
             ctx.Database.ExecuteSqlCommand("delete from PROPERTY_ELEMENTS");
             ctx.Database.ExecuteSqlCommand("delete from PROPERTIES_COLLECTIONS");
         }
         catch (Exception ex)
         {
             Console.WriteLine(ex.Message);
         }
     }
 }