Count Rows of table using Linq

using System.Linq;

namespace ConsoleApplication11    {
    class Program
    {
        string me_login_name;
        int me_pkey;

        public static void Main()
        {
            new Program().Run();
        }

        private void Run()
        {
            IQueryable<v2oneboxDataEntity> me_employees = null;

            var duplicate =
                from  loginId in me_employees
                where loginId.me_login_name == this.me_login_name
                        && loginId.me_pkey != this.me_pkey
                select loginId;

            var count = duplicate.Count();            
        }

        // Define other methods and classes here
        class v2oneboxDataEntity 
        {
            public string me_login_name { get; set; }
            public int me_pkey { get; set; }
        }
    }
}

Source: stackoverflow.com

Similar codes

6 votes143 views1 answer
Net core 5.0 create model from database
C#
0 vote141 views2 answers
.net return context.Result without extra new objectResult
C#
0 vote130 views1 answer
C# program that joins List of strings
C#
0 vote159 views1 answer
C# datareader already open visual studio mysql
C#
0 vote142 views1 answer
Unity get prefabs from folder
C#
42 votes151 views2 answers
How to replace last character of string in c#
C#
0 vote170 views1 answer
.net core upgrade assistant
C#
0 vote145 views1 answer
C# get date without time
C#
0 vote145 views1 answer
What is vector3.one c#
C#
0 vote151 views1 answer
Oracle c# parameters wont work
C#