As Brannon says, it’s OrderByDescending and ThenByDescending: var query = from person in people orderby person.Name descending, person.Age descending select person.Name; is equivalent to: var query = people.OrderByDescending(person => person.Name) .ThenByDescending(person => person.Age) .Select(person => person.Name);
It is not about closing connection. EF manages connection correctly. My understanding of this problem is that there are multiple data retrieval commands executed on single connection (or single command with multiple selects) while next DataReader is executed before first one has completed the reading. The only way to avoid the exception is to allow … Read more
Slicing a list top5 = array[:5] To slice a list, there’s a simple syntax: array[start:stop:step] You can omit any parameter. These are all valid: array[start:], array[:stop], array[::step] Slicing a generator import itertools top5 = itertools.islice(my_list, 5) # grab the first five elements You can’t slice a generator directly in Python. itertools.islice() will wrap an object … Read more
The easiest way to solve the problem is to group the elements based on their value, and then pick a representative of the group if there are more than one element in the group. In LINQ, this translates to: var query = lst.GroupBy(x => x) .Where(g => g.Count() > 1) .Select(y => y.Key) .ToList(); If … Read more
There is no ForEach extension for IEnumerable; only for List<T>. So you could do items.ToList().ForEach(i => i.DoStuff()); Alternatively, write your own ForEach extension method: public static void ForEach<T>(this IEnumerable<T> enumeration, Action<T> action) { foreach(T item in enumeration) { action(item); } }
This should work for you: var movies = _db.Movies.OrderBy(c => c.Category).ThenBy(n => n.Name)