TIUConsulting

  1. What does include function of Linq do

Ans : https://interview-preparation-for-you.blogspot.com/2021/06/when-to-use-include-with-entity.html

  2.  How to write left join in linq query

      Ans using defualtIfEmpty function

var q =
    from c in categories
    join p in products on c.Category equals p.Category into ps
    from p in ps.DefaultIfEmpty()
    select new { Category = c, ProductName = p == null ? "(No products)" : p.ProductName };

  3. What we will do in ngAfterViewInit

Ans : https://interview-preparation-for-you.blogspot.com/2021/06/ngafterviewinit.html

  4. What we will do in ngDoCheck

  5. Delete duplicate row except one

Delete from Employee m1 , Employee m2 where m1.Name=m2.Name and m1.CreatedDate<m2.CreateDate