Tuesday 15 April 2014

entity framework - joining a table with more than one field in same table -


I try to create queries contained in Linq I want to be included in more than one field from a table

Table Please see your code below. roles = (_orderRepository.Table in the clients from the ords in _customerRepository.Table is equivalent to joining on ords.CustomerId is joining the ordprvrnts in _orderProductVariantRepository.Table on customers.Id ords.Id Similar entries are included in the prodvnn_productVariantRepository in prdvrnts.Ordprvrnts.ProductVariantId test equals prdvrnts.Id ** join cstevntrle in _customerEventRoleRepository.New {customers.Id equal cstevntrle.CustomerId} and new {cstevntrle.EventId ==} Model Event} ** Ordered Customers. Selecting New Emails Haq Aventrols model {customer = customer.email, CUstomerId = customers.Id});

I try to filter customerEventRoleRepository.Table with customer ID and eventID

How can I do this in the question of joining?

Please help.

You have a Boolean comparison in your anonymous type definitions ...

Section of the following:

  join cstevntrle in _customerEventRoleRepository.Table on new {customer ID = customers.Id, eventID = model.Event.EventId} new {customer ID = cstevntrle.CustomerId, EventID = cstevntrle .eventId}   

I do not see "models" defined anywhere, so I'm not sure it's going to work, but it should be enough to show that How many fields Works on the basis of - There are farms from one "side" to join each anonymous class.

No comments:

Post a Comment