Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

¿Concatenar varios registros en una cadena para mostrarlo en uno solo? LINQ

General Tech Technology & Software

Max. 2000 characters
Replies

usr_profile.png

User

( 2 months ago )

 

tengo una tabla llamada Technologys y cada Technology puede tener una o mas resolutions. Lo que quiero hacer es que se muestren todas las resoluciones que tiene una tecnologia en un mismo campo.

Ejemplo

Tabla de tecnologias
Nombre   Descripcion   Resoluciones
1        prueba        140,33,32

Necesito hacerlo con linq y me han dicho que la clave esta en un String Join o en un Agregate usando dos querys pero no puedo conseguirlo.

Este es mi codigo:

  var Technology1 = (from  tTechnology in Context.Technology

                                                 join tUsers in Context.Users on tTechnology.EnableBy equals tUsers.UserId into collection
                                                 from subCase in collection.DefaultIfEmpty()
                                                 join tUsers2 in Context.Users on tTechnology.LastChangeBy equals tUsers2.UserId into collection2
                                                 from subCase2 in collection2.DefaultIfEmpty()
                                                 join tUsers3 in Context.Users on tTechnology.DisableBy equals tUsers3.UserId into collection3
                                                 from subCase3 in collection3.DefaultIfEmpty()
                                                 join tResolution in Context.Resolution on tTechnology.TechnologyId equals tResolution.TechnologyId 
                                                 into collection4
                                                 from subCase4 in collection4.DefaultIfEmpty()                  
                                                 where tTechnology.DisableDate == null



                             //orderby 

            select new
            {
                tTechnologyTechnologyId = tTechnology.TechnologyId,
                tTechnologyName = tTechnology.Name,
                tTechnologyDescription = tTechnology.Description,
                tCityName = tTechnology.City.Name,
                tStateName = tTechnology.City.State.Name,
                tCountryName = tTechnology.City.State.Country.Name,
                tResolutions = (from tR in Context.Resolution
                                 where tR.TechnologyId == tTechnology.TechnologyId
                                 select tR.Measure
                               ),

                tEnableBy = (subCase.Name == null ? null : subCase.Name) + "" + (subCase.FirstLastName == null ? null : subCase.FirstLastName) + " " + (subCase.SecondLastName == 
usr_profile.png

User

( 2 months ago )

Deberias usar tTec para acceder a las propiedades

var Technology = (from tTec in Technology1
              select new
              {
                  tTechnologyTechnologyId = tTec.tTechnologyTechnologyId,
                  tTechnologyName = tTec.tTechnologyName,
                  tTechnologyDescription = tTec.tTechnologyDescription,
                  tCityName = tTec.tCityName,
                  tStateName = tTec.tStateName,
                  tCountryName = tTec.tCountryName,
                  tResolutions = String.Join(",", tTec.tResolutions),
              });

Al ser la propiedad Measure del tipo long deberias convertirla en string en la primer query linq

 tResolutions = (from tR in Context.Resolution
                             where tR.TechnologyId == tTechnology.TechnologyId
                             select tR.Measure.ToString()
                           ).ToArray(),

what's your interest