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)

39 results for: in tag: linq-to-sql

Dynamic where clause in LINQ - with column names available at runtime

Disclaimer: I've solved the problem using Expressions from System.Linq.Expressions, but I'm still looking for a better/easier way....Consider the following situation :...var query = from c in db.Customers where (c.ContactFirstName.Contains("Black...
.net dynamic-linq linq-to-sql
asked by sandesh247

DLINQ- Entities being inserted without .InsertOnSubmit(...)?

I ran into an interesting problem while using DLINQ. When I instantiate an entity, calling .SubmitChanges() on the DataContext will insert a new row into the database - without having ever called .Insert[All]OnSubmit(...)....//Code sample: Data.NetServic...
dynamic-linq insertonsubmit linq-to-sql submitchanges
asked by Charles

ASP.NET MVC Authorization based on role membership or data relation (ownership)

I'd like to extend the AuthorizeAttribute in ASP.NET MVC so that it supports the concept of a user's authorization being based on their role membership OR "ownership" of the data in question. I'm using LINQ2SQL for data access. There is a similar question...
asp.net-mvc attributes dynamic-linq linq-to-sql reflection
asked by tvanfosson

Building Dynamic LINQ Queries based on Combobox Value

I have a combo box in Silverlight. It has a collection of values built out of the properties of one of my LINQ-to-SQL objects (ie Name, Address, Age, etc...). I would like to filter my results based off the value selected in a combo box. ...Example: Say...
dynamic-linq linq linq-to-sql silverlight
asked by Steve G.

How can I supply a table name at runtime using LINQ to SQL?

I have to use LINQ to SQL and along with it a pure SQL classic query. And this SQL query has the Table from where my data will be generated, but I will not know this Table previously. It will be known in compile time....So how can I make LINQ understand f...
dynamic-linq linq-to-sql
asked by AndreMiranda

Access Linq result contained in a dynamic class

I'm using DbLinq which should be the equivalent of Linq2SQL for this question. I'm need to generate a Linq2SQL query where I specify the columns I want returned at runtime. I can achieve that using the Dynamic Linq extension methods but I can't work out h...
c# dynamic-linq linq linq-to-sql
asked by sipwiz

LINQ Query or stored procedure to return max value in a stated column

Table like ...datetime a1 b1 x2 ... 07-01-2009 13:10 8 9 10 07-01-2009 13:11 8 8 2 07-01-2009 13:12 9 1 1 ...1 row per second for a whole day (=86400 rows); ~40 columns; all same format... I'm looking for a ...
dynamic-linq linq-to-sql stored-procedures
asked by user132322

Make a dynamic query with Linq using a drop down list selected option in Asp.net MVC

I'm trying to accomplish this with Linq to Sql and Asp.Net MVC: ...I have a Drop Down List with options Country, City and State. And beside it, there is a textbox. So, an user will, for instance, select City and will type "new york city" in the textbox an...
asp.net-mvc dynamic-linq linq-to-sql
asked by AndreMiranda

Dynamic LINQ API - SQL Convert Function

I'm trying to use a Dynamic LINQ Query to query a SQL database, and in the Where clause I need to evaluate an '=' condition with a field that is of type TEXT....Right now, I've got this:...var result = DBCon.PcInValue .Where(String.Format("InputName = ...
c# dynamic-linq linq linq-to-sql
asked by Overhed

Handle a Dynamic Select With Dyanmic Linq

I am using the Dynamic Linq Library that Scott Guthrie describes ...here.... ...Scott Guthrie's examples are great and I have used the dynamic Where statements quite a bit. ...Now, however, I am faced with a situation where I need to use the dynamic se...
c# dynamic-linq linq linq-to-sql
asked by CleverPatrick

Dynamic Linq help, different errors depending on object passed as parameter?

I have an entityDao that is inherbited by everyone of my objectDaos. I am using Dynamic Linq and trying to get some generic queries to work....I have the following code in my generic method in my EntityDao :...public abstract class EntityDao<Implementatio...
dynamic-linq generics linq linq-to-sql where-clause
asked by SventoryMang

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

DLinq morphed into which one -- Linq to SQL or the Entity Framework?

What happened to Dlinq? I heard a few years ago that it was abandoned....Was some of its code used to create Linq to SQL or the ADO.NET Entity Framework? Which one? In other words, which of the two latter technologies are a new avatar of the old DLinq?...
ado.net-entity-data-model dynamic-linq entity-framework entity-framework-4 linq-to-sql
asked by Water Cooler v2

Dynamic table name linq-to-sql dynamic LINQ

I want to construct my query dynamically based on the contents user has selected, and I want to do this in LINQ-t0-SQL. I have seen ...this..., but I don't want to use SQL statements with datacontext....On Googling a bit I have a feeling that this can be ...
dynamic-linq linq-to-sql
asked by Muhammad Adeel Zahid

Linq to SQL - Multiple where clauses at runtime

I am trying to accomplish this but only my first where clause is getting used when the query runs....This needs to for for .Net 3.5 so the WhereIf in 4.0 is not usable....var query = from tb in dataContext.TableOne where tb.DateTimeCreated >= from...
c# dynamic-linq linq-to-sql where-clause
asked by SetiSeeker

OrderBy with Dynamic Linq and one to many relationship in EF

I'd like to implement a module for filtering and paging. I understand that to suceed I had to use Dynamic Linq or Reflection, so I started trying to make it work .. but since the field that contains the text to be filtered in a one to many relationship EF...
c# dynamic-linq linq linq-to-entities linq-to-sql
asked by Julien

Dynamic linq against entity not in dbml

I have been asked to investigate the usefulness of linq to sql for a reporting application we are building. Our reporting table is a sql server wide table with many thousands of columns of different types (String1-500, Int1-500 etc). It holds the results ...
dynamic-linq expression-trees linq-to-sql
asked by madcapnmckay

How does DynamicQueryable support the Array operator?

I have been using the DynamicQueryable Linq extensions featured in Scott Guthrie's ...blog post.......The documentation has a table of supported operators. One of the primary operators is the following:...x[…]... Array or indexer access. Multi-dimens...
dynamic-linq linq linq-to-sql
asked by jedatu

How can I dynamically select my Table at runtime with Dynamic LINQ

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...
dynamic-linq linq linq-to-sql vb.net
asked by Neberu

LINQ: Build a where clause at runtime to include ORs ( || )?

I need to build a where clause at runtime but i need to do an OR with the where clause. Is this possible .. Let me explain.....here my code..., basically "filter" is a enum Bitwise, son hence filter could be equal to more than 1 of the following.. Hence i...
dynamic-linq linq linq-to-sql
asked by Martin

Page 1 of 2
  • 1
  • 2
  • »

Prime Library

Performance

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

Expression Evaluator

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