Expression Tree Tutorial - Knowledge Base (KB)

Entity Framework Hitting 2100 Parameter Limit

I'm migrating some of our code from LINQ-to-SQL to Entity Framework. Previously, when run up against a 2100 parameter limit from SQL Server (described ...here...), I used the solution provided by Marc Gravell ...here.... As stated in his own response, it ...

Convert LINQ Expression to SQL Text without DB Context

Either LINQ to SQL or LINQ to Entities already have the ability to convert LINQ into a SQL text string. But I want my application to make the conversion without using the db context - which in turn means an active database connection - that both those pr...

Dynamic Linq query on relationship with foreign key of type Guid

I'm using ...System.Linq.Dynamic... to query an IQueryable datasource dynamically using a where-clause in a string format, like this:...var result = source.Entities.Where("City = @0", new object[] { "London" }); ...The example above works fine. But now I ...

Benefits of LINQ over functional method chaines

There was a discussion on Kotlin Slack about a possibility of adding code trees to support things like C# LINQ....In C# LINQ has many applications, but I want to focus on only one (because others a already presumably covered by Kotlin syntax): composing S...