datepart function in Linq

Question

0.00/5 (No votes)

See more:

I have a table "DOB",
Which have two columns "Name" and "dateOfBirth",
now i want calculate total rows(result) which have
1. jan month,2012 year,
2. feb month,2012 year,
etc,

so how i use where condition, in the same column name "dateOfBirh" ,
which is in date time formet,
like 12/7/2012 12:24:00:PM,

Plz provide solution In Linq,
because i found solution in Sql like this,

SQL

select * from TableName

where datepart(mm, DateColumnName) = 1

and datepart(yyyy, DateColumnName) = 2012

Posted 28-Dec-12 20:31pm

Arun kumar Gauttam

Updated 28-Dec-12 22:55pm

v5

Add a Solution

2 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)

Arun kumar Gauttam · Accepted Answer · 2012-12-28T22:53:00

solution is:

C#

var data1 = context.t_quoted_value.Where(x => x.region_name == "Hong Kong"
                            && x.price_date.Value.Year == dt.Year
                            && x.price_date.Value.Month == dt.Month
                            && x.price_date.Value.Day == dt.Day).ToList();

__TR__ · Accepted Answer · 2012-12-28T20:42:00

Solution 1

I am assuming that you want to retrieve all the records where date of birth is on Jan 2012 or Feb 2012. If that's the case you can use DATEPART[^] to filter your rows.
try

SQL

SELECT COUNT(*) AS TotalRows FROM DOB
WHERE (DATEPART(Month,dateOfBirth) = 1 OR DATEPART(Month,dateOfBirth) = 2) AND (DATEPART(year,dateOfBirth) = 2012)

Edit:
SqlFunctions Class[^] might help you. Take a look at SqlFunctions.DatePart Method[^].
Also check out this CP article LINQ query to compare only date part of DateTime[^]

Posted 28-Dec-12 20:42pm

__TR__

Updated 28-Dec-12 22:59pm

v3

Comments

Arun kumar Gauttam 29-Dec-12 3:13am

yes your solution is right,i want this query in linq,
and linq not support DATEPART function,

__TR__ 29-Dec-12 4:30am

SqlFunctions Class[^] might help you. Take a look at SqlFunctions.DatePart Method[^].
Also check out this CP article LINQ query to compare only date part of DateTime[^]

Arun kumar Gauttam 29-Dec-12 4:53am

thanks,your last solution is work fine,
thanks for it, i am trying for this solution at so many days,
but today i found the solution,with the help of you

__TR__ 29-Dec-12 5:00am

You are welcome. Glad it worked out for you. I have updated my answer to include those links to MSDN and the CP article so that it will be helpful for anyone referring this thread in the future.

Wendelius 2-Jan-13 3:36am

Good answer, 5.

__TR__ 2-Jan-13 5:37am

Thank you.
Happy new year :)

Wendelius 2-Jan-13 14:25pm

Thanks, Happy New Year to you too :)