public static void RemoveUserDependancies(int id) { Security.DataContext.SecurityContext context = new SecurityContext(); SqlParameter parameter = new SqlParameter("fromUser", id); SqlParameter parameter2 = new SqlParameter("toUser", id); context.Database.SqlQuery<string>("CHANGE_USER", new object[] { parameter, parameter2 }); }
internal static void ConsolidateUser(int fromUserID, int toUserID) { Security.DataContext.SecurityContext context = new SecurityContext(); SqlParameter parameter = new SqlParameter("@FromUser", fromUserID); SqlParameter parameter2 = new SqlParameter("@ToUser", toUserID); IEnumerable<string> str = context.Database.SqlQuery<string>("CHANGE_USER @FromUser, @ToUser", new object[] { parameter, parameter2 }).ToList(); context.Database.ExecuteSqlCommand(string.Format("delete from [User] where ID = {0}", fromUserID)); }