Perform search by Date using entity framework

Question

4.00/5 (1 vote)

See more:

I try to make search query in Entity framework. I have table Project with 'Id', 'ProjectName', 'Description' and "modificationdate" etc. I want to perform search on 'ProjecName', 'Description' and "modificationdate". I successfully perform search on 'ProjectName' & 'Description' but i don't know how perform search by date

SQL

var found = from n in context.Project
                            where n.projectName.Contains(SearchKey) ||                                                               n.description.Contains(SearchKey) 
                        select n;

Please Help!

Posted 27-Oct-13 23:56pm

Vi(ky

Updated 31-Mar-20 21:11pm

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sampath Lokuge · Answer 1 · 2013-10-28T00:04:00

Solution 1

You can use like below:

SQL

var found = from n in context.Project
                            where n.projectName.Contains(SearchKey) ||                                                               n.description.Contains(SearchKey) || n.modificationdate.ToShortDateString().Contains(EntityFunctions.TruncateTime(SearchKey))
                        select n;

I hope this will help to you.

Posted 28-Oct-13 0:04am

Sampath Lokuge

Updated 28-Oct-13 0:17am

v2

Comments

Vi(ky 28-Oct-13 6:08am

n.modificationdate.Contains is not occuer

Sampath Lokuge 28-Oct-13 6:09am

what do you mean by not occuer ?

Vi(ky 28-Oct-13 6:13am

.Contains option is coming to use it when typing the code

Sampath Lokuge 28-Oct-13 6:17am

I have updated. Plz check that.

Vi(ky 28-Oct-13 6:40am

error: "The best overloaded method match 'string.Contains(string)' has some invalid arguments"

Sampath Lokuge 28-Oct-13 6:45am

Can you put your last Query on your post ?

Vi(ky 28-Oct-13 6:58am

public IEnumerable<Project> SearchByKey(string SearchKey)
{
var context = new MyDbEntities();

var matches = from m in context.Project
where m.projectName.Contains(SearchKey) || m.description.Contains(SearchKey) || m.modificationDate.ToShortDateString().Contains(EntityFunctions.TruncateTime(SearchKey))
select m;
return matches;
}

Sampath Lokuge 28-Oct-13 7:08am

What's your 'SearchKey' value when you have above error ? and why didn't use 'ToShortDateString()' ?

Vi(ky 28-Oct-13 7:22am

Error: Cannot convert from 'System.DateTimeOffset?' to 'string' and searchkey value is 12/01/2012

Sampath Lokuge 28-Oct-13 7:24am

I couldn't get what you say.Can you give more information ?

Sampath Lokuge 28-Oct-13 7:25am

Is 12/01/2012 pass as string or datetime ?

Vi(ky 28-Oct-13 7:29am

as string

Sampath Lokuge 28-Oct-13 7:40am

Look at this one :http://mrclyfar.blogspot.com/2011/07/tip-for-writing-entity-framework.html

Sampath Lokuge 28-Oct-13 7:46am

Another one :http://forums.asp.net/t/1848300.aspx

Code Help 2014 · Answer 2 · 2014-04-08T00:37:00

Solution 2

Check this sample application:

Entity Framework for Beginners[^]

Posted 8-Apr-14 0:37am

Code Help 2014

Updated 8-Apr-14 0:46am

v2

Member 14788967 · Answer 3 · 2020-03-31T21:12:00

first of all your submitting datetime should include .Date Keyword it makes your time to 1200 or 0000000
like that

ent.Receiving_Date = dateTimePicker1.Value.Date;

In database it will look like that
2020-04-01 00:00:00.000

Now you are going to Search or filter the data on the base of date then you will also give .Date here with datetimePicker as given below ;

var dd=db.tbl_Doner.Where(x => x.Receiving_Date==dateTimePicker1.Value.Date).ToList();
dataGridView1.DataSource = dd;

I hope it will work
I have got it about half an hour before posting to you, after spending alot of time on it.During search I found above answers but not working in first approach of EF.so best of Luck