Dynamic LINQ - Knowledge Base (KB)
39 results in tag: linq-to-sql
Column names are provided at runtime in LINQ's dynamic where clause.
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...
asked by sandesh247
Entities are being injected without using.InsertOnSubmit(...) in DLINQ?
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...
asked by Charles
Authorization in ASP.NET MVC 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...
asked by tvanfosson
Using Combobox Values to Create Dynamic LINQ Queries
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...
asked by Steve G.
How can I use LINQ to SQL to provide a table name at runtime?
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...
asked by AndreMiranda
Use a dynamic class to access a Linq result.
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...
asked by sipwiz
LINQ Return the maximum value in a specified column using a query or stored procedure.
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 ...
asked by user132322
In Asp.net MVC, create a dynamic query using Linq and a drop down list chosen option.
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...
asked by AndreMiranda
SQL Convert Function in the Dynamic LINQ API
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 = ...
asked by Overhed
With Dyanmic Linq, you can handle a dynamic select.
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...
asked by CleverPatrick
Different failures based on the object supplied as a parameter when using Dynamic Linq?
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...
asked by SventoryMang
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...
asked by mcass20
Which of these evolved from DLinq: Linq to SQL or 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?...
asked by Water Cooler v2
LINQ-to-SQL dynamic table name LINQ-to-SQL
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 ...
asked by Muhammad Adeel Zahid
Multiple where clauses at runtime with Linq to SQL
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...
asked by SetiSeeker
In EF, use OrderBy with Dynamic Linq and a one-to-many connection.
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...
asked by Julien
Dynamic linq against a non-dbml object
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 ...
asked by madcapnmckay
How does the Array operator work with DynamicQueryable?
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...
asked by jedatu
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
Build a where clause for ORs (||) in LINQ at runtime?
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...
asked by Martin
Page 1 of 2