contacts.ForEach(c => { c.ID = 0; c.GroupID = 0; c.CompanyID = 0; }); It doesn’t have anything to do with LINQ per se; it’s just a simple anonymous method written in lambda syntax passed to the List<T>.ForEach function (which existed since 2.0, before LINQ).
You don’t need to use LINQ, you can use FindIndex of List<T>: int index = customers.FindIndex(c => c.ID == 150);
This should work for you //Retrieve Minimum Date var MinDate = (from d in dataRows select d.Date).Min(); //Retrieve Maximum Date var MaxDate = (from d in dataRows select d.Date).Max(); (From here)
LINQ is a query tool (Q = Query) – so there is no magic LINQ way to update just the single row, except through the (object-oriented) data-context (in the case of LINQ-to-SQL). To update data, you need to fetch it out, update the record, and submit the changes: using(var ctx = new FooContext()) { var … Read more
LINQ and QueryOver are completely different query methods, which are added to the ones that existed in NHibernate 2 (Criteria, HQL, SQL) QueryOver is meant as a strongly-typed version of Criteria, and supports mostly the same constructs, which are NHibernate-specific. LINQ is a “standard” query method, which means the client code can work on IQueryable … Read more
So, you can use the extension method syntax, which would involve one lambda expression more than you are currently using. There is no let, you just use a multi-line lambda and declare a variable: var results = Stores.Where(store => { var averagePrice = store.Sales.Average(s => s.Price); return averagePrice > 250 && averagePrice < 500; }); … Read more
Try something like this: var user = (from u in dc.Users where u.UserName == usn select u).FirstOrDefault(); The FirstOrDefault method returns the first element of a sequence that satisfies a specified condition or a default value if no such element is found.
mockInvoice.VerifySet(x => x.InvoiceAttachmentId = 123, Times.Once()); Replace 123 with the expected value. If you want to permit any value, use: mockInvoice.VerifySet(x => x.InvoiceAttachmentId = It.IsAny<int>(), Times.Once());
The new Linq provider does it a little differently: var customers = session.Query<Customer>().Fetch(c => c.Orders).ToList(); More here: http://mikehadlow.blogspot.com/2010/08/nhibernate-linq-eager-fetching.html
Update/delete from the EDMX is not always functional. If the model doesn’t get updated on clicking Update Model from Database let’s say when you have updated a view/table in the DB, do the following: 1) Delete the view/table from the model diagram 2) Switch the EDMX to xml view (right click the edmx file and … Read more