public List <clientes> GetList(string linea) { try { using (var db = new NtLinkLocalServiceEntities()) { string query = "select Value c from NtLinkLocalServiceEntities.clientes as c inner join NtLinkLocalServiceEntities.empresa as b " + " ON (c.idempresa = b.IdEmpresa) where b.Linea = @linea"; ObjectParameter op = new ObjectParameter("linea", linea); var q = db.CreateQuery <clientes>(query, new [] { op }).OrderBy(p => p.RazonSocial); var result = q.ToList(); return(result); } } catch (Exception ee) { Logger.Error(ee.Message); if (ee.InnerException != null) { Logger.Error(ee.InnerException); } return(null); } }