Update schema, default value for a new column

2 posts, 0 answers
  1. Richard
    Richard avatar
    9 posts
    Member since:
    Sep 2011

    Posted 23 Sep 2014 Link to this post


    I use telerik Version 2011.1.411.2 (Runtime 2.0.50727).

    I added a new colum in my database schema (for information double d_Value),
    and I want that the data that is already memorized in database take value "1.0" not "0.0".

    Can you explain how can I do ?

    In advance, Thanks,
  2. Doroteya
    Doroteya avatar
    498 posts

    Posted 26 Sep 2014 Link to this post

    Hi Richard,

    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:
    USE [MyDatabase]
    UPDATE [MySchema].[MyTable] 
    SET d_Value = 1.0
    FROM [dbo].[Order Details]
    WHERE 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:
    using (EntitiesModel dbContext = new EntitiesModel())
        foreach (var item in dbContext.OrderDetails.ToList())
            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.
Back to Top