private void _RunInsert(string name = null) { using (var context = new DataMockDataContext()) { context.Parents.InsertOnSubmit(new Parent { Name = name ?? string.Empty }); context.SubmitChanges(); } }
public void FinalizeExistingOrder() { var dataMock = new DataMock<DataMockDataContext> { Log = Console.Out }; const int NEXT_SEQUENCE = 3; dataMock .Setup( context => context.GetNextOrderSequence()) .Returns(NEXT_SEQUENCE); using (var context = new DataMockDataContext(Settings.Default.DataMockConnectionString)) { //Disable all check constraints on the Order table to simplify inserting test data context.DisableAllCheckConstraints<DataMockDataContext, Order>(); //Create an Order object, and set its properties to sensible default values var orderToUpdate = new Order(); DataMockHelper.DefaultValues(orderToUpdate); //add the order to the database context.Orders.InsertOnSubmit(orderToUpdate); context.SubmitChanges(); //create the mocked implementation of GetNextOrderSequence() dataMock.Execute(Settings.Default.DataMockConnectionString); //execute the FinalizeOrder procedure and verify its results FinalizeOrderResult finalizeOrderResult = context.FinalizeOrder(orderToUpdate.OrderId).SingleOrDefault(); Assert.IsNotNull(finalizeOrderResult); Assert.AreEqual(NEXT_SEQUENCE, finalizeOrderResult.Sequence); //verify that the procedure updated the order table context.Refresh(RefreshMode.OverwriteCurrentValues, orderToUpdate); Assert.AreEqual(NEXT_SEQUENCE, orderToUpdate.OrderSequenceNumber); } }