public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test SalesReasonModel inserted = new SalesReasonModel(); inserted.Name = TestSession.Random.RandomString(50); inserted.ReasonType = TestSession.Random.RandomString(50); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new SalesReasonModelPrimaryKey() { SalesReasonID = inserted.SalesReasonID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.SalesReasonID, selectedAfterInsert.SalesReasonID); Assert.AreEqual(inserted.Name, selectedAfterInsert.Name); Assert.AreEqual(inserted.ReasonType, selectedAfterInsert.ReasonType); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.Name = TestSession.Random.RandomString(50); inserted.ReasonType = TestSession.Random.RandomString(50); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new SalesReasonModelPrimaryKey() { SalesReasonID = inserted.SalesReasonID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.SalesReasonID, selectedAfterUpdate.SalesReasonID); Assert.AreEqual(inserted.Name, selectedAfterUpdate.Name); Assert.AreEqual(inserted.ReasonType, selectedAfterUpdate.ReasonType); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new SalesReasonModelPrimaryKey() { SalesReasonID = inserted.SalesReasonID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test AWBuildVersionModel inserted = new AWBuildVersionModel(); inserted.DatabaseVersion = TestSession.Random.RandomString(25); inserted.VersionDate = TestSession.Random.RandomDateTime(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new AWBuildVersionModelPrimaryKey() { SystemInformationID = inserted.SystemInformationID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.SystemInformationID, selectedAfterInsert.SystemInformationID); Assert.AreEqual(inserted.DatabaseVersion, selectedAfterInsert.DatabaseVersion); Assert.AreEqual(inserted.VersionDate, selectedAfterInsert.VersionDate); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.DatabaseVersion = TestSession.Random.RandomString(25); inserted.VersionDate = TestSession.Random.RandomDateTime(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new AWBuildVersionModelPrimaryKey() { SystemInformationID = inserted.SystemInformationID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.SystemInformationID, selectedAfterUpdate.SystemInformationID); Assert.AreEqual(inserted.DatabaseVersion, selectedAfterUpdate.DatabaseVersion); Assert.AreEqual(inserted.VersionDate, selectedAfterUpdate.VersionDate); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new AWBuildVersionModelPrimaryKey() { SystemInformationID = inserted.SystemInformationID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test JobCandidateModel inserted = new JobCandidateModel(); inserted.BusinessEntityID = TestSession.Random.Next(); inserted.Resume = null; //TODO define how to generate random xml; inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new JobCandidateModelPrimaryKey() { JobCandidateID = inserted.JobCandidateID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.JobCandidateID, selectedAfterInsert.JobCandidateID); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterInsert.BusinessEntityID); Assert.AreEqual(inserted.Resume, selectedAfterInsert.Resume); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.BusinessEntityID = TestSession.Random.Next(); inserted.Resume = null; //TODO define how to generate random xml; inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new JobCandidateModelPrimaryKey() { JobCandidateID = inserted.JobCandidateID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.JobCandidateID, selectedAfterUpdate.JobCandidateID); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterUpdate.BusinessEntityID); Assert.AreEqual(inserted.Resume, selectedAfterUpdate.Resume); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new JobCandidateModelPrimaryKey() { JobCandidateID = inserted.JobCandidateID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test ProductDescriptionModel inserted = new ProductDescriptionModel(); inserted.Description = TestSession.Random.RandomString(400); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new ProductDescriptionModelPrimaryKey() { ProductDescriptionID = inserted.ProductDescriptionID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.ProductDescriptionID, selectedAfterInsert.ProductDescriptionID); Assert.AreEqual(inserted.Description, selectedAfterInsert.Description); Assert.AreEqual(inserted.rowguid, selectedAfterInsert.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.Description = TestSession.Random.RandomString(400); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new ProductDescriptionModelPrimaryKey() { ProductDescriptionID = inserted.ProductDescriptionID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.ProductDescriptionID, selectedAfterUpdate.ProductDescriptionID); Assert.AreEqual(inserted.Description, selectedAfterUpdate.Description); Assert.AreEqual(inserted.rowguid, selectedAfterUpdate.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new ProductDescriptionModelPrimaryKey() { ProductDescriptionID = inserted.ProductDescriptionID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test PersonCreditCardModel inserted = new PersonCreditCardModel(); inserted.BusinessEntityID = TestSession.Random.Next(); inserted.CreditCardID = TestSession.Random.Next(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new PersonCreditCardModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, CreditCardID = inserted.CreditCardID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterInsert.BusinessEntityID); Assert.AreEqual(inserted.CreditCardID, selectedAfterInsert.CreditCardID); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new PersonCreditCardModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, CreditCardID = inserted.CreditCardID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterUpdate.BusinessEntityID); Assert.AreEqual(inserted.CreditCardID, selectedAfterUpdate.CreditCardID); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new PersonCreditCardModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, CreditCardID = inserted.CreditCardID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test CountryRegionCurrencyModel inserted = new CountryRegionCurrencyModel(); inserted.CountryRegionCode = TestSession.Random.RandomString(3); inserted.CurrencyCode = TestSession.Random.RandomString(3); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new CountryRegionCurrencyModelPrimaryKey() { CountryRegionCode = inserted.CountryRegionCode, CurrencyCode = inserted.CurrencyCode, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.CountryRegionCode, selectedAfterInsert.CountryRegionCode); Assert.AreEqual(inserted.CurrencyCode, selectedAfterInsert.CurrencyCode); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new CountryRegionCurrencyModelPrimaryKey() { CountryRegionCode = inserted.CountryRegionCode, CurrencyCode = inserted.CurrencyCode, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.CountryRegionCode, selectedAfterUpdate.CountryRegionCode); Assert.AreEqual(inserted.CurrencyCode, selectedAfterUpdate.CurrencyCode); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new CountryRegionCurrencyModelPrimaryKey() { CountryRegionCode = inserted.CountryRegionCode, CurrencyCode = inserted.CurrencyCode, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test ProductDocumentModel inserted = new ProductDocumentModel(); inserted.ProductID = TestSession.Random.Next(); inserted.DocumentNode = Microsoft.SqlServer.Types.SqlHierarchyId.Null; //TODO define how to generate random hierarchy id in test session; inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new ProductDocumentModelPrimaryKey() { ProductID = inserted.ProductID, DocumentNode = inserted.DocumentNode, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.ProductID, selectedAfterInsert.ProductID); Assert.AreEqual(inserted.DocumentNode, selectedAfterInsert.DocumentNode); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new ProductDocumentModelPrimaryKey() { ProductID = inserted.ProductID, DocumentNode = inserted.DocumentNode, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.ProductID, selectedAfterUpdate.ProductID); Assert.AreEqual(inserted.DocumentNode, selectedAfterUpdate.DocumentNode); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new ProductDocumentModelPrimaryKey() { ProductID = inserted.ProductID, DocumentNode = inserted.DocumentNode, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void GetAllIntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); var selecteds = _tested.GetAll(connection); Assert.IsNotNull(selecteds); connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test PersonModel inserted = new PersonModel(); inserted.BusinessEntityID = TestSession.Random.Next(); inserted.PersonType = TestSession.Random.RandomString(2); inserted.NameStyle = Convert.ToBoolean(TestSession.Random.Next(1)); inserted.Title = TestSession.Random.RandomString(8); inserted.FirstName = TestSession.Random.RandomString(50); inserted.MiddleName = TestSession.Random.RandomString(50); inserted.LastName = TestSession.Random.RandomString(50); inserted.Suffix = TestSession.Random.RandomString(10); inserted.EmailPromotion = TestSession.Random.Next(); inserted.AdditionalContactInfo = null; //TODO define how to generate random xml; inserted.Demographics = null; //TODO define how to generate random xml; inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new PersonModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterInsert.BusinessEntityID); Assert.AreEqual(inserted.PersonType, selectedAfterInsert.PersonType); Assert.AreEqual(inserted.NameStyle, selectedAfterInsert.NameStyle); Assert.AreEqual(inserted.Title, selectedAfterInsert.Title); Assert.AreEqual(inserted.FirstName, selectedAfterInsert.FirstName); Assert.AreEqual(inserted.MiddleName, selectedAfterInsert.MiddleName); Assert.AreEqual(inserted.LastName, selectedAfterInsert.LastName); Assert.AreEqual(inserted.Suffix, selectedAfterInsert.Suffix); Assert.AreEqual(inserted.EmailPromotion, selectedAfterInsert.EmailPromotion); Assert.AreEqual(inserted.AdditionalContactInfo, selectedAfterInsert.AdditionalContactInfo); Assert.AreEqual(inserted.Demographics, selectedAfterInsert.Demographics); Assert.AreEqual(inserted.rowguid, selectedAfterInsert.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.PersonType = TestSession.Random.RandomString(2); inserted.NameStyle = Convert.ToBoolean(TestSession.Random.Next(1)); inserted.Title = TestSession.Random.RandomString(8); inserted.FirstName = TestSession.Random.RandomString(50); inserted.MiddleName = TestSession.Random.RandomString(50); inserted.LastName = TestSession.Random.RandomString(50); inserted.Suffix = TestSession.Random.RandomString(10); inserted.EmailPromotion = TestSession.Random.Next(); inserted.AdditionalContactInfo = null; //TODO define how to generate random xml; inserted.Demographics = null; //TODO define how to generate random xml; inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new PersonModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterUpdate.BusinessEntityID); Assert.AreEqual(inserted.PersonType, selectedAfterUpdate.PersonType); Assert.AreEqual(inserted.NameStyle, selectedAfterUpdate.NameStyle); Assert.AreEqual(inserted.Title, selectedAfterUpdate.Title); Assert.AreEqual(inserted.FirstName, selectedAfterUpdate.FirstName); Assert.AreEqual(inserted.MiddleName, selectedAfterUpdate.MiddleName); Assert.AreEqual(inserted.LastName, selectedAfterUpdate.LastName); Assert.AreEqual(inserted.Suffix, selectedAfterUpdate.Suffix); Assert.AreEqual(inserted.EmailPromotion, selectedAfterUpdate.EmailPromotion); Assert.AreEqual(inserted.AdditionalContactInfo, selectedAfterUpdate.AdditionalContactInfo); Assert.AreEqual(inserted.Demographics, selectedAfterUpdate.Demographics); Assert.AreEqual(inserted.rowguid, selectedAfterUpdate.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new PersonModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test ShoppingCartItemModel inserted = new ShoppingCartItemModel(); inserted.ShoppingCartID = TestSession.Random.RandomString(50); inserted.Quantity = TestSession.Random.Next(); inserted.ProductID = TestSession.Random.Next(); inserted.DateCreated = TestSession.Random.RandomDateTime(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new ShoppingCartItemModelPrimaryKey() { ShoppingCartItemID = inserted.ShoppingCartItemID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.ShoppingCartItemID, selectedAfterInsert.ShoppingCartItemID); Assert.AreEqual(inserted.ShoppingCartID, selectedAfterInsert.ShoppingCartID); Assert.AreEqual(inserted.Quantity, selectedAfterInsert.Quantity); Assert.AreEqual(inserted.ProductID, selectedAfterInsert.ProductID); Assert.AreEqual(inserted.DateCreated, selectedAfterInsert.DateCreated); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.ShoppingCartID = TestSession.Random.RandomString(50); inserted.Quantity = TestSession.Random.Next(); inserted.ProductID = TestSession.Random.Next(); inserted.DateCreated = TestSession.Random.RandomDateTime(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new ShoppingCartItemModelPrimaryKey() { ShoppingCartItemID = inserted.ShoppingCartItemID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.ShoppingCartItemID, selectedAfterUpdate.ShoppingCartItemID); Assert.AreEqual(inserted.ShoppingCartID, selectedAfterUpdate.ShoppingCartID); Assert.AreEqual(inserted.Quantity, selectedAfterUpdate.Quantity); Assert.AreEqual(inserted.ProductID, selectedAfterUpdate.ProductID); Assert.AreEqual(inserted.DateCreated, selectedAfterUpdate.DateCreated); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new ShoppingCartItemModelPrimaryKey() { ShoppingCartItemID = inserted.ShoppingCartItemID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test WorkOrderRoutingModel inserted = new WorkOrderRoutingModel(); inserted.WorkOrderID = TestSession.Random.Next(); inserted.ProductID = TestSession.Random.Next(); inserted.OperationSequence = TestSession.Random.RandomShort(); inserted.LocationID = TestSession.Random.RandomShort(); inserted.ScheduledStartDate = TestSession.Random.RandomDateTime(); inserted.ScheduledEndDate = TestSession.Random.RandomDateTime(); inserted.ActualStartDate = TestSession.Random.RandomDateTime(); inserted.ActualEndDate = TestSession.Random.RandomDateTime(); inserted.ActualResourceHrs = TestSession.Random.RandomDecimal(); inserted.PlannedCost = TestSession.Random.RandomDecimal(); inserted.ActualCost = TestSession.Random.RandomDecimal(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new WorkOrderRoutingModelPrimaryKey() { WorkOrderID = inserted.WorkOrderID, ProductID = inserted.ProductID, OperationSequence = inserted.OperationSequence, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.WorkOrderID, selectedAfterInsert.WorkOrderID); Assert.AreEqual(inserted.ProductID, selectedAfterInsert.ProductID); Assert.AreEqual(inserted.OperationSequence, selectedAfterInsert.OperationSequence); Assert.AreEqual(inserted.LocationID, selectedAfterInsert.LocationID); Assert.AreEqual(inserted.ScheduledStartDate, selectedAfterInsert.ScheduledStartDate); Assert.AreEqual(inserted.ScheduledEndDate, selectedAfterInsert.ScheduledEndDate); Assert.AreEqual(inserted.ActualStartDate, selectedAfterInsert.ActualStartDate); Assert.AreEqual(inserted.ActualEndDate, selectedAfterInsert.ActualEndDate); Assert.AreEqual(inserted.ActualResourceHrs, selectedAfterInsert.ActualResourceHrs); Assert.AreEqual(inserted.PlannedCost, selectedAfterInsert.PlannedCost); Assert.AreEqual(inserted.ActualCost, selectedAfterInsert.ActualCost); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.LocationID = TestSession.Random.RandomShort(); inserted.ScheduledStartDate = TestSession.Random.RandomDateTime(); inserted.ScheduledEndDate = TestSession.Random.RandomDateTime(); inserted.ActualStartDate = TestSession.Random.RandomDateTime(); inserted.ActualEndDate = TestSession.Random.RandomDateTime(); inserted.ActualResourceHrs = TestSession.Random.RandomDecimal(); inserted.PlannedCost = TestSession.Random.RandomDecimal(); inserted.ActualCost = TestSession.Random.RandomDecimal(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new WorkOrderRoutingModelPrimaryKey() { WorkOrderID = inserted.WorkOrderID, ProductID = inserted.ProductID, OperationSequence = inserted.OperationSequence, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.WorkOrderID, selectedAfterUpdate.WorkOrderID); Assert.AreEqual(inserted.ProductID, selectedAfterUpdate.ProductID); Assert.AreEqual(inserted.OperationSequence, selectedAfterUpdate.OperationSequence); Assert.AreEqual(inserted.LocationID, selectedAfterUpdate.LocationID); Assert.AreEqual(inserted.ScheduledStartDate, selectedAfterUpdate.ScheduledStartDate); Assert.AreEqual(inserted.ScheduledEndDate, selectedAfterUpdate.ScheduledEndDate); Assert.AreEqual(inserted.ActualStartDate, selectedAfterUpdate.ActualStartDate); Assert.AreEqual(inserted.ActualEndDate, selectedAfterUpdate.ActualEndDate); Assert.AreEqual(inserted.ActualResourceHrs, selectedAfterUpdate.ActualResourceHrs); Assert.AreEqual(inserted.PlannedCost, selectedAfterUpdate.PlannedCost); Assert.AreEqual(inserted.ActualCost, selectedAfterUpdate.ActualCost); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new WorkOrderRoutingModelPrimaryKey() { WorkOrderID = inserted.WorkOrderID, ProductID = inserted.ProductID, OperationSequence = inserted.OperationSequence, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test ErrorLogModel inserted = new ErrorLogModel(); inserted.ErrorTime = TestSession.Random.RandomDateTime(); inserted.UserName = TestSession.Random.RandomString(128); inserted.ErrorNumber = TestSession.Random.Next(); inserted.ErrorSeverity = TestSession.Random.Next(); inserted.ErrorState = TestSession.Random.Next(); inserted.ErrorProcedure = TestSession.Random.RandomString(126); inserted.ErrorLine = TestSession.Random.Next(); inserted.ErrorMessage = TestSession.Random.RandomString(4000); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new ErrorLogModelPrimaryKey() { ErrorLogID = inserted.ErrorLogID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.ErrorLogID, selectedAfterInsert.ErrorLogID); Assert.AreEqual(inserted.ErrorTime, selectedAfterInsert.ErrorTime); Assert.AreEqual(inserted.UserName, selectedAfterInsert.UserName); Assert.AreEqual(inserted.ErrorNumber, selectedAfterInsert.ErrorNumber); Assert.AreEqual(inserted.ErrorSeverity, selectedAfterInsert.ErrorSeverity); Assert.AreEqual(inserted.ErrorState, selectedAfterInsert.ErrorState); Assert.AreEqual(inserted.ErrorProcedure, selectedAfterInsert.ErrorProcedure); Assert.AreEqual(inserted.ErrorLine, selectedAfterInsert.ErrorLine); Assert.AreEqual(inserted.ErrorMessage, selectedAfterInsert.ErrorMessage); #endregion #region update and select by id test inserted.ErrorTime = TestSession.Random.RandomDateTime(); inserted.UserName = TestSession.Random.RandomString(128); inserted.ErrorNumber = TestSession.Random.Next(); inserted.ErrorSeverity = TestSession.Random.Next(); inserted.ErrorState = TestSession.Random.Next(); inserted.ErrorProcedure = TestSession.Random.RandomString(126); inserted.ErrorLine = TestSession.Random.Next(); inserted.ErrorMessage = TestSession.Random.RandomString(4000); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new ErrorLogModelPrimaryKey() { ErrorLogID = inserted.ErrorLogID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.ErrorLogID, selectedAfterUpdate.ErrorLogID); Assert.AreEqual(inserted.ErrorTime, selectedAfterUpdate.ErrorTime); Assert.AreEqual(inserted.UserName, selectedAfterUpdate.UserName); Assert.AreEqual(inserted.ErrorNumber, selectedAfterUpdate.ErrorNumber); Assert.AreEqual(inserted.ErrorSeverity, selectedAfterUpdate.ErrorSeverity); Assert.AreEqual(inserted.ErrorState, selectedAfterUpdate.ErrorState); Assert.AreEqual(inserted.ErrorProcedure, selectedAfterUpdate.ErrorProcedure); Assert.AreEqual(inserted.ErrorLine, selectedAfterUpdate.ErrorLine); Assert.AreEqual(inserted.ErrorMessage, selectedAfterUpdate.ErrorMessage); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new ErrorLogModelPrimaryKey() { ErrorLogID = inserted.ErrorLogID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test SalesPersonModel inserted = new SalesPersonModel(); inserted.BusinessEntityID = TestSession.Random.Next(); inserted.TerritoryID = TestSession.Random.Next(); inserted.SalesQuota = TestSession.Random.RandomDecimal(); inserted.Bonus = TestSession.Random.RandomDecimal(); inserted.CommissionPct = Convert.ToDecimal(TestSession.Random.Next()); inserted.SalesYTD = TestSession.Random.RandomDecimal(); inserted.SalesLastYear = TestSession.Random.RandomDecimal(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new SalesPersonModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterInsert.BusinessEntityID); Assert.AreEqual(inserted.TerritoryID, selectedAfterInsert.TerritoryID); Assert.AreEqual(inserted.SalesQuota, selectedAfterInsert.SalesQuota); Assert.AreEqual(inserted.Bonus, selectedAfterInsert.Bonus); Assert.AreEqual(inserted.CommissionPct, selectedAfterInsert.CommissionPct); Assert.AreEqual(inserted.SalesYTD, selectedAfterInsert.SalesYTD); Assert.AreEqual(inserted.SalesLastYear, selectedAfterInsert.SalesLastYear); Assert.AreEqual(inserted.rowguid, selectedAfterInsert.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.TerritoryID = TestSession.Random.Next(); inserted.SalesQuota = TestSession.Random.RandomDecimal(); inserted.Bonus = TestSession.Random.RandomDecimal(); inserted.CommissionPct = Convert.ToDecimal(TestSession.Random.Next()); inserted.SalesYTD = TestSession.Random.RandomDecimal(); inserted.SalesLastYear = TestSession.Random.RandomDecimal(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new SalesPersonModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterUpdate.BusinessEntityID); Assert.AreEqual(inserted.TerritoryID, selectedAfterUpdate.TerritoryID); Assert.AreEqual(inserted.SalesQuota, selectedAfterUpdate.SalesQuota); Assert.AreEqual(inserted.Bonus, selectedAfterUpdate.Bonus); Assert.AreEqual(inserted.CommissionPct, selectedAfterUpdate.CommissionPct); Assert.AreEqual(inserted.SalesYTD, selectedAfterUpdate.SalesYTD); Assert.AreEqual(inserted.SalesLastYear, selectedAfterUpdate.SalesLastYear); Assert.AreEqual(inserted.rowguid, selectedAfterUpdate.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new SalesPersonModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test EmployeeDepartmentHistoryModel inserted = new EmployeeDepartmentHistoryModel(); inserted.BusinessEntityID = TestSession.Random.Next(); inserted.DepartmentID = TestSession.Random.RandomShort(); inserted.ShiftID = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.StartDate = TestSession.Random.RandomDateTime(); inserted.EndDate = TestSession.Random.RandomDateTime(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new EmployeeDepartmentHistoryModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, DepartmentID = inserted.DepartmentID, ShiftID = inserted.ShiftID, StartDate = inserted.StartDate, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterInsert.BusinessEntityID); Assert.AreEqual(inserted.DepartmentID, selectedAfterInsert.DepartmentID); Assert.AreEqual(inserted.ShiftID, selectedAfterInsert.ShiftID); Assert.AreEqual(inserted.StartDate, selectedAfterInsert.StartDate); Assert.AreEqual(inserted.EndDate, selectedAfterInsert.EndDate); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.EndDate = TestSession.Random.RandomDateTime(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new EmployeeDepartmentHistoryModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, DepartmentID = inserted.DepartmentID, ShiftID = inserted.ShiftID, StartDate = inserted.StartDate, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterUpdate.BusinessEntityID); Assert.AreEqual(inserted.DepartmentID, selectedAfterUpdate.DepartmentID); Assert.AreEqual(inserted.ShiftID, selectedAfterUpdate.ShiftID); Assert.AreEqual(inserted.StartDate, selectedAfterUpdate.StartDate); Assert.AreEqual(inserted.EndDate, selectedAfterUpdate.EndDate); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new EmployeeDepartmentHistoryModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, DepartmentID = inserted.DepartmentID, ShiftID = inserted.ShiftID, StartDate = inserted.StartDate, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test BillOfMaterialsModel inserted = new BillOfMaterialsModel(); inserted.ProductAssemblyID = TestSession.Random.Next(); inserted.ComponentID = TestSession.Random.Next(); inserted.StartDate = TestSession.Random.RandomDateTime(); inserted.EndDate = TestSession.Random.RandomDateTime(); inserted.UnitMeasureCode = TestSession.Random.RandomString(3); inserted.BOMLevel = TestSession.Random.RandomShort(); inserted.PerAssemblyQty = TestSession.Random.RandomDecimal(8, 2); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new BillOfMaterialsModelPrimaryKey() { BillOfMaterialsID = inserted.BillOfMaterialsID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.BillOfMaterialsID, selectedAfterInsert.BillOfMaterialsID); Assert.AreEqual(inserted.ProductAssemblyID, selectedAfterInsert.ProductAssemblyID); Assert.AreEqual(inserted.ComponentID, selectedAfterInsert.ComponentID); Assert.AreEqual(inserted.StartDate, selectedAfterInsert.StartDate); Assert.AreEqual(inserted.EndDate, selectedAfterInsert.EndDate); Assert.AreEqual(inserted.UnitMeasureCode, selectedAfterInsert.UnitMeasureCode); Assert.AreEqual(inserted.BOMLevel, selectedAfterInsert.BOMLevel); Assert.AreEqual(inserted.PerAssemblyQty, selectedAfterInsert.PerAssemblyQty); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.ProductAssemblyID = TestSession.Random.Next(); inserted.ComponentID = TestSession.Random.Next(); inserted.StartDate = TestSession.Random.RandomDateTime(); inserted.EndDate = TestSession.Random.RandomDateTime(); inserted.UnitMeasureCode = TestSession.Random.RandomString(3); inserted.BOMLevel = TestSession.Random.RandomShort(); inserted.PerAssemblyQty = TestSession.Random.RandomDecimal(8, 2); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new BillOfMaterialsModelPrimaryKey() { BillOfMaterialsID = inserted.BillOfMaterialsID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.BillOfMaterialsID, selectedAfterUpdate.BillOfMaterialsID); Assert.AreEqual(inserted.ProductAssemblyID, selectedAfterUpdate.ProductAssemblyID); Assert.AreEqual(inserted.ComponentID, selectedAfterUpdate.ComponentID); Assert.AreEqual(inserted.StartDate, selectedAfterUpdate.StartDate); Assert.AreEqual(inserted.EndDate, selectedAfterUpdate.EndDate); Assert.AreEqual(inserted.UnitMeasureCode, selectedAfterUpdate.UnitMeasureCode); Assert.AreEqual(inserted.BOMLevel, selectedAfterUpdate.BOMLevel); Assert.AreEqual(inserted.PerAssemblyQty, selectedAfterUpdate.PerAssemblyQty); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new BillOfMaterialsModelPrimaryKey() { BillOfMaterialsID = inserted.BillOfMaterialsID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test PasswordModel inserted = new PasswordModel(); inserted.BusinessEntityID = TestSession.Random.Next(); inserted.PasswordHash = TestSession.Random.RandomString(128); inserted.PasswordSalt = TestSession.Random.RandomString(10); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new PasswordModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterInsert.BusinessEntityID); Assert.AreEqual(inserted.PasswordHash, selectedAfterInsert.PasswordHash); Assert.AreEqual(inserted.PasswordSalt, selectedAfterInsert.PasswordSalt); Assert.AreEqual(inserted.rowguid, selectedAfterInsert.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.PasswordHash = TestSession.Random.RandomString(128); inserted.PasswordSalt = TestSession.Random.RandomString(10); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new PasswordModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterUpdate.BusinessEntityID); Assert.AreEqual(inserted.PasswordHash, selectedAfterUpdate.PasswordHash); Assert.AreEqual(inserted.PasswordSalt, selectedAfterUpdate.PasswordSalt); Assert.AreEqual(inserted.rowguid, selectedAfterUpdate.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new PasswordModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test ProductReviewModel inserted = new ProductReviewModel(); inserted.ProductID = TestSession.Random.Next(); inserted.ReviewerName = TestSession.Random.RandomString(50); inserted.ReviewDate = TestSession.Random.RandomDateTime(); inserted.EmailAddress = TestSession.Random.RandomString(50); inserted.Rating = TestSession.Random.Next(); inserted.Comments = TestSession.Random.RandomString(3850); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new ProductReviewModelPrimaryKey() { ProductReviewID = inserted.ProductReviewID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.ProductReviewID, selectedAfterInsert.ProductReviewID); Assert.AreEqual(inserted.ProductID, selectedAfterInsert.ProductID); Assert.AreEqual(inserted.ReviewerName, selectedAfterInsert.ReviewerName); Assert.AreEqual(inserted.ReviewDate, selectedAfterInsert.ReviewDate); Assert.AreEqual(inserted.EmailAddress, selectedAfterInsert.EmailAddress); Assert.AreEqual(inserted.Rating, selectedAfterInsert.Rating); Assert.AreEqual(inserted.Comments, selectedAfterInsert.Comments); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.ProductID = TestSession.Random.Next(); inserted.ReviewerName = TestSession.Random.RandomString(50); inserted.ReviewDate = TestSession.Random.RandomDateTime(); inserted.EmailAddress = TestSession.Random.RandomString(50); inserted.Rating = TestSession.Random.Next(); inserted.Comments = TestSession.Random.RandomString(3850); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new ProductReviewModelPrimaryKey() { ProductReviewID = inserted.ProductReviewID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.ProductReviewID, selectedAfterUpdate.ProductReviewID); Assert.AreEqual(inserted.ProductID, selectedAfterUpdate.ProductID); Assert.AreEqual(inserted.ReviewerName, selectedAfterUpdate.ReviewerName); Assert.AreEqual(inserted.ReviewDate, selectedAfterUpdate.ReviewDate); Assert.AreEqual(inserted.EmailAddress, selectedAfterUpdate.EmailAddress); Assert.AreEqual(inserted.Rating, selectedAfterUpdate.Rating); Assert.AreEqual(inserted.Comments, selectedAfterUpdate.Comments); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new ProductReviewModelPrimaryKey() { ProductReviewID = inserted.ProductReviewID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test StateProvinceModel inserted = new StateProvinceModel(); inserted.StateProvinceCode = TestSession.Random.RandomString(3); inserted.CountryRegionCode = TestSession.Random.RandomString(3); inserted.IsOnlyStateProvinceFlag = Convert.ToBoolean(TestSession.Random.Next(1)); inserted.Name = TestSession.Random.RandomString(50); inserted.TerritoryID = TestSession.Random.Next(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new StateProvinceModelPrimaryKey() { StateProvinceID = inserted.StateProvinceID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.StateProvinceID, selectedAfterInsert.StateProvinceID); Assert.AreEqual(inserted.StateProvinceCode, selectedAfterInsert.StateProvinceCode); Assert.AreEqual(inserted.CountryRegionCode, selectedAfterInsert.CountryRegionCode); Assert.AreEqual(inserted.IsOnlyStateProvinceFlag, selectedAfterInsert.IsOnlyStateProvinceFlag); Assert.AreEqual(inserted.Name, selectedAfterInsert.Name); Assert.AreEqual(inserted.TerritoryID, selectedAfterInsert.TerritoryID); Assert.AreEqual(inserted.rowguid, selectedAfterInsert.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.StateProvinceCode = TestSession.Random.RandomString(3); inserted.CountryRegionCode = TestSession.Random.RandomString(3); inserted.IsOnlyStateProvinceFlag = Convert.ToBoolean(TestSession.Random.Next(1)); inserted.Name = TestSession.Random.RandomString(50); inserted.TerritoryID = TestSession.Random.Next(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new StateProvinceModelPrimaryKey() { StateProvinceID = inserted.StateProvinceID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.StateProvinceID, selectedAfterUpdate.StateProvinceID); Assert.AreEqual(inserted.StateProvinceCode, selectedAfterUpdate.StateProvinceCode); Assert.AreEqual(inserted.CountryRegionCode, selectedAfterUpdate.CountryRegionCode); Assert.AreEqual(inserted.IsOnlyStateProvinceFlag, selectedAfterUpdate.IsOnlyStateProvinceFlag); Assert.AreEqual(inserted.Name, selectedAfterUpdate.Name); Assert.AreEqual(inserted.TerritoryID, selectedAfterUpdate.TerritoryID); Assert.AreEqual(inserted.rowguid, selectedAfterUpdate.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new StateProvinceModelPrimaryKey() { StateProvinceID = inserted.StateProvinceID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test AddressModel inserted = new AddressModel(); inserted.AddressLine1 = TestSession.Random.RandomString(60); inserted.AddressLine2 = TestSession.Random.RandomString(60); inserted.City = TestSession.Random.RandomString(30); inserted.StateProvinceID = TestSession.Random.Next(); inserted.PostalCode = TestSession.Random.RandomString(15); inserted.SpatialLocation = TestSession.Random.RandomSqlGeography(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new AddressModelPrimaryKey() { AddressID = inserted.AddressID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.AddressID, selectedAfterInsert.AddressID); Assert.AreEqual(inserted.AddressLine1, selectedAfterInsert.AddressLine1); Assert.AreEqual(inserted.AddressLine2, selectedAfterInsert.AddressLine2); Assert.AreEqual(inserted.City, selectedAfterInsert.City); Assert.AreEqual(inserted.StateProvinceID, selectedAfterInsert.StateProvinceID); Assert.AreEqual(inserted.PostalCode, selectedAfterInsert.PostalCode); Assert.AreEqual(inserted.SpatialLocation, selectedAfterInsert.SpatialLocation); Assert.AreEqual(inserted.rowguid, selectedAfterInsert.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.AddressLine1 = TestSession.Random.RandomString(60); inserted.AddressLine2 = TestSession.Random.RandomString(60); inserted.City = TestSession.Random.RandomString(30); inserted.StateProvinceID = TestSession.Random.Next(); inserted.PostalCode = TestSession.Random.RandomString(15); inserted.SpatialLocation = TestSession.Random.RandomSqlGeography(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new AddressModelPrimaryKey() { AddressID = inserted.AddressID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.AddressID, selectedAfterUpdate.AddressID); Assert.AreEqual(inserted.AddressLine1, selectedAfterUpdate.AddressLine1); Assert.AreEqual(inserted.AddressLine2, selectedAfterUpdate.AddressLine2); Assert.AreEqual(inserted.City, selectedAfterUpdate.City); Assert.AreEqual(inserted.StateProvinceID, selectedAfterUpdate.StateProvinceID); Assert.AreEqual(inserted.PostalCode, selectedAfterUpdate.PostalCode); Assert.AreEqual(inserted.SpatialLocation, selectedAfterUpdate.SpatialLocation); Assert.AreEqual(inserted.rowguid, selectedAfterUpdate.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new AddressModelPrimaryKey() { AddressID = inserted.AddressID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test PurchaseOrderHeaderModel inserted = new PurchaseOrderHeaderModel(); inserted.RevisionNumber = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.Status = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.EmployeeID = TestSession.Random.Next(); inserted.VendorID = TestSession.Random.Next(); inserted.ShipMethodID = TestSession.Random.Next(); inserted.OrderDate = TestSession.Random.RandomDateTime(); inserted.ShipDate = TestSession.Random.RandomDateTime(); inserted.SubTotal = TestSession.Random.RandomDecimal(); inserted.TaxAmt = TestSession.Random.RandomDecimal(); inserted.Freight = TestSession.Random.RandomDecimal(); inserted.TotalDue = TestSession.Random.RandomDecimal(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new PurchaseOrderHeaderModelPrimaryKey() { PurchaseOrderID = inserted.PurchaseOrderID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.PurchaseOrderID, selectedAfterInsert.PurchaseOrderID); Assert.AreEqual(inserted.RevisionNumber, selectedAfterInsert.RevisionNumber); Assert.AreEqual(inserted.Status, selectedAfterInsert.Status); Assert.AreEqual(inserted.EmployeeID, selectedAfterInsert.EmployeeID); Assert.AreEqual(inserted.VendorID, selectedAfterInsert.VendorID); Assert.AreEqual(inserted.ShipMethodID, selectedAfterInsert.ShipMethodID); Assert.AreEqual(inserted.OrderDate, selectedAfterInsert.OrderDate); Assert.AreEqual(inserted.ShipDate, selectedAfterInsert.ShipDate); Assert.AreEqual(inserted.SubTotal, selectedAfterInsert.SubTotal); Assert.AreEqual(inserted.TaxAmt, selectedAfterInsert.TaxAmt); Assert.AreEqual(inserted.Freight, selectedAfterInsert.Freight); Assert.AreEqual(inserted.TotalDue, selectedAfterInsert.TotalDue); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.RevisionNumber = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.Status = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.EmployeeID = TestSession.Random.Next(); inserted.VendorID = TestSession.Random.Next(); inserted.ShipMethodID = TestSession.Random.Next(); inserted.OrderDate = TestSession.Random.RandomDateTime(); inserted.ShipDate = TestSession.Random.RandomDateTime(); inserted.SubTotal = TestSession.Random.RandomDecimal(); inserted.TaxAmt = TestSession.Random.RandomDecimal(); inserted.Freight = TestSession.Random.RandomDecimal(); inserted.TotalDue = TestSession.Random.RandomDecimal(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new PurchaseOrderHeaderModelPrimaryKey() { PurchaseOrderID = inserted.PurchaseOrderID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.PurchaseOrderID, selectedAfterUpdate.PurchaseOrderID); Assert.AreEqual(inserted.RevisionNumber, selectedAfterUpdate.RevisionNumber); Assert.AreEqual(inserted.Status, selectedAfterUpdate.Status); Assert.AreEqual(inserted.EmployeeID, selectedAfterUpdate.EmployeeID); Assert.AreEqual(inserted.VendorID, selectedAfterUpdate.VendorID); Assert.AreEqual(inserted.ShipMethodID, selectedAfterUpdate.ShipMethodID); Assert.AreEqual(inserted.OrderDate, selectedAfterUpdate.OrderDate); Assert.AreEqual(inserted.ShipDate, selectedAfterUpdate.ShipDate); Assert.AreEqual(inserted.SubTotal, selectedAfterUpdate.SubTotal); Assert.AreEqual(inserted.TaxAmt, selectedAfterUpdate.TaxAmt); Assert.AreEqual(inserted.Freight, selectedAfterUpdate.Freight); Assert.AreEqual(inserted.TotalDue, selectedAfterUpdate.TotalDue); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new PurchaseOrderHeaderModelPrimaryKey() { PurchaseOrderID = inserted.PurchaseOrderID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test CreditCardModel inserted = new CreditCardModel(); inserted.CardType = TestSession.Random.RandomString(50); inserted.CardNumber = TestSession.Random.RandomString(25); inserted.ExpMonth = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.ExpYear = TestSession.Random.RandomShort(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new CreditCardModelPrimaryKey() { CreditCardID = inserted.CreditCardID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.CreditCardID, selectedAfterInsert.CreditCardID); Assert.AreEqual(inserted.CardType, selectedAfterInsert.CardType); Assert.AreEqual(inserted.CardNumber, selectedAfterInsert.CardNumber); Assert.AreEqual(inserted.ExpMonth, selectedAfterInsert.ExpMonth); Assert.AreEqual(inserted.ExpYear, selectedAfterInsert.ExpYear); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.CardType = TestSession.Random.RandomString(50); inserted.CardNumber = TestSession.Random.RandomString(25); inserted.ExpMonth = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.ExpYear = TestSession.Random.RandomShort(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new CreditCardModelPrimaryKey() { CreditCardID = inserted.CreditCardID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.CreditCardID, selectedAfterUpdate.CreditCardID); Assert.AreEqual(inserted.CardType, selectedAfterUpdate.CardType); Assert.AreEqual(inserted.CardNumber, selectedAfterUpdate.CardNumber); Assert.AreEqual(inserted.ExpMonth, selectedAfterUpdate.ExpMonth); Assert.AreEqual(inserted.ExpYear, selectedAfterUpdate.ExpYear); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new CreditCardModelPrimaryKey() { CreditCardID = inserted.CreditCardID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test PurchaseOrderDetailModel inserted = new PurchaseOrderDetailModel(); inserted.PurchaseOrderID = TestSession.Random.Next(); inserted.DueDate = TestSession.Random.RandomDateTime(); inserted.OrderQty = TestSession.Random.RandomShort(); inserted.ProductID = TestSession.Random.Next(); inserted.UnitPrice = TestSession.Random.RandomDecimal(); inserted.LineTotal = TestSession.Random.RandomDecimal(); inserted.ReceivedQty = TestSession.Random.RandomDecimal(); inserted.RejectedQty = TestSession.Random.RandomDecimal(); inserted.StockedQty = TestSession.Random.RandomDecimal(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new PurchaseOrderDetailModelPrimaryKey() { PurchaseOrderID = inserted.PurchaseOrderID, PurchaseOrderDetailID = inserted.PurchaseOrderDetailID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.PurchaseOrderID, selectedAfterInsert.PurchaseOrderID); Assert.AreEqual(inserted.PurchaseOrderDetailID, selectedAfterInsert.PurchaseOrderDetailID); Assert.AreEqual(inserted.DueDate, selectedAfterInsert.DueDate); Assert.AreEqual(inserted.OrderQty, selectedAfterInsert.OrderQty); Assert.AreEqual(inserted.ProductID, selectedAfterInsert.ProductID); Assert.AreEqual(inserted.UnitPrice, selectedAfterInsert.UnitPrice); Assert.AreEqual(inserted.LineTotal, selectedAfterInsert.LineTotal); Assert.AreEqual(inserted.ReceivedQty, selectedAfterInsert.ReceivedQty); Assert.AreEqual(inserted.RejectedQty, selectedAfterInsert.RejectedQty); Assert.AreEqual(inserted.StockedQty, selectedAfterInsert.StockedQty); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.DueDate = TestSession.Random.RandomDateTime(); inserted.OrderQty = TestSession.Random.RandomShort(); inserted.ProductID = TestSession.Random.Next(); inserted.UnitPrice = TestSession.Random.RandomDecimal(); inserted.LineTotal = TestSession.Random.RandomDecimal(); inserted.ReceivedQty = TestSession.Random.RandomDecimal(); inserted.RejectedQty = TestSession.Random.RandomDecimal(); inserted.StockedQty = TestSession.Random.RandomDecimal(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new PurchaseOrderDetailModelPrimaryKey() { PurchaseOrderID = inserted.PurchaseOrderID, PurchaseOrderDetailID = inserted.PurchaseOrderDetailID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.PurchaseOrderID, selectedAfterUpdate.PurchaseOrderID); Assert.AreEqual(inserted.PurchaseOrderDetailID, selectedAfterUpdate.PurchaseOrderDetailID); Assert.AreEqual(inserted.DueDate, selectedAfterUpdate.DueDate); Assert.AreEqual(inserted.OrderQty, selectedAfterUpdate.OrderQty); Assert.AreEqual(inserted.ProductID, selectedAfterUpdate.ProductID); Assert.AreEqual(inserted.UnitPrice, selectedAfterUpdate.UnitPrice); Assert.AreEqual(inserted.LineTotal, selectedAfterUpdate.LineTotal); Assert.AreEqual(inserted.ReceivedQty, selectedAfterUpdate.ReceivedQty); Assert.AreEqual(inserted.RejectedQty, selectedAfterUpdate.RejectedQty); Assert.AreEqual(inserted.StockedQty, selectedAfterUpdate.StockedQty); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new PurchaseOrderDetailModelPrimaryKey() { PurchaseOrderID = inserted.PurchaseOrderID, PurchaseOrderDetailID = inserted.PurchaseOrderDetailID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test SalesTerritoryHistoryModel inserted = new SalesTerritoryHistoryModel(); inserted.BusinessEntityID = TestSession.Random.Next(); inserted.TerritoryID = TestSession.Random.Next(); inserted.StartDate = TestSession.Random.RandomDateTime(); inserted.EndDate = TestSession.Random.RandomDateTime(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new SalesTerritoryHistoryModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, TerritoryID = inserted.TerritoryID, StartDate = inserted.StartDate, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterInsert.BusinessEntityID); Assert.AreEqual(inserted.TerritoryID, selectedAfterInsert.TerritoryID); Assert.AreEqual(inserted.StartDate, selectedAfterInsert.StartDate); Assert.AreEqual(inserted.EndDate, selectedAfterInsert.EndDate); Assert.AreEqual(inserted.rowguid, selectedAfterInsert.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.EndDate = TestSession.Random.RandomDateTime(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new SalesTerritoryHistoryModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, TerritoryID = inserted.TerritoryID, StartDate = inserted.StartDate, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterUpdate.BusinessEntityID); Assert.AreEqual(inserted.TerritoryID, selectedAfterUpdate.TerritoryID); Assert.AreEqual(inserted.StartDate, selectedAfterUpdate.StartDate); Assert.AreEqual(inserted.EndDate, selectedAfterUpdate.EndDate); Assert.AreEqual(inserted.rowguid, selectedAfterUpdate.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new SalesTerritoryHistoryModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, TerritoryID = inserted.TerritoryID, StartDate = inserted.StartDate, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test WorkOrderModel inserted = new WorkOrderModel(); inserted.ProductID = TestSession.Random.Next(); inserted.OrderQty = TestSession.Random.Next(); inserted.StockedQty = TestSession.Random.Next(); inserted.ScrappedQty = TestSession.Random.RandomShort(); inserted.StartDate = TestSession.Random.RandomDateTime(); inserted.EndDate = TestSession.Random.RandomDateTime(); inserted.DueDate = TestSession.Random.RandomDateTime(); inserted.ScrapReasonID = TestSession.Random.RandomShort(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new WorkOrderModelPrimaryKey() { WorkOrderID = inserted.WorkOrderID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.WorkOrderID, selectedAfterInsert.WorkOrderID); Assert.AreEqual(inserted.ProductID, selectedAfterInsert.ProductID); Assert.AreEqual(inserted.OrderQty, selectedAfterInsert.OrderQty); Assert.AreEqual(inserted.StockedQty, selectedAfterInsert.StockedQty); Assert.AreEqual(inserted.ScrappedQty, selectedAfterInsert.ScrappedQty); Assert.AreEqual(inserted.StartDate, selectedAfterInsert.StartDate); Assert.AreEqual(inserted.EndDate, selectedAfterInsert.EndDate); Assert.AreEqual(inserted.DueDate, selectedAfterInsert.DueDate); Assert.AreEqual(inserted.ScrapReasonID, selectedAfterInsert.ScrapReasonID); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.ProductID = TestSession.Random.Next(); inserted.OrderQty = TestSession.Random.Next(); inserted.StockedQty = TestSession.Random.Next(); inserted.ScrappedQty = TestSession.Random.RandomShort(); inserted.StartDate = TestSession.Random.RandomDateTime(); inserted.EndDate = TestSession.Random.RandomDateTime(); inserted.DueDate = TestSession.Random.RandomDateTime(); inserted.ScrapReasonID = TestSession.Random.RandomShort(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new WorkOrderModelPrimaryKey() { WorkOrderID = inserted.WorkOrderID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.WorkOrderID, selectedAfterUpdate.WorkOrderID); Assert.AreEqual(inserted.ProductID, selectedAfterUpdate.ProductID); Assert.AreEqual(inserted.OrderQty, selectedAfterUpdate.OrderQty); Assert.AreEqual(inserted.StockedQty, selectedAfterUpdate.StockedQty); Assert.AreEqual(inserted.ScrappedQty, selectedAfterUpdate.ScrappedQty); Assert.AreEqual(inserted.StartDate, selectedAfterUpdate.StartDate); Assert.AreEqual(inserted.EndDate, selectedAfterUpdate.EndDate); Assert.AreEqual(inserted.DueDate, selectedAfterUpdate.DueDate); Assert.AreEqual(inserted.ScrapReasonID, selectedAfterUpdate.ScrapReasonID); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new WorkOrderModelPrimaryKey() { WorkOrderID = inserted.WorkOrderID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test ProductListPriceHistoryModel inserted = new ProductListPriceHistoryModel(); inserted.ProductID = TestSession.Random.Next(); inserted.StartDate = TestSession.Random.RandomDateTime(); inserted.EndDate = TestSession.Random.RandomDateTime(); inserted.ListPrice = TestSession.Random.RandomDecimal(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new ProductListPriceHistoryModelPrimaryKey() { ProductID = inserted.ProductID, StartDate = inserted.StartDate, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.ProductID, selectedAfterInsert.ProductID); Assert.AreEqual(inserted.StartDate, selectedAfterInsert.StartDate); Assert.AreEqual(inserted.EndDate, selectedAfterInsert.EndDate); Assert.AreEqual(inserted.ListPrice, selectedAfterInsert.ListPrice); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.EndDate = TestSession.Random.RandomDateTime(); inserted.ListPrice = TestSession.Random.RandomDecimal(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new ProductListPriceHistoryModelPrimaryKey() { ProductID = inserted.ProductID, StartDate = inserted.StartDate, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.ProductID, selectedAfterUpdate.ProductID); Assert.AreEqual(inserted.StartDate, selectedAfterUpdate.StartDate); Assert.AreEqual(inserted.EndDate, selectedAfterUpdate.EndDate); Assert.AreEqual(inserted.ListPrice, selectedAfterUpdate.ListPrice); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new ProductListPriceHistoryModelPrimaryKey() { ProductID = inserted.ProductID, StartDate = inserted.StartDate, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test SalesOrderHeaderModel inserted = new SalesOrderHeaderModel(); inserted.RevisionNumber = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.OrderDate = TestSession.Random.RandomDateTime(); inserted.DueDate = TestSession.Random.RandomDateTime(); inserted.ShipDate = TestSession.Random.RandomDateTime(); inserted.Status = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.OnlineOrderFlag = Convert.ToBoolean(TestSession.Random.Next(1)); inserted.SalesOrderNumber = TestSession.Random.RandomString(25); inserted.PurchaseOrderNumber = TestSession.Random.RandomString(25); inserted.AccountNumber = TestSession.Random.RandomString(15); inserted.CustomerID = TestSession.Random.Next(); inserted.SalesPersonID = TestSession.Random.Next(); inserted.TerritoryID = TestSession.Random.Next(); inserted.BillToAddressID = TestSession.Random.Next(); inserted.ShipToAddressID = TestSession.Random.Next(); inserted.ShipMethodID = TestSession.Random.Next(); inserted.CreditCardID = TestSession.Random.Next(); inserted.CreditCardApprovalCode = TestSession.Random.RandomString(15); inserted.CurrencyRateID = TestSession.Random.Next(); inserted.SubTotal = TestSession.Random.RandomDecimal(); inserted.TaxAmt = TestSession.Random.RandomDecimal(); inserted.Freight = TestSession.Random.RandomDecimal(); inserted.TotalDue = TestSession.Random.RandomDecimal(); inserted.Comment = TestSession.Random.RandomString(128); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new SalesOrderHeaderModelPrimaryKey() { SalesOrderID = inserted.SalesOrderID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.SalesOrderID, selectedAfterInsert.SalesOrderID); Assert.AreEqual(inserted.RevisionNumber, selectedAfterInsert.RevisionNumber); Assert.AreEqual(inserted.OrderDate, selectedAfterInsert.OrderDate); Assert.AreEqual(inserted.DueDate, selectedAfterInsert.DueDate); Assert.AreEqual(inserted.ShipDate, selectedAfterInsert.ShipDate); Assert.AreEqual(inserted.Status, selectedAfterInsert.Status); Assert.AreEqual(inserted.OnlineOrderFlag, selectedAfterInsert.OnlineOrderFlag); Assert.AreEqual(inserted.SalesOrderNumber, selectedAfterInsert.SalesOrderNumber); Assert.AreEqual(inserted.PurchaseOrderNumber, selectedAfterInsert.PurchaseOrderNumber); Assert.AreEqual(inserted.AccountNumber, selectedAfterInsert.AccountNumber); Assert.AreEqual(inserted.CustomerID, selectedAfterInsert.CustomerID); Assert.AreEqual(inserted.SalesPersonID, selectedAfterInsert.SalesPersonID); Assert.AreEqual(inserted.TerritoryID, selectedAfterInsert.TerritoryID); Assert.AreEqual(inserted.BillToAddressID, selectedAfterInsert.BillToAddressID); Assert.AreEqual(inserted.ShipToAddressID, selectedAfterInsert.ShipToAddressID); Assert.AreEqual(inserted.ShipMethodID, selectedAfterInsert.ShipMethodID); Assert.AreEqual(inserted.CreditCardID, selectedAfterInsert.CreditCardID); Assert.AreEqual(inserted.CreditCardApprovalCode, selectedAfterInsert.CreditCardApprovalCode); Assert.AreEqual(inserted.CurrencyRateID, selectedAfterInsert.CurrencyRateID); Assert.AreEqual(inserted.SubTotal, selectedAfterInsert.SubTotal); Assert.AreEqual(inserted.TaxAmt, selectedAfterInsert.TaxAmt); Assert.AreEqual(inserted.Freight, selectedAfterInsert.Freight); Assert.AreEqual(inserted.TotalDue, selectedAfterInsert.TotalDue); Assert.AreEqual(inserted.Comment, selectedAfterInsert.Comment); Assert.AreEqual(inserted.rowguid, selectedAfterInsert.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.RevisionNumber = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.OrderDate = TestSession.Random.RandomDateTime(); inserted.DueDate = TestSession.Random.RandomDateTime(); inserted.ShipDate = TestSession.Random.RandomDateTime(); inserted.Status = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.OnlineOrderFlag = Convert.ToBoolean(TestSession.Random.Next(1)); inserted.SalesOrderNumber = TestSession.Random.RandomString(25); inserted.PurchaseOrderNumber = TestSession.Random.RandomString(25); inserted.AccountNumber = TestSession.Random.RandomString(15); inserted.CustomerID = TestSession.Random.Next(); inserted.SalesPersonID = TestSession.Random.Next(); inserted.TerritoryID = TestSession.Random.Next(); inserted.BillToAddressID = TestSession.Random.Next(); inserted.ShipToAddressID = TestSession.Random.Next(); inserted.ShipMethodID = TestSession.Random.Next(); inserted.CreditCardID = TestSession.Random.Next(); inserted.CreditCardApprovalCode = TestSession.Random.RandomString(15); inserted.CurrencyRateID = TestSession.Random.Next(); inserted.SubTotal = TestSession.Random.RandomDecimal(); inserted.TaxAmt = TestSession.Random.RandomDecimal(); inserted.Freight = TestSession.Random.RandomDecimal(); inserted.TotalDue = TestSession.Random.RandomDecimal(); inserted.Comment = TestSession.Random.RandomString(128); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new SalesOrderHeaderModelPrimaryKey() { SalesOrderID = inserted.SalesOrderID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.SalesOrderID, selectedAfterUpdate.SalesOrderID); Assert.AreEqual(inserted.RevisionNumber, selectedAfterUpdate.RevisionNumber); Assert.AreEqual(inserted.OrderDate, selectedAfterUpdate.OrderDate); Assert.AreEqual(inserted.DueDate, selectedAfterUpdate.DueDate); Assert.AreEqual(inserted.ShipDate, selectedAfterUpdate.ShipDate); Assert.AreEqual(inserted.Status, selectedAfterUpdate.Status); Assert.AreEqual(inserted.OnlineOrderFlag, selectedAfterUpdate.OnlineOrderFlag); Assert.AreEqual(inserted.SalesOrderNumber, selectedAfterUpdate.SalesOrderNumber); Assert.AreEqual(inserted.PurchaseOrderNumber, selectedAfterUpdate.PurchaseOrderNumber); Assert.AreEqual(inserted.AccountNumber, selectedAfterUpdate.AccountNumber); Assert.AreEqual(inserted.CustomerID, selectedAfterUpdate.CustomerID); Assert.AreEqual(inserted.SalesPersonID, selectedAfterUpdate.SalesPersonID); Assert.AreEqual(inserted.TerritoryID, selectedAfterUpdate.TerritoryID); Assert.AreEqual(inserted.BillToAddressID, selectedAfterUpdate.BillToAddressID); Assert.AreEqual(inserted.ShipToAddressID, selectedAfterUpdate.ShipToAddressID); Assert.AreEqual(inserted.ShipMethodID, selectedAfterUpdate.ShipMethodID); Assert.AreEqual(inserted.CreditCardID, selectedAfterUpdate.CreditCardID); Assert.AreEqual(inserted.CreditCardApprovalCode, selectedAfterUpdate.CreditCardApprovalCode); Assert.AreEqual(inserted.CurrencyRateID, selectedAfterUpdate.CurrencyRateID); Assert.AreEqual(inserted.SubTotal, selectedAfterUpdate.SubTotal); Assert.AreEqual(inserted.TaxAmt, selectedAfterUpdate.TaxAmt); Assert.AreEqual(inserted.Freight, selectedAfterUpdate.Freight); Assert.AreEqual(inserted.TotalDue, selectedAfterUpdate.TotalDue); Assert.AreEqual(inserted.Comment, selectedAfterUpdate.Comment); Assert.AreEqual(inserted.rowguid, selectedAfterUpdate.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new SalesOrderHeaderModelPrimaryKey() { SalesOrderID = inserted.SalesOrderID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test DocumentModel inserted = new DocumentModel(); inserted.DocumentNode = Microsoft.SqlServer.Types.SqlHierarchyId.Null; //TODO define how to generate random hierarchy id in test session; inserted.DocumentLevel = TestSession.Random.RandomShort(); inserted.Title = TestSession.Random.RandomString(50); inserted.Owner = TestSession.Random.Next(); inserted.FolderFlag = Convert.ToBoolean(TestSession.Random.Next(1)); inserted.FileName = TestSession.Random.RandomString(400); inserted.FileExtension = TestSession.Random.RandomString(8); inserted.Revision = TestSession.Random.RandomString(5); inserted.ChangeNumber = TestSession.Random.Next(); inserted.Status = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.DocumentSummary = TestSession.Random.RandomString(-1); inserted.Document = TestSession.Random.RandomBytes(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new DocumentModelPrimaryKey() { DocumentNode = inserted.DocumentNode, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.DocumentNode, selectedAfterInsert.DocumentNode); Assert.AreEqual(inserted.DocumentLevel, selectedAfterInsert.DocumentLevel); Assert.AreEqual(inserted.Title, selectedAfterInsert.Title); Assert.AreEqual(inserted.Owner, selectedAfterInsert.Owner); Assert.AreEqual(inserted.FolderFlag, selectedAfterInsert.FolderFlag); Assert.AreEqual(inserted.FileName, selectedAfterInsert.FileName); Assert.AreEqual(inserted.FileExtension, selectedAfterInsert.FileExtension); Assert.AreEqual(inserted.Revision, selectedAfterInsert.Revision); Assert.AreEqual(inserted.ChangeNumber, selectedAfterInsert.ChangeNumber); Assert.AreEqual(inserted.Status, selectedAfterInsert.Status); Assert.AreEqual(inserted.DocumentSummary, selectedAfterInsert.DocumentSummary); Assert.AreEqual(inserted.Document, selectedAfterInsert.Document); Assert.AreEqual(inserted.rowguid, selectedAfterInsert.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.DocumentLevel = TestSession.Random.RandomShort(); inserted.Title = TestSession.Random.RandomString(50); inserted.Owner = TestSession.Random.Next(); inserted.FolderFlag = Convert.ToBoolean(TestSession.Random.Next(1)); inserted.FileName = TestSession.Random.RandomString(400); inserted.FileExtension = TestSession.Random.RandomString(8); inserted.Revision = TestSession.Random.RandomString(5); inserted.ChangeNumber = TestSession.Random.Next(); inserted.Status = Convert.ToByte(TestSession.Random.RandomString(3)); inserted.DocumentSummary = TestSession.Random.RandomString(-1); inserted.Document = TestSession.Random.RandomBytes(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new DocumentModelPrimaryKey() { DocumentNode = inserted.DocumentNode, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.DocumentNode, selectedAfterUpdate.DocumentNode); Assert.AreEqual(inserted.DocumentLevel, selectedAfterUpdate.DocumentLevel); Assert.AreEqual(inserted.Title, selectedAfterUpdate.Title); Assert.AreEqual(inserted.Owner, selectedAfterUpdate.Owner); Assert.AreEqual(inserted.FolderFlag, selectedAfterUpdate.FolderFlag); Assert.AreEqual(inserted.FileName, selectedAfterUpdate.FileName); Assert.AreEqual(inserted.FileExtension, selectedAfterUpdate.FileExtension); Assert.AreEqual(inserted.Revision, selectedAfterUpdate.Revision); Assert.AreEqual(inserted.ChangeNumber, selectedAfterUpdate.ChangeNumber); Assert.AreEqual(inserted.Status, selectedAfterUpdate.Status); Assert.AreEqual(inserted.DocumentSummary, selectedAfterUpdate.DocumentSummary); Assert.AreEqual(inserted.Document, selectedAfterUpdate.Document); Assert.AreEqual(inserted.rowguid, selectedAfterUpdate.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new DocumentModelPrimaryKey() { DocumentNode = inserted.DocumentNode, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test SalesOrderDetailModel inserted = new SalesOrderDetailModel(); inserted.SalesOrderID = TestSession.Random.Next(); inserted.CarrierTrackingNumber = TestSession.Random.RandomString(25); inserted.OrderQty = TestSession.Random.RandomShort(); inserted.ProductID = TestSession.Random.Next(); inserted.SpecialOfferID = TestSession.Random.Next(); inserted.UnitPrice = TestSession.Random.RandomDecimal(); inserted.UnitPriceDiscount = TestSession.Random.RandomDecimal(); inserted.LineTotal = TestSession.Random.RandomDecimal(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new SalesOrderDetailModelPrimaryKey() { SalesOrderID = inserted.SalesOrderID, SalesOrderDetailID = inserted.SalesOrderDetailID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.SalesOrderID, selectedAfterInsert.SalesOrderID); Assert.AreEqual(inserted.SalesOrderDetailID, selectedAfterInsert.SalesOrderDetailID); Assert.AreEqual(inserted.CarrierTrackingNumber, selectedAfterInsert.CarrierTrackingNumber); Assert.AreEqual(inserted.OrderQty, selectedAfterInsert.OrderQty); Assert.AreEqual(inserted.ProductID, selectedAfterInsert.ProductID); Assert.AreEqual(inserted.SpecialOfferID, selectedAfterInsert.SpecialOfferID); Assert.AreEqual(inserted.UnitPrice, selectedAfterInsert.UnitPrice); Assert.AreEqual(inserted.UnitPriceDiscount, selectedAfterInsert.UnitPriceDiscount); Assert.AreEqual(inserted.LineTotal, selectedAfterInsert.LineTotal); Assert.AreEqual(inserted.rowguid, selectedAfterInsert.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.CarrierTrackingNumber = TestSession.Random.RandomString(25); inserted.OrderQty = TestSession.Random.RandomShort(); inserted.ProductID = TestSession.Random.Next(); inserted.SpecialOfferID = TestSession.Random.Next(); inserted.UnitPrice = TestSession.Random.RandomDecimal(); inserted.UnitPriceDiscount = TestSession.Random.RandomDecimal(); inserted.LineTotal = TestSession.Random.RandomDecimal(); inserted.rowguid = Guid.NewGuid(); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new SalesOrderDetailModelPrimaryKey() { SalesOrderID = inserted.SalesOrderID, SalesOrderDetailID = inserted.SalesOrderDetailID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.SalesOrderID, selectedAfterUpdate.SalesOrderID); Assert.AreEqual(inserted.SalesOrderDetailID, selectedAfterUpdate.SalesOrderDetailID); Assert.AreEqual(inserted.CarrierTrackingNumber, selectedAfterUpdate.CarrierTrackingNumber); Assert.AreEqual(inserted.OrderQty, selectedAfterUpdate.OrderQty); Assert.AreEqual(inserted.ProductID, selectedAfterUpdate.ProductID); Assert.AreEqual(inserted.SpecialOfferID, selectedAfterUpdate.SpecialOfferID); Assert.AreEqual(inserted.UnitPrice, selectedAfterUpdate.UnitPrice); Assert.AreEqual(inserted.UnitPriceDiscount, selectedAfterUpdate.UnitPriceDiscount); Assert.AreEqual(inserted.LineTotal, selectedAfterUpdate.LineTotal); Assert.AreEqual(inserted.rowguid, selectedAfterUpdate.rowguid); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new SalesOrderDetailModelPrimaryKey() { SalesOrderID = inserted.SalesOrderID, SalesOrderDetailID = inserted.SalesOrderDetailID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test DatabaseLogModel inserted = new DatabaseLogModel(); inserted.PostTime = TestSession.Random.RandomDateTime(); inserted.DatabaseUser = TestSession.Random.RandomString(128); inserted.Event = TestSession.Random.RandomString(128); inserted.Schema = TestSession.Random.RandomString(128); inserted.Object = TestSession.Random.RandomString(128); inserted.TSQL = TestSession.Random.RandomString(-1); var xml = new XmlDocument(); xml.LoadXml(@"<EVENT_INSTANCE><EventType>CREATE_TABLE</EventType><PostTime>2017-10-27T14:33:01.373</PostTime><SPID>56</SPID><ServerName>BARBKESS24\MSSQL2017RTM</ServerName><LoginName>REDMOND\barbkess</LoginName><UserName>dbo</UserName><DatabaseName>AdventureWorks2017</DatabaseName><SchemaName>dbo</SchemaName><ObjectName>ErrorLog</ObjectName><ObjectType>TABLE</ObjectType><TSQLCommand><SetOptions ANSI_NULLS=""ON"" ANSI_NULL_DEFAULT=""ON"" ANSI_PADDING=""ON"" QUOTED_IDENTIFIER=""ON"" ENCRYPTED=""FALSE"" /><CommandText>CREATE TABLE [dbo].[ErrorLog]( [ErrorLogID][int] IDENTITY(1, 1) NOT NULL, [ErrorTime][datetime] NOT NULL CONSTRAINT[DF_ErrorLog_ErrorTime] DEFAULT(GETDATE()), [UserName][sysname] NOT NULL, [ErrorNumber][int] NOT NULL, [ErrorSeverity][int] NULL, [ErrorState][int] NULL, [ErrorProcedure][nvarchar](126) NULL, [ErrorLine][int] NULL, [ErrorMessage][nvarchar](4000) NOT NULL ) ON[PRIMARY] </CommandText></TSQLCommand></EVENT_INSTANCE>"); inserted.XmlEvent = xml; _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new DatabaseLogModelPrimaryKey() { DatabaseLogID = inserted.DatabaseLogID, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.DatabaseLogID, selectedAfterInsert.DatabaseLogID); Assert.AreEqual(inserted.PostTime, selectedAfterInsert.PostTime); Assert.AreEqual(inserted.DatabaseUser, selectedAfterInsert.DatabaseUser); Assert.AreEqual(inserted.Event, selectedAfterInsert.Event); Assert.AreEqual(inserted.Schema, selectedAfterInsert.Schema); Assert.AreEqual(inserted.Object, selectedAfterInsert.Object); Assert.AreEqual(inserted.TSQL, selectedAfterInsert.TSQL); Assert.AreEqual(inserted.XmlEvent.ToString(), selectedAfterInsert.XmlEvent.ToString()); #endregion #region update and select by id test inserted.PostTime = TestSession.Random.RandomDateTime(); inserted.DatabaseUser = TestSession.Random.RandomString(128); inserted.Event = TestSession.Random.RandomString(128); inserted.Schema = TestSession.Random.RandomString(128); inserted.Object = TestSession.Random.RandomString(128); inserted.TSQL = TestSession.Random.RandomString(-1); var updatedXml = new XmlDocument(); updatedXml.LoadXml(@"<EVENT_INSTANCE><EventType>DROP_TABLE</EventType><PostTime>2017-10-27T14:33:01.373</PostTime><SPID>56</SPID><ServerName>BARBKESS24\MSSQL2017RTM</ServerName><LoginName>REDMOND\barbkess</LoginName><UserName>dbo</UserName><DatabaseName>AdventureWorks2017</DatabaseName><SchemaName>dbo</SchemaName><ObjectName>ErrorLog</ObjectName><ObjectType>TABLE</ObjectType><TSQLCommand><SetOptions ANSI_NULLS=""ON"" ANSI_NULL_DEFAULT=""ON"" ANSI_PADDING=""ON"" QUOTED_IDENTIFIER=""ON"" ENCRYPTED=""FALSE"" /><CommandText>CREATE TABLE [dbo].[ErrorLog]( [ErrorLogID][int] IDENTITY(1, 1) NOT NULL, [ErrorTime][datetime] NOT NULL CONSTRAINT[DF_ErrorLog_ErrorTime] DEFAULT(GETDATE()), [UserName][sysname] NOT NULL, [ErrorNumber][int] NOT NULL, [ErrorSeverity][int] NULL, [ErrorState][int] NULL, [ErrorProcedure][nvarchar](126) NULL, [ErrorLine][int] NULL, [ErrorMessage][nvarchar](4000) NOT NULL ) ON[PRIMARY] </CommandText></TSQLCommand></EVENT_INSTANCE>"); inserted.XmlEvent = updatedXml; _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new DatabaseLogModelPrimaryKey() { DatabaseLogID = inserted.DatabaseLogID, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.DatabaseLogID, selectedAfterUpdate.DatabaseLogID); Assert.AreEqual(inserted.PostTime, selectedAfterUpdate.PostTime); Assert.AreEqual(inserted.DatabaseUser, selectedAfterUpdate.DatabaseUser); Assert.AreEqual(inserted.Event, selectedAfterUpdate.Event); Assert.AreEqual(inserted.Schema, selectedAfterUpdate.Schema); Assert.AreEqual(inserted.Object, selectedAfterUpdate.Object); Assert.AreEqual(inserted.TSQL, selectedAfterUpdate.TSQL); Assert.AreEqual(inserted.XmlEvent.ToString(), selectedAfterUpdate.XmlEvent.ToString()); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new DatabaseLogModelPrimaryKey() { DatabaseLogID = inserted.DatabaseLogID, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }
public void IntegrationTest() { var connection = TestSession.GetConnection(); connection.Open(); #region good insertion and select by id test EmployeePayHistoryModel inserted = new EmployeePayHistoryModel(); inserted.BusinessEntityID = TestSession.Random.Next(); inserted.RateChangeDate = TestSession.Random.RandomDateTime(); inserted.Rate = TestSession.Random.RandomDecimal(19, 4); inserted.PayFrequency = Convert.ToByte(TestSession.Random.Next(255)); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Insert(connection, new[] { inserted }); var selectedAfterInsertion = _tested.GetByPrimaryKey(connection, new EmployeePayHistoryModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, RateChangeDate = inserted.RateChangeDate, }); CollectionAssert.IsNotEmpty(selectedAfterInsertion); var selectedAfterInsert = selectedAfterInsertion.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterInsert.BusinessEntityID); Assert.AreEqual(inserted.RateChangeDate, selectedAfterInsert.RateChangeDate); Assert.AreEqual(inserted.Rate, selectedAfterInsert.Rate); Assert.AreEqual(inserted.PayFrequency, selectedAfterInsert.PayFrequency); Assert.AreEqual(inserted.ModifiedDate, selectedAfterInsert.ModifiedDate); #endregion #region update and select by id test inserted.Rate = TestSession.Random.RandomDecimal(19, 4); inserted.PayFrequency = Convert.ToByte(TestSession.Random.Next(255)); inserted.ModifiedDate = TestSession.Random.RandomDateTime(); _tested.Update(connection, new[] { inserted }); var selectedAfterUpdateAddresss = _tested.GetByPrimaryKey(connection, new EmployeePayHistoryModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, RateChangeDate = inserted.RateChangeDate, }); CollectionAssert.IsNotEmpty(selectedAfterUpdateAddresss); var selectedAfterUpdate = selectedAfterUpdateAddresss.Single(); Assert.AreEqual(inserted.BusinessEntityID, selectedAfterUpdate.BusinessEntityID); Assert.AreEqual(inserted.RateChangeDate, selectedAfterUpdate.RateChangeDate); Assert.AreEqual(inserted.Rate, selectedAfterUpdate.Rate); Assert.AreEqual(inserted.PayFrequency, selectedAfterUpdate.PayFrequency); Assert.AreEqual(inserted.ModifiedDate, selectedAfterUpdate.ModifiedDate); #endregion #region delete test _tested.Delete(connection, new[] { inserted }); var selectedAfterDeleteAddresss = _tested.GetByPrimaryKey(connection, new EmployeePayHistoryModelPrimaryKey() { BusinessEntityID = inserted.BusinessEntityID, RateChangeDate = inserted.RateChangeDate, }); CollectionAssert.IsEmpty(selectedAfterDeleteAddresss); #endregion connection.Close(); }