2

Suppose I want to fetch data into an anonymous object (i.e. fetch data from two or more tables and store it in a variable) at some part of my application development with a Linq to Entity query. Later I need a Razor View to access this fetched/anonymous data. What should I do here?

What I think is to design another ViewModel that holds corresponding properties of the anonymous type properties and make view/razor which is strongly typed to that ViewModel? Is this the right way to work with anonymous types in EF 4.1? i.e for each anonymous type make an ViewModel and store Fetched data into object of it.

Tom Haigh
  • 57,217
  • 21
  • 114
  • 142
RollerCosta
  • 5,020
  • 9
  • 53
  • 71
  • That would be the way I'd go; if you had to grab columns from specific tables. Typically I will create a View in the database (MSSQL, MySQL) if I need to access this data a lot and a corresponding model class. – kamranicus Jan 09 '12 at 05:30

1 Answers1

4

An Anonymous type isn't intended for use outside the scope of the method so they are usually just disposable types which would only be ever used in that method.

I would favour loading the data into a regular class over a ViewModel to fully separate the Model from the Views. I would use a custom class to hold the fetched data and then in the Controller populate the ViewModel with that class and have a razor view strongly typed to the ViewModel. This is a little less compact but has better separation of concerns.

Judo
  • 5,167
  • 3
  • 24
  • 34
  • Judo that is what i m asking. i.e Is this a good approach to work if you want to work with data fetched from two or more table.??? – RollerCosta Jan 09 '12 at 06:12
  • Yes this is a good approach in my opinion, regardless of the number of tables. The number of tables data is fetched from isn't that relevant. – Judo Jan 09 '12 at 06:26