public IEnumerable <Table_info> Get()
{
gestion_horariosEntities ctx = new gestion_horariosEntities();
var tablas = ctx.Database.SqlQuery <Table_info>("SELECT * FROM information_schema.tables where table_schema='gestion_horarios'").ToList();
return(tablas);
}
public IEnumerable <Column_info> Get(string nombre_tabla)
{
//SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'gestion_horarios' AND TABLE_NAME = 'alumno';
gestion_horariosEntities ctx = new gestion_horariosEntities();
var tabla = ctx.Database.SqlQuery <Column_info>("SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'gestion_horarios' AND TABLE_NAME = '" + nombre_tabla + "'").ToList();
return(tabla);
}
