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 int GetRelationsCount()
{
using (ProcessingMQEntities context = new ProcessingMQEntities())
{
return(context.Sys_ColumnsTypes.Select(x => x.TableName).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(;
}
}