public void BulkUpdateTemplate(Guid siteID, List<Guid> lstUpd, string sTemplateFile)
{
IQueryable<carrot_Content> queryCont = (from ct in db.carrot_Contents
join r in db.carrot_RootContents on ct.Root_ContentID equals r.Root_ContentID
where r.SiteID == siteID
&& lstUpd.Contains(r.Root_ContentID)
&& ct.IsLatestVersion == true
select ct);
db.carrot_Contents.BatchUpdate(queryCont, p => new carrot_Content { TemplateFile = sTemplateFile });
db.SubmitChanges();
}