Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations. Closed 3 years ago. Improve this question Overview One of the things I’ve … Read more
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … Read more
This may be a really elementry question but whats a nice way to include multiple children entities when writing a query that spans THREE levels (or more)? i.e. I have 4 tables: Company, Employee, Employee_Car and Employee_Country Company has a 1:m relationship with Employee. Employee has a 1:m relationship with both Employee_Car and Employee_Country. If … Read more
I am trying to use LINQ to create a Dictionary<string, List<CustomObject>> from a List<CustomObject>. I can get this to work using “var”, but I don’t want to use anonymous types. Here is what I have var x = (from CustomObject o in ListOfCustomObjects group o by o.PropertyName into t select t.ToList()); I have also tried … Read more
I know in normal Linq grammar, orderby xxx descending is very easy, but how do I do this in Lambda expression? 6 Answers 6
I am using Entity Framework and occasionally i will get this error. EntityCommandExecutionException {“There is already an open DataReader associated with this Command which must be closed first.”} at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands… Even though i am not doing any manual connection management. this error happens intermittently. code that triggers the error (shortened for ease of reading): if … Read more
Using LINQ, from a List<int>, how can I retrieve a list that contains entries repeated more than once and their values? 11 Answers 11 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 … Read more
I’d like to do the equivalent of the following in LINQ, but I can’t figure out how: IEnumerable<Item> items = GetItems(); items.ForEach(i => i.DoStuff()); What is the real syntax? 22 s 22 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 … Read more
I have two tables, movies and categories, and I want to get an ordered list by categoryID first and then by Name. The movie table has three columns ID, Name and CategoryID. The category table has two columns ID and Name. I tried something like the following, but it didn’t work. var movies = _db.Movies.OrderBy( … Read more
