Example #1
0
        public static DbObject Map(DbObjectInfo from)
        {
            if (from == null)
                return null;

            DbObject to = new DbObject();
            to.Name = from.fullName;

            if (!string.IsNullOrEmpty(from.objectType))
            {
                //determine object type from objType key
                switch (from.objectType.Trim())
                {
                    case ObjectTypeKeys.DBKEY_STOREDPROC:
                        to.ObjectType = ObjectType.StoredProc;
                        to.ObjectTypeKey = ObjectTypeKeys.VIEWKEY_STOREDPROC;
                        break;
                    case ObjectTypeKeys.DBKEY_TABLE:
                        to.ObjectType = ObjectType.Table;
                        to.ObjectTypeKey = ObjectTypeKeys.VIEWKEY_TABLE;
                        break;
                    case ObjectTypeKeys.DBKEY_VIEW:
                        to.ObjectType = ObjectType.View;
                        to.ObjectTypeKey = ObjectTypeKeys.VIEWKEY_VIEW;
                        break;
                    case ObjectTypeKeys.DBKEY_FUNCTION1:
                    case ObjectTypeKeys.DBKEY_FUNCTION2:
                    case ObjectTypeKeys.DBKEY_FUNCTION3:
                        to.ObjectType = ObjectType.Function;
                        to.ObjectTypeKey = ObjectTypeKeys.VIEWKEY_FUNCTION;
                        break;
                }

            }

            return to;
        }
Example #2
0
		void buildDependencyDic(DbObject obj, Dictionary<string, string[]> dic)
        {
			Debug.WriteLine("Processing: " + obj.Name);

            if (dic.ContainsKey(obj.Name) == false)
                dic.Add(obj.Name, obj.DependsOn.Select(d => d.Name).ToArray());
            else
                return;

            foreach (var dependency in obj.DependsOn) 
				buildDependencyDic(dependency, dic);

        }