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 vote117 views1 answer
Unity pause shortcut
C#
0 vote115 views1 answer
Command to add entity framework layer in existing database
C#
1 vote135 views1 answer
Unity editor dropdown
C#
2 votes122 views1 answer
Unity rotate around pivot c#
C#Unity
0 vote141 views1 answer
C# count directories in directory and subdirectories
C#
1 vote128 views1 answer
What is data encapsulation c#
C#
9 votes114 views1 answer
You have the following c# code. stringbuilder sb = new stringbuilder(really long string); the really long string variable is a string in which a very long string is stored.
C#
2 votes108 views1 answer
Calling stored procedure in c# entity framework
C#
1 vote139 views1 answer
C# unity follow object
C#Unity
3 votes107 views1 answer
C# save pdf stream to file
C#