Update columns using entity framework

Question

I want to update some of my columns value using entity framework My code is as follows

public static void UpdateData(string contentMenu, int eid) //Update data in database  
        {
            using (var context = new CmsContext())
            {
                try
                {
                    var objDataContent = new Content
                    {
                        MenuContent = contentMenu,
                        ModifiedDateTime = DateTime.Now
                    };
                   //Code to update only MenuContent and ModifiedDateTime whose id=eid
                    GetRecords();
                }
                catch (Exception ex)
                {
                    //
                }
            }
        }

There are lot of answers in S/O but none of them helped me. I followed https://stackoverflow.com/a/5567616/4701699

How can I update these two columns on the basis of id parameters like MSSQL query

update [CMS Menu].[dbo].[Contents] set MenuContent = 'testing' ,
ModifiedDateTime ='2016-01-02 16:02:15.803' where ContentId=2

yash · Accepted Answer · 2016-01-02 10:38:12Z

2

You Can Update Your Column Entries by Using Linq:-

Here Are Example Code:-

var data = db.Content.FirstOrDefault(x=>x.ContentId==eID);
data.ModiFiedDateTime = DateTime.Now;
data.MenuContent = contentMenu;
db.SaveChanges();

answered Jan 2, 2016 at 10:38

yash

8223 gold badges12 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update columns using entity framework

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related