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

0 vote151 views1 answer
Valid URL check in c#
C#
0 vote150 views1 answer
Vb.net read registry key as string
C#
1 vote198 views1 answer
Unity change particle system sorting layer via script
C#Unity
0 vote159 views1 answer
Min max to 01
C#
0 vote180 views1 answer
The 'this' object cannot be used before all of its fields are assigned to
C#
0 vote143 views1 answer
Reading Excel files from C#
C#
0 vote149 views1 answer
DefaultContractResolver .net exclude null values JsonSerializerSettings ContractResolver DefaultContractResolver
C#
0 vote153 views1 answer
Make character move upward forever unity 2d
C#
0 vote141 views1 answer
Source a listbox by property of object c#
C#
5 votes169 views3 answers
Find the max number in an array c#
C#