Using LINQ query in model (MVC)

Question

I am creating a web application, is it possible to use LINQ queries in the Model ,instead of using it in the Controller?

Thanks

Do you mean at view? Because the model is a class you pass to it. It just keeps data not more. Nevertheless you are not restricted from using LINQ anywhere you want as it's just a set of extension methods. — ILya
– ILya, Commented May 31, 2012 at 8:34
you can use it in any class. But in my oppinion, using any manipulations on data inside of model class is a bad design decision almost in every case — ILya
– ILya, Commented May 31, 2012 at 8:38
@ILya: only if you are using anemic models. Nothing prevents you from encapsulating model-specific logic in the model. It's a class not a data storage unit. — SWeko
– SWeko, Commented May 31, 2012 at 9:10

Obsivus · Accepted Answer · 2012-05-31 09:14:11Z

2

I would recommend you to use your LINQ queries in repository class.

Then you use your Repository methods inside your controller.

Lets say I have a repository class by the name of "CreateRepository" and this is my Createcontroller:

 public class CreateController : Controller
    {
        CreateRepository CreateRepository = new CreateRepository();

        public ActionResult Index()
        {
            var ListOfAllUserNames = CreateRepository.GetAllUserNames();

            // etc etc 
            return View();
        }

And this is my CreateRepository Class:

public class CreateRepository
 {   

   public List<User> GetAllUserNames()
       {
          return db.User.OrderBy(f => f.Username).ToList();
       }
 }

This is a example on what I mentioned above.

answered May 31, 2012 at 9:14

Obsivus

8,36913 gold badges57 silver badges98 bronze badges

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

1 Comment

user20072008 Over a year ago

Your answer make more sense.

Anas · Accepted Answer · 2012-05-31 08:47:05Z

1

Yes you can use LINQ queries in the model.

Here is an example :

using System.Linq;
using System.Linq.Expressions;
.
.
.
public class PostRepository
{
    DataClassesDataContext db = new DataClassesDataContext();

    public IQueryable<Post> FindByParentId(int parentId)
    {
        return from post in db.Posts
               where post.ParentID == parentId
               select post;
    }

edited May 31, 2012 at 8:47

answered May 31, 2012 at 8:34

Anas

5,7455 gold badges43 silver badges72 bronze badges

4 Comments

Chris Over a year ago

@user841852: LINQ queries are no different in a model than in any other code. Any example of a linq query will work in a model as well as in a controller or view or windows app or anything else...

ILya Over a year ago

And how repository is related to the model?

user841852 Over a year ago

@ssx What is IPostRepository here?

Anas Over a year ago

@user841852 it's an interface, but you can just skip it for the example

Collectives™ on Stack Overflow

Using LINQ query in model (MVC)

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related