How to find the first and last data of SQL using LINQ?

Question

Ravi Vishwakarma · Answer

We use the First and Last methods in LINQ for finding the first element and last element.
First() are used to fetching the first row data from SQL and we can use the
FirstOrDefault() methodand Last() are used to fetching the last row data from SQL and we can use the
LastOrDefault() method
using System;using System.Collections.Generic;using System.Linq;
public class Program{and public static void Main()and {
and  Listandlt;Student> students = new Listandlt;Student>()and  {and  new Student() { StudentId = 1, Name = 'Ashu', Marks = 500 },and  new Student() { StudentId = 2, Name = 'Shyam', Marks = 300 },and  new Student() { StudentId = 3, Name = 'Shriyam', Marks = 400 },and  new Student() { StudentId = 4, Name = 'Sunny', Marks = 550 },and  new Student() { StudentId = 5, Name = 'Ram', Marks = 600 },and  new Student() { StudentId = 6, Name = 'Krishna', Marks = 700 },and  new Student() { StudentId = 7, Name = 'Anupam', Marks = 550 }and  };
and  Listandlt;Student> list = students.Where( stu => stu.Marks > 500).ToList();
and  Console.WriteLine('
All value :
');and  Console.WriteLine('{0,-10} {1,10} {2,5}','Name', 'ID', 'Marks');and  list.ForEach( student => Console.WriteLine('{0,-10} {1,10} {2,5}', student.Name, student.StudentId, student.Marks) );
and  Student first = students.Where( stu => stu.Marks > 500).First();
and  Console.WriteLine('
First() :
');and  Console.WriteLine('{0,-10} {1,10} {2,5}','Name', 'ID', 'Marks');and  Console.WriteLine('{0,-10} {1,10} {2,5}', first.Name, first.StudentId, first.Marks);
and  Student last = students.Where( stu => stu.Marks > 500).Last();
and  Console.WriteLine('
Last() :
');and  Console.WriteLine('{0,-10} {1,10} {2,5}','Name', 'ID', 'Marks');and  Console.WriteLine('{0,-10} {1,10} {2,5}', last.Name, last.StudentId, last.Marks);
and  Console.ReadLine();and }}
class Student{public int StudentId { get; set; }public string Name { get; set; }public int Marks { get; set; }}
Output
All value :
Name               ID MarksSunny               4   550Ram                 5   600Krishna             6   700Anupam              7   550
First() :
Name               ID MarksSunny               4   550
Last() :
Name               ID MarksAnupam              7   550

forum

How to find the first and last data of SQL using LINQ?

Ethan Karla

Can you answer this question?

1 Answers

Liked By