public async Task Insert_With_Composite_Key_Two_Assigned_And_One_Sequential(Type dataContextType)
{
// Arrange
using IDataContext dataContext = DataContextTestHelper.SetupDataContext(dataContextType);
// Act
AssignedPairAndSequential oneOneOne = await dataContext.Create(new AssignedPairAndSequential()
{
FirstAssignedId = 1, SecondAssignedId = 1, Heading = "One"
});
AssignedPairAndSequential oneOneTwo = await dataContext.Create(new AssignedPairAndSequential()
{
FirstAssignedId = 1, SecondAssignedId = 1, Heading = "Two"
});
AssignedPairAndSequential oneTwoOne = await dataContext.Create(new AssignedPairAndSequential()
{
FirstAssignedId = 1, SecondAssignedId = 2, Heading = "One"
});
// Assert
Assert.AreEqual(1, oneOneOne.SequentialId);
Assert.AreEqual(2, oneOneTwo.SequentialId);
Assert.AreEqual(1, oneTwoOne.SequentialId);
}
public async Task Insert_With_Composite_Key_Two_Assigned_And_One_Sequential()
{
using (IDbConnection connection = LocalDbTestHelper.OpenTestConnection(TestContext.CurrentContext.Test.FullName))
{
// Act
AssignedPairAndSequential oneOneOne = await connection.Create(new AssignedPairAndSequential()
{
FirstAssignedId = 1, SecondAssignedId = 1, Heading = "One"
});
AssignedPairAndSequential oneOneTwo = await connection.Create(new AssignedPairAndSequential()
{
FirstAssignedId = 1, SecondAssignedId = 1, Heading = "Two"
});
AssignedPairAndSequential oneTwoOne = await connection.Create(new AssignedPairAndSequential()
{
FirstAssignedId = 1, SecondAssignedId = 2, Heading = "One"
});
// Assert
Assert.AreEqual(1, oneOneOne.SequentialId);
Assert.AreEqual(2, oneOneTwo.SequentialId);
Assert.AreEqual(1, oneTwoOne.SequentialId);
}
}
