public int GetRelationsCount() { using (ProcessingMQEntities context = ProcessingMQEntities.Create(ConnectionString)) { return(context.Sys_ColumnsTypes.Select(x => x.TableName).Distinct().Count()); } }
public int GetVariablesCount() { using (ProcessingMQEntities context = ProcessingMQEntities.Create(ConnectionString)) { return(context.Sys_ColumnsTypes.Select(x => x.Type).Distinct().Count()); } //ProcessingMQModel a; //SysDefineTableColumn a; }
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(; } }