How to write SQL date format Like query into LINQ Or Entity Framework

Question

I am using Entity frame work, i want to convert SQL query of LIKE date to Entity framework. here is the query

 Select * from Schedule where SerialNo='11119' and DueDate like '%2012%'

JuChom · Accepted Answer · 2013-08-22 13:11:09Z

3

Try this:

dbcontext.Schedules.Where(s => s.SerialNo == '11119' && s.DueDate.Year == 2012)

answered Aug 22, 2013 at 13:11

JuChom

6,0998 gold badges53 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

JuChom Over a year ago

What type is DueDate? You should edit your post and show us how looks like your Schedule entity.

Abdul Khaliq Over a year ago

it's sir Datetime in SQL database & here is function................... public List<Schedule> GetListBySearch(string search) { return db.Schedule.Where(s => s.SerialNo == '11119' && s.DueDate == '2012').ToList(); }

JuChom Over a year ago

Add the Schedule class to your question, we will have a better idea

Abdul Khaliq Over a year ago

Actually sir, Schedule is the table name as db.schedule & I want to get a list of history for serialno=11119 where Duedate=2012

JuChom Over a year ago

Ok, DueDate is nullable!

|

Collectives™ on Stack Overflow

How to write SQL date format Like query into LINQ Or Entity Framework

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related