Example #1
0
        public static void SetLowestFreeId(dynamic element)
        {
            if (element.Id != null)
            {
                return;
            }

            string table    = ObjectMetadata.GetTableName(element.GetType());
            string idColumn = ObjectMetadata.GetKeyColumn(element.GetType());
            //
            string sql = "SELECT MIN(t1." + idColumn + " + 1) AS nextID "
                         + " FROM (SELECT 0 as " + idColumn + " UNION SELECT " + idColumn + " FROM " + table + ") as t1 "
                         + "	 LEFT JOIN "+ table + " t2 "
                         + "			 ON t1."+ idColumn + " + 1 = t2." + idColumn + " "
                         + " WHERE t2." + idColumn + " IS NULL";

            int nextId = context.Data.Session.SqlActions.ExecuteScalarIntNoFlush(sql);

            while (used.ContainsKey(table) && used[table].Contains(nextId))
            {
                nextId += 1;
            }
            element.Id = nextId;
            if (!used.ContainsKey(table))
            {
                used.Add(table, new List <int>());
            }
            used[table].Add(nextId);
        }
Example #2
0
        public static void SetId(dynamic element)
        {
            if (element.Id != null)
            {
                return;
            }

            string table    = ObjectMetadata.GetTableName(element.GetType());
            string idColumn = ObjectMetadata.GetKeyColumn(element.GetType());
            //
            string sql    = "SELECT IFNULL(MAX(" + idColumn + "), 0) + 100 id FROM " + table + " WHERE " + idColumn + " % 100 = 0";
            int    nextId = context.Data.Session.SqlActions.ExecuteScalarIntNoFlush(sql);

            while (used.ContainsKey(table) && used[table].Contains(nextId))
            {
                nextId += 100;
            }
            element.Id = nextId;
            if (!used.ContainsKey(table))
            {
                used.Add(table, new List <int>());
            }
            used[table].Add(nextId);
        }