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

-1 vote189 views1 answer
How get data from json in c#
C#
0 vote190 views1 answer
C# iorderedenumerable to dictionary
C#
0 vote176 views1 answer
C# do while or
C#
0 vote179 views1 answer
C sharp tenery operator with callin gmethods
C#
1 vote183 views1 answer
Get both item and index in c#
C#
0 vote194 views1 answer
Rename join ta le in many to many
C#
0 vote182 views1 answer
Pointer in c#
C#
0 vote182 views1 answer
Percentage random c#
C#
35 votes185 views4 answers
C# list length
C#
0 vote177 views1 answer
How to set unique constraint from EF core
C#