Пример #1
0
 public int GetRelationsCount()
 {
     using (ProcessingMQEntities context = ProcessingMQEntities.Create(ConnectionString))
     {
         return(context.Sys_ColumnsTypes.Select(x => x.TableName).Distinct().Count());
     }
 }
Пример #2
0
        public int GetVariablesCount()
        {
            using (ProcessingMQEntities context = ProcessingMQEntities.Create(ConnectionString))
            {
                return(context.Sys_ColumnsTypes.Select(x => x.Type).Distinct().Count());
            }

            //ProcessingMQModel a;
            //SysDefineTableColumn a;
        }
Пример #3
0
        public int GetRelationsCount()
        {
            using (ProcessingMQEntities context = new ProcessingMQEntities())
            {
                return(context.Sys_ColumnsTypes.Select(x => x.TableName).Distinct().Count());
            }

            //ProcessingMQModel a;
            //SysDefineTableColumn a;
        }
Пример #4
0
        public List <int> GetRelationsVarCount()
        {
            using (ProcessingMQEntities context = ProcessingMQEntities.Create(ConnectionString))
            {
                return(context.Sys_ColumnsTypes
                       .GroupBy(x => x.TableName)
                       .Select(g => g.Count())
                       .OrderByDescending(i => i)
                       .ToList <int>());

                //return context.SysDefineTableColumns.Select(x => x.TableName).Count(;
            }
        }