Dynamic LINQ - Knowledge Base (KB)
16 results in tag: vb.net
How can I make Lambda in LINQ filter for dynamic LINQ?
Example-I have a person class ...Public Class Person Private _fname As String Public Property Fname() As String Get Return _fname End Get Set(ByVal value As String) _fname = value End Set End Property Private _lname As Str...
asked by Eric
How can I go through an IList field by field?
I'm using the Dynamic LINQ library code sample to dynamically return some data. The number of columns I'm returning is variable depending on user input. I'm enumerating the IQueryable into an IList. ...What I need to do is step through the Ilist one field...
asked by Neberu
With Dynamic LINQ, how can I dynamically choose my Table at runtime?
I'm developing an application to allow engineers to conduct simple single table/view queries against our databases by selecting Database, Table, Fields....I get how to use the Dynamic LINQ Library Sample to provide for dynamically selecting the Select, Wh...
asked by Neberu
Need assistance with a LINQ query created using the Dynamic LINQ Library?
Forgive my ignorance on this. I have this LINQ Query: Dim ngBikersDataContext As New CarBikeWalkDataContext...bikersList = (From c In ngBikersDataContext.Reg_Bikers _ Order By c.L_Name _ Select New Bikers() ...
asked by Matt Porterfield
LINQ. Using dynamic queries to reduce code.
I use the following code to fill the Table1 dictionary with the information found within the LINQ query.... Dim DB As New DatabaseDataContext Dim Table1 As New Dictionary(Of String, Integer) Dim Table2 As New Dictionary(Of String, Integer) Priv...
asked by OrElse
The System and VB.NET Namespace Linq.Dynamic
I would use the ...System.Linq.Dynamic.......I added the specified ...Dynamic.vb... file, that starts like this :...Option Strict On Option Explicit On Imports System.Collections.Generic Imports System.Text Imports System.Linq Imports System.Linq.Express...
asked by serhio
LINQ is dynamic. The type 'ClassName' has no 'FieldName' property or field.
My LINQ query is as follows...Dim Query = From t In New XPQuery(Of xUser)(Xpo.Session.DefaultSession) .Where("Name=John").Select("new (Name as FirstName)") ...Unfortunately i get the error ...No property or field 'John' exists in type 'xUser'...Of course ...
asked by OrElse
LINQ Dynamic query nullable field
Suppose an SQL table 'employees' (containing a nullable datetime field called 'endDate')...static LINQ:...dim result = db.employees.where(function(c) not(c.endDate.hasValue)) ...Works perfectly!...dynamic LINQ:...dim result = db.employees.where("it.endD...
asked by zeSkunk
Linq Dynamic Error with Dynamic Where clause
I have a four dropdownlists that are used to filter/order a gridview....If any of the first 3 dropdowns have a selected value other than 0 the the WhereFlag is set to True. The fourth dropdown is used to dictate which column the grid is ordered by....My c...
asked by Mych
Query with dynamic where clause (concatenated array elements)
I have a dynamic array where the elements should filter elements (where clause) in a linq query. ...I use the ...System.Linq.Dynamic... Library mentioned in ...this questions... top answer. If I run:...Dim query = From element In dtImitate.Where("Team = "...
asked by ruedi
Using Dynamic Linq to set column name
I have a database that is a little inverted. For every project row, there are columns for different Engineers involved. (architect engineer, construction engineer, mechanical engineer). I need to get a list of projects that are assigned to one person. So ...
asked by kelseywhiting
How to GroupBy a part of DateTime using System.Dynamic.LINQ library
I have tables that contain a lot of rows, each record is excellent by whom and on what date was added. I want to group all records, based on AddedBy and AddedOn fields....The problem is that the dates are in full including the miliseconds and I only want ...
asked by Haim Tabak
Displaying Custom Fields in LINQ to Entity Dynamic Select
Let's say I have an entity ...Container... with four properties: ...ContainerID... (Integer), ...ContainerNumber... (String), ...Title... (String), and ...Date... (Date)....I have a second entity called ...ContainerCustomFields... that has three propertie...
asked by Nse
String concatenation in dynamic-linq Select
I'm trying to return a new column that is the concatenation of ...id... and ...name..., with a hyphen inbeween, using dynamic-linq:...query.Select("new(id, name, id & " - " & name As idName") ...But, I'm failing even to get simple concatenation working, e...
asked by isedwards
Dynamic Linq and generic objects - Public member 'Select' on type T not found
I'm trying to create a generic method that accepts a collection object, a string representation of the object's type, and a dictionary(of String,String) whose keys contain properties of interest....I want to then generate a dynamic linq query based on the...
asked by sasfrog
Dynamic join clause linq
Is it possible to build dynamic linq query. My problem is that the join conditions could be one to multiple. The number of fields to join changes for different scenarios.... dim data = (From drow As DataRow In dtDistinctRecords.Rows Join main...
asked by arjun