LINQ: SqlDateTime overflow. Must be between ...

WHEN a NULL value to passed to a non null datetime field using LINQ datasource. If the field is autogenerated make sure to mark as autogenerated in LINQ DBML designer else pass the value using a parameter

How to use IndexOf() method of List <object> asp net c#

var index = students.FindIndex(st => st.ID == student.ID);

Cannot convert lambda expression to type 'string' because it is not a delegate type

//add this
using System.Linq;
//or this
using System.Data.Entity;

LINQ Lamda Syntax - Selecting multiple columns

use the new keyword

var parent = dc.Forms.Select(f => new { f.FormID, f.ModuleId })

LINQ Difference Between Select and SelectMany

SelectMany flattens queries that return lists of lists

LINQ Case statement within Count asp net c#

var statu = from x in dc.Attendance
            group x by 1 into g
            select new
            {
                ID = g.Key,
                Presents = g.Where(t => t.AttendanceStatus == "Present").Count(),
                Absents = g.Where(t => t.AttendanceStatus == "Absent").Count(),
                Leaves = g.Where(t => t.AttendanceStatus == "Leave").Count(),
            };