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?

Simon P Stevens · Accepted Answer · 2010-03-21 12:39:53Z

2

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

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

answered Mar 21, 2010 at 12:39

Simon P Stevens

27.5k5 gold badges86 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

EgorBo · Accepted Answer · 2010-03-21 12:36:19Z

1

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

answered Mar 21, 2010 at 12:36

EgorBo

6,1723 gold badges37 silver badges40 bronze badges

Comments

Sunny · Accepted Answer · 2010-03-21 13:00:42Z

0

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.

answered Mar 21, 2010 at 13:00

Sunny

6,3462 gold badges27 silver badges27 bronze badges

Collectives™ on Stack Overflow

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

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related