예제 #1
0
 public static List <DM_SUPER_TYP> ChildList(long superGroupId)
 {
     using (var e = new EsToDoEntities())
     {
         return(e.DM_SUPER_TYP.Where(p => p.GROUP_ID == superGroupId).ToList());
     }
 }
예제 #2
0
        public static List <string> proba()
        {
            List <string> list     = new List <string>();
            string        sqlQuery = "select * from all_tab_columns WHERE OWNER = 'OBH_TEST'";

            //select * from "PUBLIC".USER_TAB_COLS ;
            //SELECT * FROM user_tables;
            using (var e = new EsToDoEntities())
            {
                var conn = e.Database.Connection;
                conn.Open();
                //var schema = conn.GetSchema("columns");

                //DisplayData(schema);
                //Console.WriteLine("Press any key to continue.");
                //Console.ReadKey();

                var cmd = conn.CreateCommand();
                cmd.CommandText = sqlQuery;
                var reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    list.Add(reader.GetString(reader.GetOrdinal("COLUMN_NAME")));
                }
                conn.Close();
                return(list);
            }
        }
예제 #3
0
 public static List <DM_SUPER_TYP> GroundLevelTypes()
 {
     using (var e = new EsToDoEntities())
     {
         return(e.DM_SUPER_TYP.Where(p => p.GROUP_ID == null).ToList());
     }
 }