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();
}
