Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to find the first and last data of sql using linq?
Ask Question

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

Ethan Karla 711 24 Sep 2021

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

linq c#ado.netlinq
Updated 24 Sep 2021
Ethan Karla
Ethan Karla

Student

An enthusiastic, adaptive, and fast-learning person with a broad and acute interest in the discovery of new innovative drugs, I particularly enjoy collaborating with scientists from different disciplines to develop new skills and solve new challenges.

Message

1 Answers

Ravi Vishwakarma
Ravi Vishwakarma 27 Sep 2021
Report Abuse

We use the First and Last methods in LINQ for finding the first element and last element.

  1. First() are used to fetching the first row data from SQL and we can use the FirstOrDefault() method 
  2. 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
{
 public static void Main()
 {

  List<Student> students = new List<Student>()
  {
  new Student() { StudentId = 1, Name = 'Ashu', Marks = 500 },
  new Student() { StudentId = 2, Name = 'Shyam', Marks = 300 },
  new Student() { StudentId = 3, Name = 'Shriyam', Marks = 400 },
  new Student() { StudentId = 4, Name = 'Sunny', Marks = 550 },
  new Student() { StudentId = 5, Name = 'Ram', Marks = 600 },
  new Student() { StudentId = 6, Name = 'Krishna', Marks = 700 },
  new Student() { StudentId = 7, Name = 'Anupam', Marks = 550 }
  };

  List<Student> list = students.Where( stu => stu.Marks > 500).ToList();

  Console.WriteLine('\nAll value :\n');
  Console.WriteLine('{0,-10} {1,10} {2,5}','Name', 'ID', 'Marks');
  list.ForEach( student => Console.WriteLine('{0,-10} {1,10} {2,5}', student.Name, student.StudentId, student.Marks) );

  Student first = students.Where( stu => stu.Marks > 500).First();

  Console.WriteLine('\nFirst() :\n');
  Console.WriteLine('{0,-10} {1,10} {2,5}','Name', 'ID', 'Marks');
  Console.WriteLine('{0,-10} {1,10} {2,5}', first.Name, first.StudentId, first.Marks);

  Student last = students.Where( stu => stu.Marks > 500).Last();

  Console.WriteLine('\nLast() :\n');
  Console.WriteLine('{0,-10} {1,10} {2,5}','Name', 'ID', 'Marks');
  Console.WriteLine('{0,-10} {1,10} {2,5}', last.Name, last.StudentId, last.Marks);

  Console.ReadLine();
 }
}

class Student
{
public int StudentId { get; set; }
public string Name { get; set; }
public int Marks { get; set; }
}

Output

All value :

Name               ID Marks
Sunny               4   550
Ram                 5   600
Krishna             6   700
Anupam              7   550

First() :

Name               ID Marks
Sunny               4   550

Last() :

Name               ID Marks
Anupam              7   550
MindStick Training