Get records count using Linq query in ASP.Net using C# and VB.Net

Hi SUJAYS,

You have to use String.StartsWith, EndsWith, or Contains for like operator and count function to evaluate.

Check this example. Now please take its reference and correct your code.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    NorthwindEntities entities = new NorthwindEntities();
    int countTotal = entities.Customers.Where(x => x.ContactName.StartsWith("W")).ToList().Count();
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim entities As NorthwindEntities = New NorthwindEntities()
    Dim countTotal As Integer = entities.Customers.Where(Function(x) x.ContactName.StartsWith("W")).ToList().Count()
End Sub