LINQ:Update record

DCMS.net.LINQClasses.DCMSDataClassesDataContext db = new DCMS.net.LINQClasses.DCMSDataClassesDataContext();
var content =
(from cont in db.Contents
where cont.contentID == Convert.ToInt32(editedItem.GetDataKeyValue("contentID").ToString())
select cont).First();

//Custom class to load values into class and apply business logic
ContentMgr.LoadContentFromHash(content, newValues);

//To assign the values directly:
//
// content.contentName = "Content Name";
//
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}

LINQ: Delete single record

DCMS.net.LINQClasses.DCMSDataClassesDataContext db = new DCMS.net.LINQClasses.DCMSDataClassesDataContext();
var query = from content in db.Contents
where content.contentID == Convert.ToInt32(dataItem["contentID"].Text)
select new
{
content.contentID,
};
if (query.Any())
{
var content =
(from cont in db.Contents
where cont.contentID == Convert.ToInt32(dataItem["contentID"].Text)
select cont).First();
db.Contents.DeleteOnSubmit(content);
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}

LINQ:Query to data source on grid

Here is an example LINQ query that populates a gridview:

DCMS.net.LINQClasses.DCMSDataClassesDataContext db = new DCMS.net.LINQClasses.DCMSDataClassesDataContext();
var query = from content in db.Contents
where content.resourceID == Convert.ToInt32(HttpContext.Current.Cache.Get("FAMILY_RESOURCEID"))
select new
{
content.contentID,
content.resourceID,
content.contentName,
content.contentLastName,
content.contentFileName,
content.contentDetails,
content.contentModDate,
content.contentImage1
};
rgFamily.DataSource = query;