Dynamic LINQ - Knowledge Base (KB)
39 results 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...
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...
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...
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...
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...
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...
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 ...
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...
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 = ...
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...
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...
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...
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?...
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 ...
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...
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...
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 ...
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...
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...
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...
asked by Martin
Page 1 of 2