What about this? double[] v = Enumerable.Repeat(x, n).ToArray(); EDIT: I just did a small benchmark; to create 1000 arrays of 100000 elements each, using a loop is about 3 times faster that Enumerable.Repeat. Repeat 00:00:18.6875488 Loop 00:00:06.1628806 So if performance is critical, you should prefer the loop.
Try this. Not sure why you need the second doc. foreach (XElement xe in doc.Descendants(“Profile”)) { MessageBox.Show(xe.Element(“username”).Value); }
Another option is using SqlFunctions.DateName, your code will be like this: var offer = (from p in dc.CustomerOffer join q in dc.OffersInBranch on p.ID equals q.OfferID where q.BranchID == singleLoc.LocationID let value = (p.OriginalPrice – p.NewPrice) * 100 / p.OriginalPrice orderby value descending select new { Title = p.OfferTitle, Description = p.Description, BestOffer = value, … Read more
To ignore case and accents (diacritics) you can first define an extension method like this: public static string RemoveDiacritics(this String s) { String normalizedString = s.Normalize(NormalizationForm.FormD); StringBuilder stringBuilder = new StringBuilder(); for (int i = 0; i < normalizedString.Length; i++) { Char c = normalizedString[i]; if (CharUnicodeInfo.GetUnicodeCategory(c) != UnicodeCategory.NonSpacingMark) stringBuilder.Append(c); } return stringBuilder.ToString(); } (Modified … Read more
You’re overestimating the power of LINQ translation to SQL. Not everything is translatable and there is no compiler warning for that due to the way LINQ works. Nested collections are usually either a) not supported or b) end up in horrible SELECT N+1 queries. What you ask EF to do is to return an object … Read more
As you are selecting the property, just get the value of the nullable: List<int> lst = Orders.Where(u => u.SplOrderID != null) .Select(u => u.SplOrderID.Value) .ToList();
To understand the “display class” you have to understand closures. The lambda you pass here is a closure, a special type of method that magically drags in state from the scope of the method it’s in and “closes around” it. …except of course that there’s no such thing as magic. All that state has to … Read more
With Linq2Sql dc.GetCommand(query).CommandText see http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.getcommand.aspx for more info. But I usually use LinqPad
Use EntityFunctions.TruncateTime Method (Nullable<DateTime>). It will be transalated into TRUNCATETIME() TSQL function in generated SQL query, which does what you need: Returns the expression, with the time values truncated. So your code should be as follows: //get data var myData = from log in db.OperationLogs group log by EntityFunctions.TruncateTime(log.CreateTime) into g orderby g.Key select new … Read more
You have two options: Project to a string and then aggregate: var values = new[] { new { Key = “MyAge”, Value = 33.0 }, new { Key = “MyHeight”, Value = 1.75 }, new { Key = “MyWeight”, Value = 90.0 } }; var res1 = values.Select(x => string.Format(“{0}:{1}”, x.Key, x.Value)) .Aggregate((current, next) => … Read more