////INSERT- UPDATE - DELETE public int Insert(int PortalId, int ContentItemId, string CultureCode, string RouteName, string RouteUrl, string PhysicalFile, bool CheckPhysicalUrlAccess, string RouteValueDictionary, string Description, bool Discontinued) { int returnValue = 0; using (CommonEntities dbContext = new CommonEntities()) { using (System.Transactions.TransactionScope transcope = new System.Transactions.TransactionScope()) { int ListOrder = (from u in dbContext.aspnet_Routes select u.ListOrder).DefaultIfEmpty(0).Max() + 1; aspnet_Routes entity = new aspnet_Routes(); entity.PortalId = PortalId; entity.ContentItemId = ContentItemId; entity.CultureCode = CultureCode; entity.RouteName = RouteName; entity.RouteUrl = RouteUrl; entity.PhysicalFile = PhysicalFile; entity.CheckPhysicalUrlAccess = CheckPhysicalUrlAccess; entity.RouteValueDictionary = RouteValueDictionary; entity.Description = Description; entity.ListOrder = ListOrder; entity.Discontinued = Discontinued; dbContext.AddToaspnet_Routes(entity); returnValue = dbContext.SaveChanges(); dbContext.Connection.Close(); transcope.Complete(); } } return(returnValue); }