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());
}
}
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);
}
}
public static List <DM_SUPER_TYP> GroundLevelTypes()
{
using (var e = new EsToDoEntities())
{
return(e.DM_SUPER_TYP.Where(p => p.GROUP_ID == null).ToList());
}
}