コード例 #1
0
 List <FunctionSet> GetFunctionSets()
 {
     using (var ctx = new AmoebaDBEntities(Settings.Default.DBConnectionString))
     {
         return(ctx.FunctionSets.ToList());
     }
 }
コード例 #2
0
        public static List <EntityView> GetEntityViews(int appId)
        {
            using (var ctx = new AmoebaDBEntities(Settings.Default.DBConnectionString))
            {
                return(ctx.EntityViews.Where(x => x.Entity.ApplicationEntities.Any(z => z.ApplicationId == appId))
                       .Include(x => x.Entity)
                       .Include(x => x.Entity.EntityProperties)

                       .Include("Entity.EntityProperties.DataProperties.DataType")
                       .Include("Entity.EntityProperties.DataProperties.ModelType")
                       .Include("Entity.EntityProperties.DataProperties.PrimaryKeyOption")
                       .Include("Entity.EntityProperties.ChildRelationships")
                       .Include("Entity.EntityProperties.ChildRelationships.RelationshipType")
                       .Include("Entity.EntityProperties.ChildRelationships.ParentProperty")
                       .Include("Entity.EntityProperties.ChildRelationships.ParentProperty.Entity")
                       .Include("Entity.EntityProperties.ChildRelationships.ChildProperty")
                       .Include("Entity.EntityProperties.ChildRelationships.ChildProperty.Entity")
                       .Include("Entity.EntityProperties.ChildRelationships.ChildProperty.Entity.EntityProperties.DataProperties")
                       .Include("Entity.EntityProperties.ChildRelationships.ChildProperty.Entity.EntityProperties.DataProperties.PrimaryKeyOption")
                       .Include("Entity.EntityProperties.ParentRelationships")
                       .Include("Entity.EntityProperties.ParentRelationships.RelationshipType")
                       .Include("Entity.EntityProperties.ParentRelationships.ParentProperty.Entity.EntityProperties.DataProperties.PrimaryKeyOption")
                       .Include("Entity.EntityProperties.ParentRelationships.ChildProperty")


                       .Include("EntityViewProperties.EntityProperty.Entity")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.DataProperties.DataType")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.DataProperties.ModelType")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.DataProperties.PrimaryKeyOption")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ChildRelationships")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ChildRelationships.RelationshipType")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ChildRelationships.ParentProperty")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ChildRelationships.ParentProperty.Entity")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ChildRelationships.ChildProperty")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ChildRelationships.ChildProperty.Entity")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ChildRelationships.ChildProperty.Entity.EntityProperties.DataProperties")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ChildRelationships.ChildProperty.Entity.EntityProperties.DataProperties.PrimaryKeyOption")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ParentRelationships")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ParentRelationships.RelationshipType")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ParentRelationships.ParentProperty.Entity.EntityProperties.DataProperties.PrimaryKeyOption")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.ParentRelationships.ChildProperty")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.PresentationProperty")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.DataProperties.PrimaryKeyOption")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.DataProperties.DataType")
                       .Include("EntityViewProperties.EntityProperty.Entity.EntityProperties.DataProperties.ModelType")
                       .Include("EntityViewProperties.EntityViewViewProperty")
                       .Include("EntityViewProperties.EntityViewPropertyFunctions")
                       .Include("EntityViewProperties.EntityViewPropertyFunctions.Function")
                       .Include("EntityViewProperties.EntityViewPropertyFunctions.EntityViewPropertyFunctionParameter.FunctionParameter.Parameter.DataType")
                       .Include("EntityViewProperties.EntityViewPropertyFunctions.EntityViewPropertyFunctionParameter.FunctionParameter.Function.ReturnDataType.DataType")
                       .Include("EntityViewProperties.EntityViewPropertyFunctions.EntityViewPropertyFunctionParameter")
                       .ToList());
            }
        }
