Silverlight生成OrderNo？
我在 Silverlight 中有一个订单输入系统。我有两个表 - Orders 和 OrderItems。 Orders 表中的 OrderNo 字段是自动递增的，但 OrderItems 表中的 OrderNo 字段不是自动递增的。
我需要的是每当客户提交订单时，orderitem 表的 orderno 也应该填写订单表 orderno。
我现在所做的是将新记录添加到订单表中并获取增量值并将其用于订单项记录。但是，我不想这样做，我需要在更新订单表时同时生成这些值。
I have an order entry system in Silverlight. I have two tables - Orders and OrderItems. The OrderNo field in Orders table is autoincrement, but the OrderNo field in the OrderItems table is not.
What I need is whenever customer submits an order, the orderitem table's orderno should also be filled with the orders table orderno.
What I do at the moment is add a new record to the orders table and get the incremented value and use it for the orderitem records. but, I dont want to do that way, I need these values to be generated simultaneously when the order table is updated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
将插入语句包装在事务中。您仍将使用已有的相同逻辑（分别更新表），但由于您将它们包装在同一个事务中，因此从数据库的角度来看，这将是一个原子操作。因此，如果出现问题并且您必须回滚，它将回滚两个插入，并且在整个事务提交之前没有人能够观察到对 Order 的插入。
编辑
如果您已经在使用实体框架，那么它就是您想要的事务范围。当您这样做时，我建议您认真研究一下 Silverlight 的 WCF RIA 服务。它确实是一个非常好的数据库服务框架。
第二次编辑
以下是有关 RIA 服务的视频：http://channel9.msdn.com/Events/ TechEd/北美/2011/MID311
Wrap your insert statements in a transaction. You will still use the same logic that you already have (updating the tables separetly), but since you are wrapping them in the same transaction, it will be an atomic operation from the database standpoint. So, if something goes wrong and you have to rollback, it will roll back both inserts, and no one will be able to observe the insert into Order until the whole transaction is committed.
EDIT
If you are already using Entity Framework, then it's a transaction scope that you want. And while you are at it, I would advise that you take a really serious look at WCF RIA Services for Silverlight. It's really a very good framework for database services.
2nd Edit
Here's a video on RIA Services: http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/MID311