I don’t know if it will help, but you can try something like this; var result = (from o in table1 join t in table2 on o.ProgramID equals t.ProgramID orderby t.Program select new { o.ProgramID, t.Program }).Distinct();
Interestingly, this has been identified for several versions now (you stated that a 3.5 issue was fixed in 4.0). Here is a post from 2007. The rest of the IList methods in 4.0 are correctly tied to the IList<T> methods. I think that there are 2 likely explanations (of the bug/feature variety): This is an … Read more
If you’re absolutely sure your numbers will always stay within the range of smallmoney, use that and you can save a few bytes. Otherwise, I would use money. But remember, storage is cheap these days. The extra 4 bytes over 100 million records is still less than half a GB. As @marc_s points out, however, … Read more
If you express it as a where clause it may just work out of the box with LINQ to SQL, if you can construct an appropriate expression. There may be a better way of doing this in terms of the expression trees – Marc Gravell may well be able to improve it – but it’s … Read more
This is what I found seems like you still have to do a group by…can just use constant: var orderTotals = from ord in dc.Orders group ord by 1 into og select new { prop1 = og.Sum(item=> item.Col1), prop2 = og.Sum(item => item.Col2), prop3 = og.Count(item => item.Col3) }; This produces the following SQL, which … Read more
Here is the answer! The Dynamic Linq does support the . operator, According to the docs: “Instance field or instance property access. Any public field or property can be accessed.” Thus, it is possible to use this syntax .Where(“MyColumn.Contains(@0)”, myArray) Thanks for all the suggestions! And thanks to me for finding the solution.
I believe it is an issue of covariance or contravariance as noted by this forum post. See Covariance and Contravariance in C#, Part Two: Array Covariance and the rest of the Covariance and Contravariance series at Eric Lippert’s blog. Although he is dealing with Arrays in the article I linked, I believe a similar problem … Read more
Reverse fits well here: ls.SelectMany(l =>l.Split(‘-‘).Reverse().Skip(1).Take(1).DefaultIfEmpty()) I also use SelectMany to transform IEnumerable<IEnumerable<string>> to <IEnumerable<string>.
You could use the EntityFunctions.DiffDays method EntityFunctions.DiffDays(product.EventDate, DateTime.Now) //this will return the difference in days UPDATE EntityFunctions is now obsolete so you should use DBFunctions instead. System.Data.Entity.DbFunctions.DiffDays(product.EventDate, DateTime.Now)
You have to execute your method call in Linq-to-Objects context, because on the database side that method call will not make sense – you can do this using AsEnumerable() – basically the rest of the query will then be evaluated as an in memory collection using Linq-to-Objects and you can use method calls as expected: … Read more