You can achieve the necessary result in one of the following ways:
1. Update Telerik Data Access to the latest version, update your model with the latest changes in the database, and in your code use the bulk update feature as demonstrated here
. This way all the necessary changes will be performed on the server side, without any need for you to write SQL statements or load all the objects in memory before updating them.
2. Execute a query similar to the one demonstrated below in SQL Server Management Studio:
d_Value = 1.0
d_Value = 0.0
This way all the values will be updated with a single statement.
3. With your current version, update your model to the latest state of the database, and execute code similar to the demonstrated below in an application that consumes the model:
(EntitiesModel dbContext =
item.D_Value = 1;
Note that this is not recommended, because all the objects will be loaded in memory prior to the update.
I hope this helps. If you need further information, do not hesitate to get back to us.
OpenAccess ORM is now Telerik Data Access
. For more information on the new names, please, check out the Telerik Product Map