asp.net mvc - How to pass collection of anonymous objects from controller to view -


I'm new to MVC, so please forgive me if my question seems silly or very simple. I am using an entity data model for So in my model folder, I've added an EDMX file and I can use model classes and strongly typed ideas from my controllers. The problem arises when I access more than one table in my controller like

If I have the following tables in my DB: 

  Departments (DepartmentID, DepartmentName, DepartmentPhone) Insurance (InsuranceID, InsuranceName, InsuranceAddress) Employee (EmployeeID, EmpFName, EmpLName, DepartmentID, InsuranceID)   
 And I want to display a list of employees with my department and insurance information.  
 In my controller action method I can access DB using EDM and get information in an anonymous type:  
 using  (above reference = new MyEntities ( )) {Var model = (reference.Departments in D.DepartmentID on d.DepartmentID is equivalent to joining e in context.Employees e.DepartmentID I.InsuranceID on context.Insurances to join e.InsuranceID new selection equal {DepartmentID = d.DepartmentID, EmployeeID = e.EmployeeID., EmpFName = e.EmpFName, EmpLName = e.EmpLName, DepartmentName = d.DepartmentName, InsuranceName = I.InsuranceName}) ToList (); See Return (Model); }   
 I do not have a class of this anonymous type in my model folder, so if I can not make a properly typed view, what is the best way to pass this list to see is? If the scene is huge then using the viewbag will be an overkill, it does not look right to create a new model for this anonymous class because if I change my selection in the Controllers Action Method, then it needs to be updated at all times.  
 All suggestions are welcome. I tried to look at the SO through other questions but nothing was found relevant.  
 Thank you.   
 
 
 
 I can not create a strongly typed view   
 Right click on your project, my class folder does not need a square of this anonymous type ... and now you have a type in your model folder. This ASP.Net MVC = & gt; There is a way to go in. See the model.  
 And then obviously you pass in your view like this:  
  select new MyViewModel (Department ID = D. DepartmentID, EmployeeID = e.EmployeeID, EmpFName = E .EmpFName, EmpLName = e.EmpLName, partition name = d.DepartmentName, InsuranceName = I.InsuranceName}). ToList ();   
 And of course, your view is now strongly typed on this visual model:  
  @modelIINMereble & lt; MyViewModel & gt; ...

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more