zzz projects Dynamic LINQ
Home Getting Started Knowledge Base Online Examples  GitHub
  • Home
  • Getting Started
  • Knowledge Base
  • Online Examples
  •  GitHub
  •   Download  

Dynamic LINQ - Knowledge Base (KB)

13 results for: in tag: sql

Dynamic LINQ with other databases

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...
dynamic-linq linq sql
asked by svick

Dynamic query to immediate execute?

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...
dynamic-linq linq sql
asked by Curtis White

How dynamic can I make my LINQ To SQL Statements?

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...
.net-3.5 c# dynamic-linq linq-to-sql sql
asked by mcass20

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...
.net dynamic-linq linq sql sql-server
asked by Chris

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...
c# dynamic-linq linq linq-to-entities sql
asked by Abhinay

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 ...
c# dynamic-linq expression-trees sql
asked by Andreas Zita

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...
c# dynamic-linq linq linq-to-sql sql
asked by JohanLarsson

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 entity-framework linq sql
asked by Halcyon

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...
c# dynamic-linq linq sql
asked by Oktay Myumyunov

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) ...
dynamic-linq linq sql
asked by Luke

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...
c# dynamic-linq linq sql
asked by Artem Makarov

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....
c# dynamic-linq linq sql
asked by Kevin Man

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 =...
c# dynamic-linq entity-framework-core linq sql
asked by Gilberto Langarica

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...