更好的方法来查询数据页面并获得实体框架4.1中的总计数？

using System.Linq;
using System.Data.Entity;

public class MyContext : DbContext
{
    public DbSet<MyEntity> MyEntities { get; set; }
}

public class MyEntity
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class MyRepository
{
    public int GetTotalCount()
    {
        using (var context = new MyContext())
        {
            return context.MyEntities.Count();
        }
    }
}

using System.Data.Entity;

public class MyContext : DbContext
{
    public DbSet<MyEntity> MyEntities { get; set; }
}

public class MyEntity
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class MyRepository
{
    public int GetTotalCount()
    {
        using (var context = new MyContext())
        {
            return context.Database.SqlQuery<int>("SELECT COUNT(*) FROM MyEntities").FirstOrDefault();
        }
    }
}

using System.Data.Entity;

public class MyContext : DbContext
{
    public DbSet<MyEntity> MyEntities { get; set; }
}

public class MyEntity
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class MyRepository
{
    public int GetTotalCount()
    {
        using (var context = new MyContext())
        {
            var sql = "CREATE PROCEDURE GetTotalCount AS BEGIN SELECT COUNT(*) FROM MyEntities END";
            context.Database.ExecuteSqlCommand(sql);
            var result = context.Database.SqlQuery<int>("GetTotalCount").FirstOrDefault();
            context.Database.ExecuteSqlCommand("DROP PROCEDURE GetTotalCount");
            return result;
        }
    }
}