コード例 #3
0
 public static List <Function> GetFunctions(int appId)
 {
     using (var ctx = new AmoebaDBEntities(Settings.Default.DBConnectionString))
     {
         return(ctx.Functions.Where(x => x.ReturnDataType != null && x.EntityViewPropertyFunctions.Any(y => y.EntityViewProperty.EntityProperty.Entity.ApplicationEntities.Any(z => z.ApplicationId == appId)))
                .Include(x => x.ReturnDataType)
                .Include("FunctionBody")
                .Include("FunctionParameters")
                .Include("FunctionParameters.Parameter.DataType")
                .ToList());
     }
 }
コード例 #4
0
 public static Application GetApp(string appName)
 {
     try
     {
         using (var ctx = new AmoebaDBEntities(Settings.Default.DBConnectionString))
         {
             return(ctx.Applications
                    .Include(x => x.Settings)
                    .Include("Settings.Layer")
                    .Include("Settings.Project")
                    .First(x => x.Name == appName));
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
コード例 #5
0
        public static List <ApplicationEntity> GetEntities(int appId)
        {
            var spec = ApplicationEntitySpecificationContext.GetEntitiesSpec(appId);

            using (var ctx = new AmoebaDBEntities(Settings.Default.DBConnectionString))
            {
                return(ctx.ApplicationEntities//.Where(spec)
                       .Where(ApplicationEntitySpecificationContext.WithAppId(appId))
                       .Include(x => x.Entity)
                       .Include(x => x.Entity.EntityProperties)
                       .Include("Entity.EntityViews.EntityViewProperties.EntityProperty")
                       .Include("Entity.EntityViews.EntityViewProperties.EntityViewViewProperty")
                       .Include("Entity.EntityViews.EntityViewProperties.EntityViewPropertyFunctions")
                       .Include("Entity.EntityViews.EntityViewProperties.EntityViewPropertyFunctions.Function")
                       .Include("Entity.EntityViews.EntityViewProperties.EntityViewPropertyFunctions.EntityViewPropertyFunctionParameter.FunctionParameter.Parameter.DataType")
                       .Include("Entity.EntityViews.EntityViewProperties.EntityViewPropertyFunctions.EntityViewPropertyFunctionParameter.FunctionParameter.Function.ReturnDataType.DataType")
                       .Include("Entity.EntityViews.EntityViewProperties.EntityViewPropertyFunctions.EntityViewPropertyFunctionParameter")
                       .Include("Entity.EntityProperties.TestValues")
                       .Include("Entity.EntityProperties.ChildRelationships")
                       .Include("Entity.EntityProperties.ChildRelationships.RelationshipType")
                       .Include("Entity.EntityProperties.ChildRelationships.ParentProperty")
                       .Include("Entity.EntityProperties.ChildRelationships.ParentProperty.Entity")
                       .Include("Entity.EntityProperties.ChildRelationships.ChildProperty")
                       .Include("Entity.EntityProperties.ChildRelationships.ChildProperty.Entity")
                       .Include("Entity.EntityProperties.ChildRelationships.ChildProperty.Entity.EntityProperties.DataProperties")
                       .Include("Entity.EntityProperties.ChildRelationships.ChildProperty.Entity.EntityProperties.DataProperties.PrimaryKeyOption")
                       .Include("Entity.EntityProperties.ParentRelationships")
                       .Include("Entity.EntityProperties.ParentRelationships.RelationshipType")
                       .Include("Entity.EntityProperties.ParentRelationships.ParentProperty.Entity.EntityProperties.DataProperties.PrimaryKeyOption")
                       .Include("Entity.EntityProperties.ParentRelationships.ChildProperty")
                       .Include("Entity.EntityProperties.PresentationProperty")
                       .Include("Entity.EntityProperties.DataProperties.PrimaryKeyOption")
                       .Include("Entity.EntityProperties.DataProperties.DataType")
                       .Include("Entity.EntityProperties.DataProperties.ModelType")

                       .DistinctBy(x => x.Id).ToList());
            }
        }