Databases
StackOverflow2013
Postsdbo
POLINQ join and orderby issues
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLINQ join and orderby issues
    primarykey
    data
    text
    <p>OK, I've been banging my head against this for a few days, and after studying LINQ I think I am on the right track. But I have a SQL brain and that is sometimes hard to translate to C#.</p> <p>I have two arrays, one sorted alphabetically, and the other ordered by ID. I need to order the second array alphabetically. The IDs are the joining factor. I.E. A.ID = P.ID.</p> <p>Here are my arrays and example values;</p> <pre><code>private IGenericListItem[] _priceLevels = new IGenericListItem[0]; _priceLevels is in the form of {ID, Name} {3, A} {8, B} {4, C} {7, D} {5, E} {9, F} {1, G} </code></pre> <p><strong>Edit:</strong> updated this to show _assignmentControls contains a sub array. I didn't make it so excuse the insanity. It actually contains a copy of _priceLevels...</p> <pre><code>protected ArrayList _assignmentControls = new ArrayList(); _assignmentControls is in the form of {ID, LastPrice, NewPrice, _priceLevels[]} {1, 1.00, 2.00, _priceLevels} {2, 1.00, 2.00, _priceLevels} {3, 1.00, 2.00, _priceLevels} {4, 1.00, 2.00, _priceLevels} </code></pre> <p>Part of the problem as that I'm trying to compare/join an ArrayList and an IGenericListItem.</p> <pre><code>In SQL I would do something like this; SELECT A.* FROM _assignmentControls A JOIN _priceLevels P ON A.ID = P.ID ORDER BY P.Name </code></pre> <p>This Returns me an _assignmentControls table sorted by the values in _priceLevels.</p> <p>In C# LINQ I got this far, but can't seem to get it right;</p> <pre><code> var sortedList = from a in _assignmentControls join p in _priceLevels on a equals p.ID orderby p.Name select _assignmentControls; </code></pre> <p>I am getting red squigglies under join and orderby and the p in p.Name is red. And A) it doesn't work. B) I'm not sure it will return sortedList as a sorted version of _assignmentControls sorted by _priceLevels.Name.</p> <p>EDIT: When I hover over "join" I get "The type arguments for the method 'IEnumerable System.Linq.Enumerable.Join(this Enumerable,IEnumerable, Func,Func....'cannot be infered from the query. I am researching that now.</p> <p>Thanks for looking!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBClaydon
    1. USBClaydon
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POLINQ join and orderby issues
      1. This table or related slice is empty.
      1. VTUpMod
    1. COChange `a` in the join to `a.ID`.
      singulars
      1. POLINQ join and orderby issues
      1. USIt'sNotALie.
    2. CO@newStackExchangeInstance - I changed to: join p in _priceLevels on a.ID equals p.ID and the a in a.ID is now red too. That confuses me because I should be able to reference that field of the ArrayList.
      singulars
      1. POLINQ join and orderby issues
      1. USBClaydon
    3. COI think you need select a at the end
      singulars
      1. POLINQ join and orderby issues
      1. USOleksii Aza
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload