Need day of week as string (Sunday, Monday ...) in Queryable where clause

c# dynamic-linq entity-framework-6 sql-server

Question

I need to check whether the provided keyword is present in the day-name of a date in the db. I have done it by using dynamic query.

ArrayList paramList = new ArrayList();
int paramCount = 0;
StringBuilder queryString = new StringBuilder();

if (keyword != null)
{
    queryString.Append(" and ClosureDate.Value.DayOfWeek.ToString().ToUpper().Contains(@" + paramCount + ")");
    paramList.Add(this.Keyword.ToUpper());
    paramCount++;
}
var abc= _context.ABC.Where(t => t.RecordStatus == 1).Select(t => t).OrderByDescending(t => t.Created).AsQueryable();
abc= abc.AsQueryable().Where(queryString[0].ToString(), searchArgs.ToArray());

This ToString() here is creating problem. I tried in other ways but, no luck. Can anyone help on it?

1
0
2/19/2020 2:00:39 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You can write your SQL Query as below. 

    DECLARE @Dates TABLE
(
  ProductID INT IDENTITY(1,1), 
  Dates DATETIME
)

INSERT INTO @Dates (Dates)
VALUES (GETDATE())
      ,(GETDATE()-1)
      ,(GETDATE()-2)
      ,(GETDATE()-3)
      ,(GETDATE()-4)
      ,(GETDATE()-5)

SELECT Dates 
FROM @Dates

SELECT Dates,DATENAME(WEEKDAY,Dates) AS DayOfWeek
FROM @Dates

Then in C#/MVC/ASP.Net App use the something like .Where(t => t.DayOfWeek.Contains("Monday")) to filter the result set.

0
2/19/2020 2:23:31 PM

Related Questions

Column names are provided at runtime in LINQ's dynamic where clause.

@Geoff has the best option, justing Dynamic LINQ....If you want to go the way of building queries at runtime using Lambda though I'd recomment that you use the PredicateBuilder (...http://www.albahari.com/nutshell/predicatebuilder.aspx...) and have something such as this:...Expression<Fun<T,bool>> pred = null; //delcare the predicate to start with....
.net dynamic-linq linq-to-sql
asked by Aaron Powell

Multiple table dynamic, Entity Data Model, Dynamic Linq Strongly typed return types, when clause

The solution to my particular query was to do this:... var query = from pl in CurrentDataSource.ProductListing join pla in CurrentDataSource.ProductListingAttribute on new {pl.ProductID, pl.WebCategoryID, pl.ParentProductID} equals new {pla.Pro...
anonymous-types c# dynamic-linq linq-to-entities
asked by rposbo

Generic method for constructing a string Dynamic Linq query. includes strings that have been tokenized

Here's what I use to do this:...using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Linq.Expressions; using System.Collections.ObjectModel; namespace MyLibrary.Extensions { /// <summary>Defines extension methods for building and working with Expressions.</summary> public static class Expressio...
dynamic-linq linq
asked by Josh M.

How to filter a collection with a dynamically formed type using the LINQ where clause

As you know the element type of your collection only at run time it probably is ...object... at compile time. So the argument to the ....Where... method has to be a ...Func<object, bool>.......Here's a piece of code that will create such a delegate given a property of the actual element type and a lambda expression on the property (which i suppose ...
dynamic-linq linq linq-to-objects observablecollection silverlight-4.0
asked by tinudu

Dynamic Linq Library can't handling one on many relationship in select clause

This should do it I think. ...var queryBuilder = (from q in db.Questions.Include(itm => itm.Answers) join a in db.Answers on q.QuestionID equals a.QuestionID where a.Email.equals(SearchCriteria) select q).Distinct().ToList(); var questionVM = new List<QuestionVM>(); foreach(var q in queryBuilder) { questionVM.add(new QuestionVM { Que...
asp.net dynamic-linq linq linq-expressions predicatebuilder
asked by Edwin van Vliet

Filter anonymous object list by executing string clause in where condition

<T>... is ...Object... because you're passing in a ...List<Object>..., and an Object doesn't have the properties on it you're looking for....If your ..._dynamicObjectList... is declared as a list of those anonymous types then the query can be executed fine, for example if you declare ..._dynamicObjectList... as:...var _dynamicObjectList = new[] { ...
c# dynamic-linq linq
asked by Geekrocket

Select Clause using System.Linq.Dynamic is returning "'(' expected" fault

The main question from your example is "what is outerIt?" (...@1.Contains(outerIt.Id)...) This looks to be just a piece of a larger query. You may want to post up the complete set of expressions....Based on an assumption of what it looks like you are after: It may be possible within a single Linq statement, but often I hit weird-isms around Linq2En...
c# dynamic-linq linq linq-to-sql
asked by Steve Py

String based Dynamic Linq - Nested Where clause

Do you want something like that;...rolesCollection = rolesCollection.Where(x => assignedUsers.Any(t => t.TypId == x.TypId)).ToList();
c# dynamic-linq
asked by lucky

How to get first day of month/year etc?

It should be possible using ...System.Linq.Dynamic.Core.......EFCore...void Main() { var r = Reservations.Select("DateTime(CheckinDate.Year,1,1)"); r.Dump(); } ...EFCore Result...EFCore Generated SQL...EF 6...For Entity Framework 6, you need to use:...var datesDynamic = ctx.Reservations.Select("DbFunctions.CreateDateTime(CheckinDate.Year, 1...
date dynamic-linq entity-framework sql-server
asked by Stef Heyenrath

Dynamic linq query having error if where clause values contain double quote

I am working on dynamic linq query which generate Where Clause based on some business rules. ...It works if input string contains result without having a double quote characters but It throws error once it contains double quote....string WhereClauseV1 = "Name.Contains(\"stack overflow\")"; --> Works for -> stack overflow string WhereClasueV2 = "...
c# dynamic dynamic-linq linq
asked by Vishal

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow