我们在使用SqlDataSource进行并发策略的时候比较容易实现,通过设置ConflictDetection值为CompareAllValues,OldValuesParameterFormatString="original_{0}"就可以在SelectCommand,UpdateCommand,DeleteCommand里面进行设置即可。 设计Account(AccountID,AccountUse ,Flag)数据库表 这里以UpdateCommand为例:
update set AccountUse=@AccountUse,Flag=@Flag where AccountID=@original_AccountID and AccountUse=@Original_AccountUse and Flag=@Original_Flag;这样可以很容易地进行SqlDataSource的并发处理。
然而ObjectDataSource为我们提供了并发控制机制:
ObjectDataSource 控件有一个属性ConflictDetection,可以设置应用程序中并发处理。
ConflictDetection 也有两个可选值:
默认设置为OverwriteChanges 这是最小化的并发冲突设置,在更新和删除的时候不会提供原始数据信息,无法进行并发控制.
CompareAllValues 这将给予你最大的灵活性,它将在更新和删除的时候提供原始的数据信息,所以可以进行并发控制。
请看如下示例:
用于ObjectDataSource的实体对象类Account类:
![ContractedBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![ExpandedBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
1
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![ExpandedBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
8
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
18
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
28
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
29
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
30
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
对于Update方法:
ObjectDataSource在ConflictDetection= Overwrite Changes的时候要求只把现在更新的字段,以及原来的主键字段(这个名字是根据ObjectDataSource的OldValuesParameterFormatString设置的格式Original_{0}),例如Original_AccountID传进来,以便索引到更新行。
ObjectDataSource在ConflictDetection=CompareALLValues的时候要求把现在更新的字段以及原来的所有字段全部传递进来。
ObjectDataSource在DataObjectType设置的情况下,ConflictDetection= Overwrite Changes的时候,仅仅需要一个Account对象变量作为参数,代表更新的值。
ObjectDataSource在DataObjectType设置的情况下,ConflictDetection=CompareALLValues的时候,需要两个Account对象作为参数,前一个变量Account acc,后一个变量Account Origina_acc,后一个变量记录了原始值。
对于Delete方法:
ObjectDataSource在ConflictDetection= Overwrite Changes的时候,只会把Original_AccountID的字段传递过来。
ObjectDataSource在ConflictDetection=CompareALLValues的时候要求把Original_AccountID ,Original_AccountUse和Original_Flag全部传递过去。
ObjectDataSource在DataObjectType设置的情况下,仅仅需要传递一个Account类型的变量就可以了。
如下表所示:
命令 | DataObjectType | ConflictDetection | OldValuesParameterFormatString | ObjectDataSource的实体对象类Account类提供的方法 |
Update | 没有设置 | Overwrite Changes | Original_{0} | update(int AccountID,string AccountUse,bool Flag,int Original_AccountID) |
| 没有设置 | CompareAllValues
| Original_{0} | Update(int AccountID,string AccountUse ,bool Flag,int Original_AccountID, string Original_AccountUse,bool Original_Flag) |
| 设置 | Overwrite Changes | Original_{0} | Update(Account acc) |
| 设置 | CompareAllValues
| Original_{0} | Update(Account acc,Account Orignal_acc) |
Delete | 没有设置 | Overwrite Changes | Original_{0} | Delete(int Original_AccountID) |
| 没有设置 | CompareAllValues
| Original_{0} | Delete(int Original_AccountID,string Original_AccountUse,bool Original_Flag) |
| 设置 | Overwrite Changes | Original_{0} | Delete(Account acc) |
| 设置 | CompareAllValues
| Original_{0} | Delete(Account acc) |