Changing an extention method from linq-to-sql to entity framework

Question

I'm changing my project from working with Linq-to-SQL to working with Entity Framework.

I have some extention methods that extend the classes created by LINQ and I'm wondering how to change them to work with the entities instead

Here's an example.

public static int GetPublishedArticlesCount(this Table<Article> source)
    {
        return GetPublishedArticles(source.Context as DataContext, null).Count();
    }

This method gets the number of published articles. Instead of using this Table<Article>, what should I use instead?

Answer 1

Analog of Table<> (linq 2 sql) in EntityFramework is ObjectQuery

Answer 2

You probably need to use the ObjectQuery<T> class.

public static int GetPublishedArticlesCount(this ObjectQuery<Article> source)

Answer 3

As the previous poster metioned you could use ObjectQuery to get the result.

To make the method more generic as an extension method to ObjectQuery & get count of any type perhaps this might help:

public static int GetCount<T>(this ObjectQuery<T> query){
    return query.CreateQuery<T>(typeof(T).Name).Count();
}

NOTE: I am writing this code from top of my head, might has some sytax errors...

HTH.