All,

I am using the Profiler to see what the database is doing while the JUmp Start application is being run. The result is below:

SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT * From Orders WHERE CustomerID = 'SPLIR' SET NO_BROWSETABLE OFF;

SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT * FROM [Orders] WHERE OrderID = 455 SET NO_BROWSETABLE OFF;

SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT * FROM [Order Details] WHERE OrderID = 455 SET NO_BROWSETABLE OFF;

SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT * FROM Shippers SET NO_BROWSETABLE OFF;

SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT * FROM Employees SET NO_BROWSETABLE OFF;

SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;SELECT * FROM [Orders] WHERE OrderID = 455 SET FMTONLY OFF; SET NO_BROWSETABLE OFF;

exec sp_executesql N'UPDATE Orders SET ShipRegion = @p1 WHERE ( (OrderID = @p2) AND ((@p3 = 1 AND CustomerID IS NULL) OR (CustomerID = @p4)) AND ((@p5 = 1 AND EmployeeID IS NULL) OR (EmployeeID = @p6)) AND ((@p7 = 1 AND OrderDate IS NULL) OR (OrderDate = @p8)) AND ((@p9 = 1 AND RequiredDate IS NULL) OR (RequiredDate = @p10)) AND ((@p11 = 1 AND ShippedDate IS NULL) OR (ShippedDate = @p12)) AND ((@p13 = 1 AND ShipVia IS NULL) OR (ShipVia = @p14)) AND ((@p15 = 1 AND Freight IS NULL) OR (Freight = @p16)) AND ((@p17 = 1 AND ShipName IS NULL) OR (ShipName = @p18)) AND ((@p19 = 1 AND ShipAddress IS NULL) OR (ShipAddress = @p20)) AND ((@p21 = 1 AND ShipCity IS NULL) OR (ShipCity = @p22)) AND ((@p23 = 1 AND ShipRegion IS NULL) OR (ShipRegion = @p24)) AND ((@p25 = 1 AND ShipPostalCode IS NULL) OR (ShipPostalCode = @p26)) AND ((@p27 = 1 AND ShipCountry IS NULL) OR (ShipCountry = @p28)) )', N'@p1 nvarchar(4000),@p2 int,@p3 int,@p4 nchar(4000),@p5 int,@p6 int,@p7 int,@p8 datetime,@p9 int,@p10 datetime,@p11 int,@p12 datetime,@p13 int,@p14 int,@p15 int,@p16 money,@p17 int,@p18 nvarchar(4000),@p19 int,@p20 nvarchar(4000),@p21 int,@p22 nvarchar(4000),@p23 int,@p24 nvarchar(4000),@p25 int,@p26 nvarchar(4000),@p27 int,@p28 nvarchar(4000)', @p1 = N'Eastern', @p2 = 455, @p3 = 0, @p4 = N'SPLIR', @p5 = 0, @p6 = 1, @p7 = 0, @p8 = 'Dec 8 1948 12:00AM', @p9 = 0, @p10 = 'Dec 8 1948 12:00AM', @p11 = 0, @p12 = 'May 1 1992 12:00AM', @p13 = 0, @p14 = 1, @p15 = 0, @p16 = $0.0000, @p17 = 0, @p18 = N'Christina Berglund', @p19 = 0, @p20 = N'Berguvsvägen 8', @p21 = 0, @p22 = N'Luleå', @p23 = 0, @p24 = N'', @p25 = 0, @p26 = N'S-958 22', @p27 = 0, @p28 = N'Sweden'

SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT * From Orders WHERE CustomerID = 'SPLIR' SET NO_BROWSETABLE OFF;

The above comes from the following steps:

1. Run app
2. Enter customer id
3. Click on Order in DataGrid
4. Change some piece of information in the OrderEdit page
5. Click Save button.

I can see the Select statement to retrieve Orders for the Customer.
After the Order is selected, I see the Selects to retrieve the Order and Order Detail as well as populatiung the Shippers and Employees.

My question is why MM.Net executes the SELECT statement before updating the database?
My question is the SELECT statement above the UPDATE statement. I have set a breakpoint in the Orders business object where this select statement resides, but it is not being hit.

TIA

Rex