Iron Speed Designer is a software development tool for building database, reporting, and forms applications. NET without hand-coding. quickly create polically stunning, feature-complete Web applications with database access and security. iron Speed Designer accelerates development by eliminating routine infrastructure programming, giving you ready-to-deploy n-tier Web applications in minutes.
Ironspeed free trial for half a month
Http://www.ironspeed.com/products/DownloadNow.aspx
I don't know much about ASP. NET, and I haven't studied it carefully. However, some of its SQL & stored procedure generation statements are quite useful.
I looked at the stored procedure of the modified record generated by it. In the past, my practice was to UPDATE the table SET field = ??? Where primary key = ???
Its stored procedure is as follows:
1) First, check whether the record is deleted by another user. If the record is deleted, RAISERROR occurs.
2) If it is forcibly modified (specified by @ p_force_update char (1), execute the UPDATE statement and judge the value of @ ROWCOUNT.
A) RAISERROR if = 0 ('records cannot be modified)
B) RAISERROR if the value is greater than 1 ('record already exists)
3) if it is not forcibly modified, use BINARY_CHECKSUM to compare whether the current check value of the row is the same as that of the query.
A) The check value is the same. Press 2) to modify the value.
B) if the verification value is different, it is not modified and RAISERROR ('this row record has been modified by another user)