How can I convert this code LINQ to SQL in C # LINQ to SQL in Vb.net

Question

    public IQueryable<Maestro_Clientes> GetMaestro_Clientes()
    {
        var q = from co in this.Context.Cli_Consumos
            group co by new
            {
                Servicio = co.Servicio,
                Cliente = co.Cli_Servicio.Cli_Cliente.Nombre ,
                Tarifa = co.Cli_Servicio.Cli_Tarifa.Descripcion ,
                Sector = co.Cli_Servicio.Sector,
                Sector_Nombre = co.Cli_Servicio.Cli_Sector.Descripcion 
            }

            into grp
                select new Maestro_Clientes
                {
                    Servicio = grp.Key.Servicio,
                    Nombre = grp.Key.Cliente,
                    Tarifa = grp.Key.Tarifa,
                    Sector = grp.Key.Sector,
                    Sector_Nombre = grp.Key.Sector_Nombre,
                    Consumo_Energia = grp.Sum(co => co.Consumo_Energia)
                };

        return q;
    }

Telerik and Developer Fusion not convert well

converting with Developer Fusion or Telerik is lost or field list — Leonardo
– Leonardo, Commented Oct 30, 2009 at 21:33

Matthew Sposato · Accepted Answer · 2009-10-30 20:57:49Z

1

Have you tried any of the online converters? i.e. Developer Fusion or Telerik

answered Oct 30, 2009 at 20:57

Matthew Sposato

1,6351 gold badge11 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fredrik Mörk Over a year ago

I tried both of them, and they both seem to fail when it comes to converting the anonymous type constructs.

pete_s · Accepted Answer · 2011-04-05 23:59:23Z

0

Try SharpDevelop's CodeConverter. It works best if you give it a whole function or class.

answered Apr 5, 2011 at 23:59

community wiki

pete_s

Collectives™ on Stack Overflow

How can I convert this code LINQ to SQL in C # LINQ to SQL in Vb.net

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related