Dynamic LINQ - Knowledge Base (KB)

Other databases using dynamic LINQ

Are there any free (gratis) providers for databases other MS SQL (e.g. MySQL or SQLite) that work with LINQ and support dynamic SQL query generation? E.g. ...table.Count()... generates something like ...SELECT COUNT(*) FROM table... and doesn't first load...

Instant execution of a dynamic query?

I am using the MSDN Dynamic linq to sql package. It allows using strings for queries....But, the returned type is an ...IQueryable... and not an ...IQueryable<T>.... I do not have the ...ToList()... method....How can I this immediate execute without manua...

How flexible can my LINQ To SQL statements be?

I have the need to construct a LINQ To SQL statement at runtime based on input from a user and I can't seem to figure out how to dynamically build the WHERE clause....I have no problem with the following:...string Filters = "<value>FOO</value>"; Where("Fo...

Issue with dynamic LINQ queries containing brackets

I'm using the Dynamic Linq Library (...this one...) in my .NET MVC application to query a SQL Server database. It's all working fine so far....However, the Dynamic Linq Library gives an "Expression expected" error whenever I use square brackets to designa...

Aggregate function Count() using dynamic linq query

I am trying to use ...Aggregate function...Count()... on some column using dynamic linq query but I am not able to achieve, what I am exactly looking is...Select Count(Id),Id from Table1 Group By Id Having Count(Id) > 1 ...I want to convert the same q...

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 ...

Dynamic linq syntax for subquery

I want to have the following query in Dynamic LINQ.. I have tried some solutions but have not succeeded yet. ... select SUM([Value1]) AS [Sum] ,[Dim1] AS [Primary], [Dim2] AS [Secondary] from ( SELECT value1...

Error When Querying For A Substring Using Dynamic Linq

I'm trying to use dynamic linq to obtain a subset of people from a database using Entity Framework (EF). I'm running into a problem when using the contains operation. Here is the entity for the People table:...public class Person { public string Id { ...

C# - Dynamic Linq left outer join on multiple properties

i want to do left outer join in ...Dynamic Linq..., but i can't get the syntax right. In SQL it would look like this:...SELECT col1, col2, col3 from tableA as a LEFT OUTER JOIN tableB as b on a.col1 = b.col1 AND a.col2 = b.col2 AND a.col3 = 1 ...In dynami...

Dynamic Linq for SQL MIN() function

Original SQL looks like:...SELECT MIN(ID) AS GeoID, MIN(PostalCode), PlaceName FROM GeoData_ALL GROUP BY CountryCode, PlaceName ORDER BY PlaceName ...I need to translate it in Dynamic Linq, something like:...var searchResult = db.Set(GeoData) ...

System.Linq.Dynamic - use SELECT inside WHERE statement

I need to generate SQL query dynamically using System.Linq.Dynamic like this:...SELECT [Extent1].[FromRevision] AS [FromRevision], [Extent1].[Field1] AS [Field1], [Extent1].[TillRevision] AS [TillRevision], [Extent1].[Field2] AS [Field...

Dynamic library (System.Linq.Dynamic) SQL LIKE Operator

Someone has posted a similar question here ...How Dynamic library (System.Linq.Dynamic) support LIKE Operator?...But it's not exactly what I want. The ...Contains... operator mentioned in that post only do this in SQL ..."%SOMETHING%".... But the ...LIKE....

Using Contains within Where for a list

So I am trying to retrieve results from a collection based on a property. I wanna get any results that hold that value within the list. ...This is my code...I have tried with dynamic linq. It's not working...This is dynamic linq. Not working ...var list =...