SQL to LINQ

Thanks much Shambhu. Your code helps in a better way.

Rgds,
Anitha

Hi,

Above query can be split into two. first query for inline table and then join with main table and then write condition. There is written below using sample data.



 List WHList = new List
            {
                new Warehouse{ WHCode = "W001", WHLocation = "Bangalore", WHName = "WH001"},
                new Warehouse{ WHCode = "W002", WHLocation = "Delhi", WHName = "WH001"},
                new Warehouse{ WHCode = "W003", WHLocation = "Kolkata", WHName = "WH003"}
            };

            List SupList = new List
            {
                new Supplier { SupName ="S001", SupAddress = "Bangalore1", SupContact = "100", WHCode = "W001" },
                new Supplier { SupName ="S002", SupAddress = "Bangalore2", SupContact = "200", WHCode = "W002" } ,
                new Supplier { SupName ="S003", SupAddress = "Bangalore3", SupContact = "300", WHCode = "W003" }
            };


            //inline table with case

            var InnerQuery = from n in SupList
                         select new
                         {
                             WHCode = n.WHCode,
                             warehouseRange = n.SupName == null ? "S001"
                                              : n.SupName == "S002" ? "S002"
                                              : n.SupName == "S003" ? "S003"
                                              : "S000"
                         };


            var MainQuery = from a in InnerQuery
                            join b in WHList on a.WHCode equals b.WHCode
                            where a.WHCode == "W001"
                            select new { a.warehouseRange, b.WHCode };


class Warehouse
    {
        public string WHName { get; set; }
        public string WHCode { get; set; }
        public string WHLocation { get; set; }   
    }

    class Supplier
    {
        public string SupName { get; set; }
        public string SupAddress { get; set; }
        public string SupContact { get; set; }
        public string WHCode { get; set; }
    }

May this linq helps u better...

Regards,
Shambhu.