public void Verify_Update() { const string newCompanyName = "New Company Name"; using(var transaction = new TransactionScope()) { // PrepareDb InsertCustomer(); using (var northwindContext = new NorthwindEntities()) { var customer = northwindContext .Customers .Single(c => c.CustomerID == customerId); customer.CompanyName = newCompanyName; customer.Location = SpatialServices.Instance.GeographyFromText("POINT (-122.191667 47.685833)"); northwindContext.SaveChanges(); } // Verify the customer was updated Assert.Equal( 1, ExecuteScalar( string.Format( "SELECT COUNT(*) " + "FROM Customers " + "WHERE CustomerID = '{0}' AND CompanyName = '{1}' AND Location.STAsText() = 'POINT (-122.191667 47.685833)'", customerId, newCompanyName))); } }
public void Verify_Delete() { using (var transaction = new TransactionScope()) { // PrepareDb InsertCustomer(); using (var northwindContext = new NorthwindEntities()) { var customer = northwindContext .Customers .Single(c => c.CustomerID == customerId); northwindContext.Customers.DeleteObject(customer); northwindContext.SaveChanges(); } // Verify the customer was updated Assert.Equal( 0, ExecuteScalar( string.Format( "SELECT COUNT(*) FROM Customers WHERE CustomerID = '{0}' AND CompanyName = '{1}'", customerId, companyName))); } }
private static void InsertCustomer() { using (var northwindContext = new NorthwindEntities()) { northwindContext.Customers.AddObject( new Customer() { CustomerID = customerId, CompanyName = companyName, Location = SpatialServices.Instance.GeographyFromText("POINT (17.038333 51.107778)") }); northwindContext.SaveChanges(); } }
public void Verify_Update_DbGeography() { using (var transaction = new TransactionScope()) { int orderID; using (var northwindContext = new NorthwindEntities()) { var order = northwindContext .Orders .OrderBy(o => o.OrderID) .First(); orderID = order.OrderID; order.ContainerSize = SpatialServices.Instance.GeometryFromText("LINESTRING (100 100, 20 180, 180 180)"); northwindContext.SaveChanges(); } // Verify the customer was updated Assert.Equal( 1, ExecuteScalar( string.Format( "SELECT COUNT(*) FROM Orders WHERE OrderID = '{0}' AND ContainerSize.STAsText() = 'LINESTRING (100 100, 20 180, 180 180)'", orderID))); } }