Monday, October 20, 2008

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;
}
}

No comments: