public void ShouldCreateTitles()
		{
			// Arrange
			TitleRepository repository = new TitleRepository(ConfigSettings.MySqlDatabaseConnectionName);
			List<TitleEntity> entities = TitleData.GetItemsForInsert();
			repository.ClearCollection();

			// Act
			entities = repository.Create(entities);

			// Assert
			Assert.IsNotNull(entities);
			Assert.AreEqual(2, entities.Count);
		}
		public void ShouldCreateTitle()
		{
			// Arrange
			TitleRepository repository = new TitleRepository(ConfigSettings.MySqlDatabaseConnectionName);
			TitleEntity entity = TitleData.GetItemForInsert();
			repository.ClearCollection();

			// Act
			entity = repository.Create(entity);

			// Assert
			Assert.IsNotNull(entity);
			Assert.AreNotEqual(0, entity.Id);
		}
		public void ShouldReadTitleWithId()
		{
			// Arrange
			TitleRepository repository = new TitleRepository(ConfigSettings.MySqlDatabaseConnectionName);
			TitleEntity entity = TitleData.GetItemForInsert();
			repository.ClearCollection();

			// Act
			entity = repository.Create(entity);

			// Act
			var actual = repository.Read(entity.Id);

			// Assert
			Assert.AreEqual(entity.Description, actual.Description);
		}
		public void ShouldUpdateTitle()
		{
			// Arrange
			TitleRepository repository = new TitleRepository(ConfigSettings.MySqlDatabaseConnectionName);
			TitleEntity entity = TitleData.GetItemForInsert();
			repository.ClearCollection();
			entity = repository.Create(entity);
			entity.Description = "Dhr";

			// Act
			TitleEntity actual = repository.Update(entity);

			// Assert
			Assert.AreEqual(entity.Description, actual.Description);
		}
		private static void CreateTitles()
		{
			TitleRepository repository = new TitleRepository(ConfigSettings.MySqlDatabaseConnectionName);
			
			TitleEntity entity = new TitleEntity()
			{
				Description = "Dhr",
				DeletedDate = DateTime.MinValue
			};
			TitleEntity mEntity = new TitleEntity()
			{
				Description = "Mvr",
				DeletedDate = DateTime.MinValue
			};

			entity = repository.Create(entity);
			mEntity = repository.Create(mEntity);

			_titleEntities.Add(entity);
			_titleEntities.Add(mEntity);
		}
		public static TitleEntity CreateTitle()
		{
			TitleRepository repository = new TitleRepository(ConfigSettings.MySqlDatabaseConnectionName);
			TitleEntity entity = TitleData.GetItemForInsert();
			//repository.ClearCollection();

			entity = repository.Create(entity);

			return entity;
		}