|
|
|
LINQ - Join by Using Composite Keys
|
|||
|---|---|---|---|
|
#18+
This example shows how to perform join operations in which you want to use more than one key to define a match. This is accomplished by using a composite key. You create a composite key as an anonymous type or named typed with the values that you want to compare. If the query variable will be passed across method boundaries, use a named type that overrides Equals and GetHashCode for the key. The names of the properties, and the order in which they occur, must be identical in each key Тем кто соединяет по двум и более полям прошу обратить на последнюю фразу! ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 10.04.2008, 16:21 |
|
||
|
LINQ - Join by Using Composite Keys
|
|||
|---|---|---|---|
|
#18+
круто, не знал, но сложновато конечно... ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 10.04.2008, 17:43 |
|
||
|
LINQ - Join by Using Composite Keys
|
|||
|---|---|---|---|
|
#18+
зыкруто, не знал, но сложновато конечно... А если это всё с группировкой то выглядит монстровидно! from c in RashNaklDtls group c by new { c.Partia.par_va_id, c.Partia.par_pk_id } into grp join arc in this.VariArtcs on grp.Key.par_va_id equals arc.va_id join pak in this.Packings on new { va = grp.Key.par_va_id, pk = grp.Key.par_pk_id } equals new { va = pak.pk_va_id, pk = pak.pk_id } orderby arc.va_articul, pak.pk_descr select с ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 11.04.2008, 15:58 |
|
||
|
|
start [/forum/topic.php?fid=17&msg=35249356&tid=1352322]: |
0ms |
get settings: |
10ms |
get forum list: |
20ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
83ms |
get topic data: |
13ms |
get forum data: |
4ms |
get page messages: |
59ms |
get tp. blocked users: |
2ms |
| others: | 243ms |
| total: | 442ms |
| 0 / 0 |
