How can I use 'where property datetime' with join between 2 tables ?

Question

1.00/5 (1 vote)

See more:

The method should get the query back based on date between 01-06-2018 and 31-12-2018
what i have tried so far is right and give me back what i want but my problem how to set the date .i have a Datetime Property :

public DateTime Order_Date { get; set; }

so i should do the next :
where ph.oder_date "01-06-2018" && ph.order_date "31-12-2018"
i need help to set that insaid my query because im getting erro somehow

What I have tried:

var query = (from ph in _webshopDbContext.FXXLPurchaseHeaders
                        join pl in _webshopDbContext.FXXLPurchaseLines on ph.No_ equals pl.Document_No_
                        orderby pl.Size, pl.Colour
                        where pl.Brand == "CUBE" && ph.Ship_to_Name_2 == "Zentrallager"
                        select new LoadResults
                        {
                            GetBrand = pl.Brand,
                            GetDescription = pl.Description,
                            GetSize = pl.Size,
                            GetColour = pl.Colour,
                            GetQuantity = pl.Quantity,
                            GetNumber = pl.No_,
                            GetShipToName = ph.Ship_to_Name,
                            GetShipName2 = ph.Ship_to_Name_2,

                        });
           return query.ToList();

Posted 13-Sep-19 3:10am

Abdalla Ben Omran

Updated 13-Sep-19 5:35am

Add a Solution

2 solutions

Solution 1

have a look at these

C# Linq Where Date Between 2 Dates - Stack Overflow[^]

c# - Linq query between dates - Stack Overflow[^]

Posted 13-Sep-19 4:08am

Simon_Whale

Comments

[no name] 13-Sep-19 11:19am

so why it gives me no result with this Query :
var query = (from ph in _webshopDbContext.FXXLPurchaseHeaders

join pl in _webshopDbContext.FXXLPurchaseLines on ph.No_
equals pl.Document_No_
where pl.Brand == "CUBE" && ph.Ship_to_Name_2 == "Zentrallager" &&
ph.Order_Date.Year == 2018 && ph.Order_Date.Month == 6
orderby pl.Size, pl.Colour

and it gives me result if i remove (&& ph.Order_Date.Month == 6)

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)

Richard Deeming · Accepted Answer · 2019-09-13T05:36:00

Try this:

C#

var minDateInclusive = new DateTime(2018, 6, 1);
var maxDateExclusive = new DateTime(2019, 1, 1);

var query = from ph in _webshopDbContext.FXXLPurchaseHeaders
            join pl in _webshopDbContext.FXXLPurchaseLines on ph.No_ equals pl.Document_No_
            where pl.Brand == "CUBE" 
                  && ph.Ship_to_Name_2 == "Zentrallager"
                  && ph.Order_Date >= minDateInclusive
                  && ph.Order_Date < maxDateExclusive
            orderby pl.Size, pl.Colour
            select new LoadResults ...