Another way could be like var query = (from x in context.table1 join y in context.table2 on new { Key1 = x.col1, Key2 = x.col2, Key3 = true, Key4 = true } equals new { Key1 = y.key1, Key2 = y.key2, Key3 = y.from_date< DateTime.Now, Key4 = !y.deleted } into result from r in result.DefaultIfEmpty() … Read more
Well, I do not agree that the injection is not possible in Dynamic Linq. What described in the answer by Ɖiamond ǤeezeƦ is correct but appies to standard Linq as constructed within the given language – C# or VB.Net or by calling extension methods like .Where with lambda functions. Then, true, it is not possible … Read more
This can be done, as mentioned, with the help of Reflection Emit and a helper class I’ve included below. The code below is a work in progress, so take it for what it’s worth… ‘it works on my box’. The SelectDynamic method class should be tossed in a static extension method class. As expected, you … Read more
A query with includes returns a single result set and the number of includes affect how big data set is transfered from the database server to the web server. Example: Suppose we have an entity Customer (Id, Name, Address) and an entity Order (Id, CustomerId, Date). Now we want to query a customer with her … Read more
If you are using EF 6.0+, you can use DbFunctions.TruncateTime(DateTime?) : var query = from t in context.Logs where t.Title == title && DbFunctions.TruncateTime(t.Timestamp) == LogDate.Date select t; Note: For earlier version of EF where DbFunctions isn’t available, EntityFunctions.TruncateTime(DateTime?) can be used instead.
If you are using an in-memory collection as your filter, it’s probably best to use the negation of Contains(). Note that this can fail if the list is too long, in which case you will need to choose another strategy (see below for using a strategy for a fully DB-oriented query). var exceptionList = new … Read more
I ran across the same error, the issue seemed to be when I had predicates made with PredicateBuilder that were in turn made up of other predicates made with PredicateBuilder e.g. (A OR B) AND (X OR Y) where one builder creates A OR B, one creates X OR Y and a third ANDs them … Read more
Use the class DbFunctions for trimming the time portion. using System.Data.Entity; var bla = (from log in context.Contacts where DbFunctions.TruncateTime(log.ModifiedDate) == DbFunctions.TruncateTime(today.Date) select log).FirstOrDefault(); Source: http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/84d4e18b-7545-419b-9826-53ff1a0e2a62/
I would guess that EF doesn’t support the overload of StartsWith that takes a StringComparison parameter. It should support StartsWith, EndsWith and Contains, so maybe you can try: dp.LastName.StartsWith(searchTerm) or: dp.LastName.ToLower().StartsWith(searchTerm) and then make sure that searchTerm is also lowercase.
For all the “Linq-to-SQL is dead” folks: Scott Guthrie himself clearly mentioned at TechEd Europe that Linq-to-SQL is FULLY SUPPORTED in .NET 4, and Damien Guard posted a blog post on what changes and improvements have been made for Linq-to-SQL in .NET 4. To quote Mark Twain: “Reports of my death have been greatly exaggerated”……