Can not query linq to sql in the Views of asp.net MVC C#

Question

I want to query the user that log in success in the web site :

This is what I did in my views :

var query = from i in Model.DataContext.Customers
            where i.WebAccount == User.Identity.Name
            select i;

But it show the error Object reference not set to an instance of an object, I have no idea , why it is like that. Any one know about that? Thanks.

Phil Klein · Accepted Answer · 2011-12-17 03:22:41Z

2

There are a couple issues to discuss.

You should not be querying your database from the View. Logic remains in the Controller.
You likely never set the DataContext property on your view model. The message stating that the "object reference not set to an instance of an object" pertains to a NullReferenceException which means you're attempting acces on a null value.
See #1 again, it's important.

answered Dec 17, 2011 at 3:22

Phil Klein

7,5143 gold badges34 silver badges33 bronze badges

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

1 Comment

Nothing Over a year ago

So what can I avoid to do that in my view?

jim tollan · Accepted Answer · 2011-12-17 13:57:06Z

1

socheata,

there's a very good chance that your User.Identity object could be null if the user has not yet signed in (thus the User.Identity.Name invocation would throw an error).

So, there are several approaches that spring to mind:

move that logic out of the view and into either your service layer or your controller action
create an html helper that provides the functionality that you require from the view. useful if this is required across multiple views

there are of course other options, but these would be my starting point.

answered Dec 17, 2011 at 13:57

jim tollan

22.5k4 gold badges53 silver badges64 bronze badges

Collectives™ on Stack Overflow

Can not query linq to sql in the Views of asp.net MVC C#

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related