[Solved] Update Using OpenAccessContext

[Muhammad]

I would like to update my record in the database using OpenAccessContext. I would like to update the Group Table in my database but I don't know how to update it Using DBContext. I can't find the dbContext.SumbitChanges() method. I can just see SaveChanges() method. Any Help would be really appreciated.


Dim txtGroupName As TextBox = e.Item.FindControl("txtGroupName")
            Dim groupName As String = txtGroupName.Text

            Dim data As GridEditFormItem = e.Item
            Dim nID As Integer = Convert.ToInt64(data.ParentItem("ID").Text)

            ffGroup.ID = nID
            ffGroup.GroupName = groupName
            ffGroup.CreatedBy = DotNetNuke.Entities.Users.UserController.GetCurrentUserInfo.UserID
            ffGroup.CreatedOn = DateTime.Now
            dbContext.Add(ffGroup)
            dbContext.SaveChanges()

[PetarP]

Hello Muhammad,

 The SaveChanges method is used for committing your changes to the database. You should use it without a problem. 
The code you have provided is used to add a fresh new entry to one of your tables ( representing the type of your ffGroup variable). If you would like to update an instance you will have to first retrieve it from the database and then alter its properties and call SaveChanges. I believe that our getting started guide available in our online documentation will prove to be a great start for you.

All the best,
Petar
the Telerik team

[Muhammad]

Can you please tell me that how can I retrieve that record from database using OpenAccessContext ... and update that record.

[Zoran]

Hi Muhammad,

 You can obtain the existing record using Linq query or by using the GetObjectByKey method. I will show you the later approach in the following code snippet:

Dim txtGroupName As TextBox = e.Item.FindControl("txtGroupName")
            Dim groupName As String = txtGroupName.Text

            Dim data As GridEditFormItem = e.Item
            Dim nID As Integer = Convert.ToInt64(data.ParentItem("ID").Text)

            ffGroup = dbContext.GetObjectByKey(New ObjectKey(ffGroup.GetType().Name, nID))
            ffGroup.GroupName = groupName
            ffGroup.CreatedBy = DotNetNuke.Entities.Users.UserController.GetCurrentUserInfo.UserID
            ffGroup.CreatedOn = DateTime.Now

            dbContext.SaveChanges()

So what you should do is call ffGroup = dbContext.GetObjectByKey(NewObjectKey(ffGroup.GetType().Name, nID))

in order to obtain the ffGroup object with the desired ID. Then you just set the properties as you would like to and call SaveChanges()(without calling dbContext.Add() as you previously did).

Regards,
Zoran
the Telerik team

[Muhammad]

Thank you so much ... Is it possible that I can retrieve the ID of inserted record ... ? ID is the primary key value in my table.

[Zoran]

Hi Muhammad,

 Yes, accessing the ID property of your object after the SaveChanges() call will give you its exact ID.

Kind regards,
Zoran
the Telerik team